Senior Data Modeler

Job Title:

Senior Data Modeler

Location:

Sacramento, CA | On-site Hybrid

Local Candidates Only (Within 60 Miles)

(Candidates must currently reside within 60 miles of Sacramento, CA. Anyone outside this radius will be rejected.)

Onsite Requirement:
Mondays and Wednesdays (2 days per week)

Interviews:
Team Viewer

Visa:
Any

Mandatory:
Candidates must have a Linked In profile with a picture or they will be rejected.

We are seeking an experienced Senior Data Modeler to support enterprise‑level data warehouse initiatives for the State of California. This hybrid position requires on‑site work in Sacramento every Monday and Wednesday, and candidates must currently live within a 60‑mile commuting distance.

The ideal candidate will have extensive hands‑on experience in enterprise data modeling, data warehousing, relational and dimensional modeling, Oracle technologies, and will be able to perform both business analysis and technical design. This role requires a strong grasp of the Kimball dimensional modeling framework, exceptional analytical skills, and the ability to collaborate effectively with cross‑functional teams.

• Develop conceptual, logical, and physical data models for enterprise data warehouse environments.
• Design and document relational, dimensional, and hybrid data models (Star, Snowflake, etc.).
• Create detailed Data Facts and Dimensions aligned with EDW standards.
• Support and document Kimball Dimensional Data Modeling methodology.
• Work closely with architects to translate logical models into optimized physical models.

• Perform business and systems analysis to gather, validate, and document requirements.
• Prepare Requirements Specifications and Design Specifications.
• Visualize and document enterprise data management processes, including data planning, acquisition, usage, archiving, retrieval, control, and purging.
• Create data flow diagrams to support report design and optimization.

• Contribute to large‑scale EDW implementation projects.
• Conduct data analysis and predictive data modeling.
• Mentor team members on industry standards, best practices, and modeling techniques.

• Work with Oracle/ODI/OCI environments, including Oracle Autonomous Data Warehouse (ADW).
• Perform ETL development using Oracle tools and PL/SQL.
• Provide technical leadership across data warehousing activities (ETL, requirements, DBA coordination, administration, and analysis).

• 10 years of experience in data management, including 5 years in database design and 5 years in data modeling.
• 5 years as a data analyst or equivalent role supporting large data initiatives.
• 5 years of hands‑on experience with ER/Studio for data modeling.
• Strong experience in relational and dimensional modeling, statistical analysis, and machine learning concepts.
• Experience designing Star, Snowflake, and hybrid schema models.
• Proficiency with Oracle, ODI, OCI, and ADW technologies.
• Excellent communication and collaboration skills.

• 2 years of experience working specifically with Oracle Autonomous Data Warehouse in OCI.
• Expert‑level knowledge of the Kimball Dimensional Modeling framework.
• Advanced experience developing in Oracle SQL Developer or ER/Studio Data Architect.
• 2 years of ETL development experience using Oracle tools and PL/SQL.
• Ability to lead an Oracle‑based data warehouse team across ETL, requirements gathering, DBA coordination, admin, and analytics