Data Modeler

Data Modeler
ODI & ADW & OCI experience
Required to have State/Gov experience
Certifications - Oracle

Location: Local to Sac CA preferred. Hybrid work required.

• Two days a week in office required. Monday and Wednesday each week.
• Must live within 60 miles maximum from location

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 and PLL SQL/SQL 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.