Current jobs related to Data Modeler/Analyst - Sacramento, California - Quantum Solutions

  • Data Analyst

    2 weeks ago

    Sacramento, California, United States Capio Group Full time $100,000 - $120,000 per year

    Capio Group is looking for an experienced Data AnalystFull-time employee - SacramentoSalary: $110,000 - $120,000About Us:Capio Group is a California-based Information Technology Consulting firm serving the public sector since 2010. We assist the Government in delivering large, complex systems and solutions. Capio Group is a small, but quickly growing firm...

  • Data Analyst

    4 hours ago

    Sacramento, California, United States Capleoglobal Inc Full time

    Title: Data AnalystSpecialty: Non-Clinical - Information TechnologyLocation: Sacramento, CA 95816Duration: 13 WeeksShift: Day 5x8-Hour (08:00 - 17:00)Pay Rate: $48 - $50/hr on w2Description:Remote but prefer candidates local to Sacramento greater areaPosition Summary:The Data Analyst II supports the Food & Nutrition Services department across Sutter Health...

  • Managed Care Data Analyst

    2 weeks ago

    Sacramento, California, United States Jobs via Dice Full time

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Kavaliro, is seeking the following. Apply via Dice todayOur client is looking for a Managed Care Data Analyst for a contract scenario. The Managed Care Analyst provides data and analyses, including financial modeling and forecasting, to support administration...

  • Need Locals/Nearbys to Sacramento,CA ORACLE CERTIFIED-Data Modeler

    2 days ago

    Sacramento, California, United States My3Tech Full time

    Hello,Position: Data ModelerLocation: Sacramento, CA (Hybrid)This position is with State client, Can work on C2C/on W2.***Location: Local to Sacramento, CA preferred. Hybrid work required.***Two days a week in office required.Monday and Wednesday each week.***Must live within 60 miles maximum from location.Required to have State/Gov experienceCertifications:...

  • Senior Data Analyst

    1 week ago

    Sacramento, California, United States California Governor's Office of Emergency Services Full time $83,000 - $140,000 per year

    Job Description And DutiesAre you looking for an exciting and fast-paced career?Join the California Governor's Office of Emergency Services (Cal OES) and be part of an organization that serves as a leader in emergency management and homeland security through dedicated service to all. We are looking for enthusiastic and motivated individuals to join our team....

  • Workforce Data Analyst

    2 weeks ago

    Sacramento, California, United States California Public Employees' Retirement System (CalPERS) Full time $80,000 - $120,000 per year

    The California Public Employees' Retirement System (CalPERS) is the nation's largest public pension fund, providing retirement and health benefits to public employees, retirees, and their families. Headquartered in downtown Sacramento, we are a destination employer with an international reputation for leadership and innovation. At CalPERS, we're committed to...

  • Workforce Data Analyst

    2 weeks ago

    Sacramento, California, United States CalPERS Full time $80,000 - $120,000 per year

    Equal Opportunity EmployerThe State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin,...

  • Supply Chain Analyst

    2 weeks ago

    Sacramento, California, United States Hallmark Global Solutions Ltd Full time $80,000 - $120,000 per year

    Title:Supply Chain AnalystLocation:Remote (preferred candidates in Pacific time zone).Duration:Multi-year project assignment supporting Workday transition.Local candidate profile required.Visa independent consultant required.Position Summary:The Supply Chain Analyst III supports system-wide sourcing and master data initiatives within Client's Enterprise...

  • Senior Informatica Data Analyst

    2 weeks ago

    Sacramento, California, United States Optum Full time $89,900 - $160,600 per year

    Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers,...

  • research data analyst ii

    11 hours ago

    Sacramento, California, United States California Department of Social Services Full time

    Position DetailsJob Code #:JC-497991Position #(s): Working Title:RDA IIClassification::RESEARCH DATA ANALYST II$6, $8,325.00 ANew to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.# of Positions:1Work Location:Sacramento CountyTelework:HybridJob Type::12 Month Limited Term - Full...

Data Modeler/Analyst

2 weeks ago

Sacramento, California, United States Quantum Solutions Full time $75,000 - $150,000 per year

Position Senior Data Modeler/ Analyst

Location Sacramento, CA

Duration Long Term Contract

Key Responsibilities

Requirements:

  • Senior, hands-on data modeler with strong communication skills.
  • Expert level command of ER/STUDIO Data Architect modeling application
  • 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.
  • Candidate needs to be able to demonstrate, direct hands-on recent practical experience in the areas identified with specific examples.

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 physical data model and/or works with architect to develop 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: 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

Qualifications:

Mandatory:

  • 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 above.
  • Minimum of five (5) years of demonstrated experience with ER/Studio data modeling application
  • 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.
  • Excellent communication and collaboration skills to work effectively with stakeholders and team members.
  • At least 2 years' experience working on Star, Snowflake, and/or Hybrid schemas

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 and PLL SQL/SQL 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.

Job Type: Contract

Pay: $ $75.00 per hour

Expected hours: 40 per week

Experience:

  • Oracle Autonomous Data Warehouse : 5 years (Required)
  • ER/STUDIO: 5 years (Required)
  • EDW: 5 years (Required)
  • Database design: 5 years (Required)
  • ETL: 5 years (Required)
  • Oracle Cloud Infrastructure: 3 years (Required)
  • Oracle Data Integrator: 3 years (Required)

Work Location: On the road