Senior Data Analyst Data Modeler
Share
Job Location:
Sacramento, CA - USA
Monthly Salary:
Not Disclosed
Posted on:
13 hours ago
Vacancies:
1 Vacancy
Job Summary
We are seeking a Senior Data Modeler in the Sacramento California area. 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. Anyone else will be rejected.
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 a physical data model and/or works with the architect to develop a 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 specifying 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
- Development Requirements Specifications
- Develop Design Specifications
- Performs data analysis/predictive data modeling
- Mentors and education team members on best practices and industry standards
Mandatory Requirements:
* 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.
* Senior hands-on Data Modeler with strong communication skills.
* Expert-level command of the ER/STUDIO Data Architect modeling application
* Must have Oracle Data Integrator (ODI) experience.
* At least 2 years experience working in Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCI environment
* Strong ability to articulate data modeling principles and gather requirements from non-technical business stakeholders
* 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.
* 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.
* Excellent presentation skills to different (business and technical) audiences ranging from Senior-level leadership to operational staff with no supervision
* At least 2 years of experience working on Star Snowflake and/or Hybrid schemas
* 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 identified areas with specific examples.
Desired:
* 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 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.
* 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.
* Senior hands-on Data Modeler with strong communication skills.
* Expert-level command of the ER/STUDIO Data Architect modeling application
* Must have Oracle Data Integrator (ODI) experience.
* At least 2 years experience working in Oracle Autonomous Data Warehouse (ADW) specifically installed in an OCI environment
* Strong ability to articulate data modeling principles and gather requirements from non-technical business stakeholders
* 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.
* 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.
* Excellent presentation skills to different (business and technical) audiences ranging from Senior-level leadership to operational staff with no supervision
* At least 2 years of experience working on Star Snowflake and/or Hybrid schemas
* 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 identified areas with specific examples.
Desired:
* 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 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.
Required Experience:
Senior IC
Key Skills
- Data Analytics
- Microsoft Access
- SQL
- Power BI
- R
- Data Visualization
- Tableau
- Data Management
- Data Mining
- SAS
- Data Analysis Skills
- Analytics
About Company
Are you looking to hire? At eStaff LLC, we take all of the stress out of the search, with our experienced job recruiters able to staff all types of technical positions with highly skilled professionals. 24 hour on call.
