Title: Data Analyst/Data Modeling
Duration: 6+ months
Interview: Video
Visa: USC, GC,
City: Sacramento, CA (locals only within 60-90 miles )
Location: Sacramento, CA (Hybrid – onsite work required)
· Two days a week in office required. Client will select which days of the week.
· Must live within 60-90 miles minimum from location
Requirements:
· Senior, hands-on data modeller with strong communication skills.
· Strong ability to articulate data modelling 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 dimensional data models for the enterprise data warehouse
· Experience with large data warehouse implementation projects
· Performs data modelling 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 Modelling 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 modelling
· 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 relevant experience in relational data modelling and dimensional data modelling, 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 Modelling 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.
Thank & Regards
Shard Phutela | Senior Techincal Recruiter
D: 267-665-2313,
First Ring Solutions LLC | Philadelphia, PA 19102
Note: Due to high volume of calls, I may miss your call, email is the better way to reach me.