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 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.

Thanks & Regards.

Manikanta Yerra

• 1 605-808-0076

Technical Recruiter

1601 N Harrison Ave, STE # 2B, Pierre, SD 57501

Email : Manikanta.yerra@my3tech.com

Our thoughts hold the power to build, bend or break our circumstances.

Certified Minority Business Enterprise (MBE)

An E-Verify Company

DISCLAIMER : The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and / or privileged material. Any review, re-transmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer or if you want to be REMOVED please reply with REMOVE in the Subject line of this email.