Data Analyst/Data Modeler

Title: Sr. Data Analyst/Data Modeler

Location: Sacramento, CA (Mon & Wed/ 2 Days Onsite)

Duration: 12+ Months    

Client: Loblolly/State of CA  

DESCRIPTION:

Requirements:

·      Senior, hands-on data modeler with strong communication skills.

·      Expert level command of ER/STUDIO Data Architect modeling application

·      Strong ability to articulate data modeling principles and gather requirements from non-technical business stakeholders

·      Excellent presentation skills to different (business and technical) audiences ranging from senior level leadership to operational staff with no supervision

·      Ability to translate business and functional requirements into technical requirements for technical team members.

·      Candidate needs to be able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.

Key Duties/Responsibilities:

·      Performs business and systems analysis and documentation

·      Develops conceptual, logical, and physical relational data models for the enterprise data warehouse

·      Experience with large data warehouse implementation projects

·      Performs data modeling in relational and dimensional models

·      Develops physical data model and/or works with architect to develop physical data model

·      Ability to expertly develop Data Facts and Dimensions in the EDW

·      Provides documentation to support the Kimball Dimensional Data Modeling Framework, as necessary

·      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 ten (10) years demonstrable experience in the data management space with at least 5 years specializing in database design

·      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 demonstrated experience with ER/Studio data modeling application

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

·      At least 2 years experience working on Star, Snowflake, and/or Hybrid schemas

Desired:

·      At least 2 years experience working on Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCI environment.

·      Expert level Kimball Dimensional Data Modeling experience

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

·      Ability to develop and perform Extract, Transform and Load (ETL) activities using Oracle tools with at least 2 years experience.Ability to perform technical leadership of a Oracle data warehouse team including but not limited to ETL, requirements solicitation, DBA, data warehouse administration, and data analysis on a hands-on basis.