Job Details

Hello,

Hope you are doing well

Job Title: Data Modeler
Location: Sacramento, CA (Hybrid - onsite work required)
Contract: Long Term

Job Description:

Location: Sacramento, CA (Hybrid - onsite work required)
• Mon & Wed in office required
• Must live within 60-90 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.

Regards

Shyam kumar

...@my3tech.com