Data Analyst Data Modeler

Hello Professionals

Hope you are doing well

Data Analyst/Data Modeler
Client: State of CA (CalTrans)
Location: Sacramento CA (Hybrid onsite work required)
Mon & Wed in office required
Must live within 6090 miles minimum from location

Key Duties/Responsibilities:

Performs business and systems analysis and documentation
Develops conceptual and dimensional data models for the enterprise data warehouse
Performs data modeling in relational and dimensional models
Develops physical data model and/or works with architect to develop physical data model
Develops Data Facts and Dimensions in the EDW
Provides documentation to support the Kimball Dimensional Data Modeling Framework
Visualizes and designs the enterprise data management framework: specifies processes used to plan acquire maintain use archive retrieve control and purge data
Documents data flow diagrams in existing and future reports to use as input in report design and optimization
Develops Requirements Specifications
Develops Design Specifications
Performs data analysis/predictive data modeling
Mentors and educates team members on best practices and industry standards

Qualifications:

Mandatory:

Minimum of five (5) years of experience as a data analyst or in other quantitative analysis or related disciplines such as researcher or data engineer supportive of key duties/responsibilities identified above.
Minimum of five (5) years of relevant experience in relational data modeling and dimensional data modeling statistical analysis and machine learning supportive of key duties/responsibilities identified above.
Excellent communication and collaboration skills to work effectively with stakeholders and team members.

Desired:

Expert level Kimball Dimensional Data Modeling experience
Expert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.