Senior Data Analyst / Data Modeler

We are seeking a senior, hands-on Data Analyst / Data Modeler with strong communication skills for a long-term hybrid assignment with our Sacramento, California-based client. This position requires on-site work in Sacramento, California, for at least 2 days / wk, as determined by the client. Candidates must currently live within 60 miles of Sacramento, CA.

Key Duties / Responsibilities : -Performs business and systems analysis and documentation-Develops conceptual, logical, and dimensional data models for the enterprise data warehouse-Experience with large data warehouse implementation projects-Performs data modeling in relational and dimensional models-Develops a physical data model and / or works with the architect to create a 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

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 a 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 of experience working on Star, Snowflake, and / or Hybrid schemas-Oracle / ODI / OCI / ADW experience required

Desired : -At least 2 years of 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 and PL / SQL with at least 2 years of experience. Ability to perform technical leadership of an Oracle data warehouse team, including but not limited to ETL, requirements solicitation, DBA, data warehouse administration, and data analysis on a hands-on basis.