Apply Now

Analytics Specialist

Sacramento, CA, US • Posted 22 hours ago • Updated 23 minutes ago

Full Time

Travel Required

On-site

Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

ETL
Erwin
AI
SNOWFLAKE
Data Definition Language

Summary

About this Position:

Job Title: Analytics Specialist

Key responsibilities include:

Data Modeling and Design Develop and maintain traditional data models for relational databases; Design application-supporting data models using advanced methodologies such as relational modeling, medallion architecture, and data modeling for cloud environments; Create data models tailored for artificial intelligence machine learning use cases specific to client's needs.
Tool Proficiency Utilize Erwin Data Modeler software to design and maintain data models; Utilize Power BI to model data for visualization and analytics.
Publishing and Documentation Support publishing and maintenance of data models on the intranet for organizational access; Create, document, and maintain analytical models to ensure data literacy and usability by business users.
Knowledge Transfer Provide data modeling knowledge transfer sessions to ITSB team members and key business stakeholders, ensuring they understand and can apply relevant concepts and practices, and take ownership of all models created by the contractor.
Advise the development and maintenance of data models by state staff.

Qualifications:

Extensive experience in designing, developing, and maintaining complex data models in Snowflake.
Extensive knowledge of Power BI, including data modeling, data warehousing concepts, ETL/ELT processes, report development, and performance optimization.
Extensive experience in designing, developing, and maintaining complex relational data models, including working with Oracle databases and managing Data Definition Language (DDL) scripts.
Extensive experience in designing, developing, and maintaining AI/Machine Learning-specific data models.
Extensive experience with Erwin Data Modeler.
Experience working with state agencies that provide pension and health benefits.

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.

Dice Id: 10530468
Position Id: 2026-21343
Posted 22 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Analytics Specialist (Data Modeler)

Sacramento, California

•

Today

Position: Analytics Specialist (Data Modeler) Location: Sacramento, CA 95811 Work Mode: Onsite Interview: In-person Duration: approx. 12 months Position Summary: The Analytics Specialist will be responsible for designing and implementing comprehensive data models that support CalPERS' analytics and business needs. Their work will encompass creating models that consist of data pipelines, the structure of the data, physical and virtual instances of the data, and optimizing for the analyt

Easy Apply

Third Party, Contract

Analytics Specialist

Sacramento, California

•

Today

Job Title: Analytics Specialist Durations : 6+ months Location: 400 Q Street, Sacramento, CA 95811 The scope of this project encompasses the following tasks: Deliverable 1: Design, Develop, and Maintain Relational, Cloud-Based, Power BI, and AI/ Machine Learning-Specific Data Models. The consultant will design, develop, and maintain data models tailored to meet the organization's needs. This includes creating relational data models to support traditional reporting and analytics, as well as clo

Easy Apply

Contract

Depends on Experience

7206 - Senior Analytics Specialist (Must Reside in Sacramento to be Considered)

Sacramento, California

•

Today

7206 - Senior Analytics Specialist (Must Reside in Sacramento to be Considered) Job Description: Seeking an experienced Senior Analytics Specialist to design, develop, and maintain enterprise data models that support advanced analytics, reporting, and business intelligence initiatives. This role is responsible for building scalable data solutions across relational and cloud-based environments, optimizing data structures for performance, and enabling insights through modern analytics tools. The i

Easy Apply

Contract

$50+

Senior Data Analyst / Data Modeler

Hybrid in Sacramento, California

•

Yesterday

Role: Data Modeler Only Local to CA Location:Local to Sac, CA preferred. Hybrid work required. 2 days required in-office (Monday & Wednesday) Certs: Oracle ODI & ADW & OCI experience Senior Data Analyst / Data Modeler: Requirements: Senior, hands-on data modeler with strong communication skills.Expert level command of ER/STUDIO Data Architect modeling applicationStrong ability to articulate data modeling principles and gather requirements from non-technical business stakeholdersExcellent presen

Easy Apply

Contract

65 - 70

Search all similar jobs