Logo
eStaff LLC

Data Modeler

eStaff LLC, Sacramento, California, United States, 95828

Save Job

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,000.00 1 month ago Principal Controls Engineer- Data Center

Sacramento, CA $150,000.00-$220,000.00 2 weeks ago Global Fixed Income Administrative and Data Analyst

Staff Engineer - Finance Data Specialist (Remote)

Sacramento, CA $115,000.00-$260,000.00 2 weeks ago Investment Data Analyst- Investment Operations

Sacramento, CA $7,760.00-$9,713.00 3 weeks ago Data Analyst - Staffing Solutions & Retention Office

Folsom, CA $100,150.00-$750,003.00 2 weeks ago Staff Engineer - Finance Data Specialist (Remote)

Folsom, CA $63,000.00-$750,003.00 3 days ago Sacramento, CA $6,453.00-$8,083.00 2 weeks ago Senior Applications Developer (Enterprise Applications/eCAPS Finance)

Sacramento, CA $75,000.00-$120,000.00 1 month ago Rocklin, CA $10,000.00-$195,200.00 6 days ago Sacramento, CA $6,752.00-$8,452.00 2 weeks ago Regulatory Data Specialist | Research Data Specialist II, JC-489279

Demographic and Planning Projections Expert

Sacramento, CA $125,000.00-$145,000.00 2 weeks ago Python and Kubernetes Software Engineer - Data, AI/ML & Analytics

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

#J-18808-Ljbffr