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 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.
Requirements :
- Senior, hands-on data model 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.
Qualifications : Mandatory :
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.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 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 of experience working on Star, Snowflake, and / or Hybrid schemasOracle / ODI / OCI / ADW experience requiredDesired :
At least 2 years of 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 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.