Senior Data Analyst / Data Modeler
Senior Data Analyst / Data Modeler
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
We are seeking a senior hands-on Dat Analyst / Data Modeler with strong communication skills for a long term hybrid assignment with our Sacramento California based client. This position requires that you be able to work on-site in Sacramento California for at least 2 days/wk as determined by the client.
Candidates must currently live within 60 miles maximum from Sacramento CA
Key Duties/Responsibilities:
- Performs business and systems analysis and documentation
- Develops conceptual logical and dimensional 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
- Develops Data Facts and Dimensions in the EDW
- Provides documentation to support the Kimball Dimensional Data Modeling Framework
- 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
Requirements:
- Excellent communication and collaboration skills to work effectively with stakeholders and team members.
- Ability to demonstrate direct hands-on recent practical experience in the areas identified with specific examples.
- Minimumof 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 in the job description above.
- 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 in the job description above.
- At least 2 years experience working on Star Snowflake and/or Hybrid schemas
- 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.
Desired:
- At least 2 years experience working on Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCIenvironment.
- 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 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.
Required Experience:
Senior IC
Employment Type
Contract
