Data Engineer !! Only USC AND GC !! Local Sacramento, CA

 

Job Title           :-  Data Engineer  (10+ years)

Duration           :-  6+ Months

Location           :-  Local  Sacramento, CA  (Hybrid)

Visa                  :-  Only USC AND GC

Interview          :-  Virtual

 

Client: State of CA
Location: Sacramento, CA (Hybrid – onsite work required)
·        Two days a week in office required.  Client will select which days of the week.


Requirements:
·        Senior, hands-on data modeler with strong communication skills.
·        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 dimensional 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
·        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 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 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.

 

 

Thanks & Regards

Aman Mishra |Sr. Technical Recruiter

Desk : 215-402-2122

First Ring Solutions LLC 

 

 

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments