Senior Data Analyst Data Modeler

Project Title: Data Warehouse Consulting Services
Client: California Department of Transportation
Job Code: RFO#20A0350/1
Duration: 1 year
Location: Sacramento CA(Hybrid)

Senior Data Analyst / Data Modeler

The Senior Data Analyst / Data Modeler is responsible for analyzing complex data sets developing data models and providing actionable insights to support datadriven decisionmaking. This role involves designing and implementing data models and ensuring the accuracy and integrity of the data.

Responsibilities:

• Must have a minimum of five (5) years of experience as a data analyst.
• Five (5) years Kimball Dimensional Data Modeling experience.
• Five (5) years experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle
• Experience in developing conceptual logical and physical data models.
• Plan organize and analyze data in the EDW to perform predictive data modeling perform analytical processing create dashboards and reports.
• Design and develop conceptual logical and physical data models to meet business requirements.
• Ensure data models are scalable maintainable and aligned with best practices and industry standards.
• Maintain and expand as necessary the data model(s)
• Utilize dimensional data modeling (Kimball preferred)
• Extract Transform and Load (ETL) data from sources to targets in the data warehouse.
• Proficiency with ER/Studio Data Architect Professional software a benefit
• Experience with:
  • Requirement Specifications
  • Design Specifications
  • Conceptual data models
  • Logical data models
  • Physical data models
  • ETL scripts
  • Data dictionary(ies)
  • Source to target mapping.
  • Data flow diagrams