Senior Data Analyst

1 week ago

Sacramento, CA, United States My3Tech Inc Full time

Hello,

Hope you are doing good.

Position: Senior Data Analyst / Data Modeler

Location: Sacramento, CA (Hybrid)

Duration: 12+ Months

Client: Loblolly/State of CA

Job Description:

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 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.

  • Business Data Analyst

    2 weeks ago

    Sacramento, CA, United States ZEEKTEK Full time

    Job Description: Business Data Analyst, Data Insights ROLE The Business Data Analyst is a blend of User Experience, Business Analyst and a Data Analyst with excellent documentation skills. You will play a pivotal role in bridging the gap between business needs and technical solutions within our organization. You will collaborate closely with stakeholders to...

  • Business Data Analyst

    2 weeks ago

    Sacramento, CA, United States ZEEKTEK Full time

    Job Description: Business Data Analyst, Data Insights ROLE The Business Data Analyst is a blend of User Experience, Business Analyst and a Data Analyst with excellent documentation skills. You will play a pivotal role in bridging the gap between business needs and technical solutions within our organization. You will collaborate closely with stakeholders to...

  • Business Data Analyst

    2 days ago

    Sacramento, CA, United States ZEEKTEK Full time

    Job Description: Business Data Analyst, Data Insights ROLE The Business Data Analyst is a blend of User Experience, Business Analyst and a Data Analyst with excellent documentation skills. You will play a pivotal role in bridging the gap between business needs and technical solutions within our organization. You will collaborate closely with stakeholders to...

  • Data Analyst

    2 weeks ago

    Sacramento, CA, United States My3Tech Inc Full time

    Hello Professionals, Hope you are doing well, Data Analyst/Data Modeler Client: State of CA (CalTrans) Location: Sacramento, CA (Hybrid - onsite work required) Mon & Wed in office required Must live within 60-90 miles minimum from location Key Duties/Responsibilities: Performs business and systems analysis and documentation Develops conceptual and...

  • Data Analyst

    2 days ago

    Sacramento, CA, United States My3Tech Inc Full time

    Hello Professionals, Hope you are doing well, Data Analyst/Data Modeler Client: State of CA (CalTrans) Location: Sacramento, CA (Hybrid - onsite work required) Mon & Wed in office required Must live within 60-90 miles minimum from location Key Duties/Responsibilities: Performs business and systems analysis and documentation Develops conceptual and...

  • Data Analyst

    1 week ago

    Sacramento, CA, United States My3Tech Inc Full time

    Hello Professionals, Hope you are doing well, Data Analyst/Data Modeler Client: State of CA (CalTrans) Location: Sacramento, CA (Hybrid - onsite work required) Mon & Wed in office required Must live within 60-90 miles minimum from location Key Duties/Responsibilities: Performs business and systems analysis and documentation Develops conceptual and...

  • Data Analyst

    2 weeks ago

    Sacramento, CA, United States My3Tech Inc Full time

    Hello Professionals, Hope you are doing well, Data Analyst/Data Modeler Client: State of CA (CalTrans) Location: Sacramento, CA (Hybrid - onsite work required) Mon & Wed in office required Must live within 60-90 miles minimum from location Key Duties/Responsibilities: Performs business and systems analysis and documentation Develops conceptual and...

  • Sr Data Analyst

    4 days ago

    Sacramento, CA, United States My3Tech Inc Full time

    Job Title: Sr. Data Analyst Location: Remote (PST preferred) Contract Type/Duration: Long Term Contract Job Description Position Overview: We are seeking a highly skilled Sr. Data Analyst with extensive experience in mainframe environments and a strong background in data analysis and reporting. The ideal candidate will have a deep understanding of COBOL,...

  • Sr Data Analyst

    7 days ago

    Sacramento, CA, United States My3Tech Inc Full time

    Job Title: Sr. Data Analyst Location: Remote (PST preferred) Contract Type/Duration: Long Term Contract Job Description Position Overview: We are seeking a highly skilled Sr. Data Analyst with extensive experience in mainframe environments and a strong background in data analysis and reporting. The ideal candidate will have a deep understanding of COBOL,...

  • Data and Reporting Analyst

    2 weeks ago

    Sacramento, CA, United States Info Way Solutions Full time

    Job Title: Data and Reporting Analyst Client: State of California Location: Sacramento, CA (Remote, Local candidates preferred) Duration: 6-Year Contract State Experience: Preferred Job Description: We are looking for experienced Data and Reporting Analysts to support the State of California's data reporting and analysis efforts. As part of this role, you...