Data Modeler - Sacramento - E-Staff

Description

This range is provided by eStaff LLC. Your actual pay will be based on your skills and experience talk with your recruiter to learn more.

Base pay range

$60.00/yr - $65.00/yr

Direct message the job poster from eStaff LLC

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.

Candidates must currently live within 60 miles of Sacramento, CA

We can work with C2Cs

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 a physical data model and/or works with the architect to create a 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 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
• 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 a 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.
• 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 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Staffing and Recruiting

Referrals increase your chances of interviewing at eStaff LLC by 2x

Sign in to set job alerts for Data Modeler roles.

Sacramento, CA $140,000.00-$160, month ago

Principal Controls Engineer- Data Center

Sacramento, CA $150,000.00-$220, weeks ago

Global Fixed Income Administrative and Data Analyst

Staff Engineer - Finance Data Specialist (Remote)

Sacramento, CA $115,000.00-$260, weeks ago

Investment Data Analyst- Investment Operations

Sacramento, CA $7,760.00-$9, weeks ago

Data Analyst - Staffing Solutions & Retention Office

Folsom, CA $100,150.00-$750, weeks ago

Staff Engineer - Finance Data Specialist (Remote)

Folsom, CA $63,000.00-$750, days ago

Sacramento, CA $6,453.00-$8, weeks ago

Senior Applications Developer (Enterprise Applications/eCAPS Finance)

Sacramento, CA $75,000.00-$120, month ago

Rocklin, CA $10,000.00-$195, days ago

Sacramento, CA $6,752.00-$8, weeks ago

Regulatory Data Specialist | Research Data Specialist II, JC

Demographic and Planning Projections Expert

Sacramento, CA $125,000.00-$145, weeks ago

Python and Kubernetes Software Engineer - Data, AI/ML & Analytics

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr