Data Analyst and Data Modeler - Sacramento, United States - Money Fit by DRS

    Default job background
    Description

    Benefits:
    Onsite
    Competitive salary
    Opportunity for advancement


    Requirements:
    Positions must be able work at on site at (Sacramento) at a minimum of two-three days/week.

    Positions must be able to work during core business hours e.g., 8 am to 5 pm M-F (PST).

    Positions may have to travel to district offices when necessary (No more than 12 times a year). No reimburse travel expense costs.


    Data Analyst/Data Modeler ($57.70/Hour):

    Key Duties/Responsibilities:
    Performs business and systems analysis and documentation
    Develops conceptual and dimensional data models for the enterprise data warehouse
    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
    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 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 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.

    Desired:
    Expert level Kimball Dimensional Data Modeling experience
    Expert level experience developing in Oracle SQL Developer or ER/Studio Data Architect for Oracle.
    #J-18808-Ljbffr