Data Analyst / Data Modeler
3B Staffing LLC, Sacramento, CA, United States
- ONLY send candidates who currently live within 60 miles maximum from Sacramento, CA
Candidates must have a LinkedIn profile with a picture of anyone without will be rejected
Any Visa
Team Viewer Interviews
ALWAYS provide your consultants with full name-(What is on their Visa), resume, phone number, Skype address, rate, email address, and location. Without the information requested, we cannot move forward.
Please do not call or send follow-up emails, as that will only slow down our ability to respond to you quickly.
Description
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 that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.
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
Development Requirements Specifications
Develop Design Specifications
Performs data analysis/predictive data modeling
Mentors and Education 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.
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 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
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 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.
Candidates must have a LinkedIn profile with a picture of anyone without will be rejected
Any Visa
Team Viewer Interviews
ALWAYS provide your consultants with full name-(What is on their Visa), resume, phone number, Skype address, rate, email address, and location. Without the information requested, we cannot move forward.
Please do not call or send follow-up emails, as that will only slow down our ability to respond to you quickly.
Description
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 that you be able to work on-site in Sacramento, California for at least 2 days/wk as determined by the client.
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
Development Requirements Specifications
Develop Design Specifications
Performs data analysis/predictive data modeling
Mentors and Education 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.
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 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
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 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.