Data Modeler with ODI & ADW & OCI_60 miles from Sacramento, CA_Oracle Certification Required

Data ModelerStart date: ASAPRequired to have State/Gov experienceCerts: OracleODI & ADW & OCI experience 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 locationRequirements:Senior, hands-on data modeler with strong communication skills.Expert level command of ER/STUDIO Data Architect modeling applicationStrong ability to articulate data modeling principles and gather requirements from non-technical business stakeholdersExcellent presentation skills to different (business and technical) audiences ranging from senior level leadership to operational staff with no supervisionAbility 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 documentationDevelops conceptual, logical, and physical relational data models for the enterprise data warehouseExperience with large data warehouse implementation projectsPerforms data modeling in relational and dimensional modelsDevelops physical data model and/or works with architect to develop physical data modelAbility to expertly develop Data Facts and Dimensions in the EDWProvides documentation to support the Kimball Dimensional Data Modeling Framework, as necessaryVisualizes and designs the enterprise data management framework: specifies processes used to plan, acquire, maintain, use, archive, retrieve, control, and purge dataDocuments data flow diagrams in existing and future reports to use as input in report design and optimizationDevelops Requirements SpecificationsDevelops Design SpecificationsPerforms data analysis/predictive data modelingMentors and educates team members on best practices and industry standardsQualifications:Mandatory:Minimum of ten (10) years demonstrable experience in the data management space with at least 5 years specializing in database designMinimum 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 applicationMinimum 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 schemasDesired:At least 2 years experience working on Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCI environment.Expert level Kimball Dimensional Data Modeling experienceExpert 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.

Salary : $59 - $76