Need Locals/Nearbys California Data Modeler

Hello, Position: Data Modeler Location: Sacramento, CA (Hybrid) This position is with State client, Can work on C2C/on W2. • • • Location: Local to Sacramento, 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. Required to have State/Gov experience Certifications: Oracle ODI & ADW & OCI experience 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 • 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 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. --- Thanks Srujana Email: srujana.b@my3tech.com | 6056742119