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 that you be able to work on-site in Sacramento, California, for at least 2 days/wk as determined by the client. Candidates must currently live within 60 miles of Sacramento, CA We can work with C2Cs 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 specifying 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 • Development Requirements Specifications • Develop Design Specifications • Performs data analysis/predictive data modeling • Mentors and Education team members on best practices and industry standards Requirements: • Excellent communication and collaboration skills to work effectively with stakeholders and team members. • Ability to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples. • 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 in the job description 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 in the job description above. • At least 2 years' experience working on Star, Snowflake, and/or Hybrid schemas • 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. 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 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.