We are seeking a Senior Data Modeler in the Sacramento, California area. This position requires you to be able to work on-site in Sacramento, California, on Mondays and Wednesdays each week. Candidates must currently live within 60 miles of Sacramento, CA. Anyone else will be rejected.
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 a physical data model and/or works with the architect to develop a 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, 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
Mandatory Requirements:
* Minimum of ten (10) years demonstrable experience in the data management space, with at least 5 years specializing in database design and at least 5 years in data modeling.
* Senior, hands-on Data Modeler with strong communication skills.
* Expert-level command of the ER/STUDIO Data Architect modeling application
* Must have Oracle Data Integrator (ODI) experience.
* At least 2 year's experience working in Oracle Autonomous Data Warehouse (ADW), specifically installed in an OCI environment
* Strong ability to articulate data modeling principles and gather requirements from non-technical business stakeholders
* 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.
* 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.
* Excellent presentation skills to different (business and technical) audiences, ranging from Senior-level leadership to operational staff, with no supervision
* At least 2 years of experience working on Star, Snowflake, and/or Hybrid schemas
* 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 identified areas, with specific examples.
Required to have State/Gov experience
Desired:
* 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.