7079 - Senior Data Modeler / Analytics Specialist (Must reside in Sacramento, CA to be considered)

  • Sacramento, CA
  • Posted 1 day ago | Updated 1 day ago

Overview

Hybrid
$40+
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required

Skills

Advanced Analytics
Artificial Intelligence
Business Intelligence
Cloud Computing
Collaboration
Communication
Data Architecture
Data Modeling
Data Structure
Data Warehouse
Dimensional Modeling
Documentation
ELT
ERwin
Extract
Transform
Load
Facilitation
Knowledge Transfer
Machine Learning (ML)
Microsoft Power BI
Oracle
Performance Tuning
Relational Databases
Reporting
Snow Flake Schema
Training

Job Details

Job Title: Senior Data Modeler / Analytics Specialist
Location: Hybrid Sacramento, CA (onsite presence required)
Duration: 12 Months (with possible extension)

Job Description:
We are seeking a highly skilled Senior Data Modeler / Analytics Specialist to support enterprise-level data initiatives focused on business intelligence, cloud platforms, and AI/ML integration. The ideal candidate will have deep experience designing and optimizing data models across relational, cloud-based, and advanced analytics environments, as well as strong collaboration and documentation skills.

Key Responsibilities:

  • Design, develop, and maintain data models for relational databases, cloud platforms, and AI/ML use cases

  • Build optimized data models for Power BI to enable scalable and efficient reporting and analytics

  • Apply modern data architecture concepts such as medallion architecture and ELT pipelines

  • Leverage Erwin Data Modeler for data structure design and maintenance

  • Develop comprehensive documentation including ER diagrams, data dictionaries, and model usage guides

  • Conduct knowledge transfer sessions and hands-on training for internal teams

  • Publish models and supporting materials to centralized platforms for broad organizational access

Required Skills and Qualifications:

  • Strong experience designing complex data models in Snowflake, Oracle, or other enterprise RDBMS

  • Expertise in Power BI data modeling, performance tuning, and DAX

  • Familiarity with AI/ML data modeling concepts, including feature engineering and data prep workflows

  • Hands-on experience with Erwin Data Modeler

  • Proficiency in data warehousing, dimensional modeling, and ETL/ELT pipelines

  • Excellent communication skills and the ability to explain complex concepts to both technical and non-technical audiences

  • Experience preparing detailed documentation and facilitating stakeholder training sessions

Work Environment:
This is a hybrid role. Candidates must be able to report onsite as needed

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.