Job Title: Oracle Technical Data Lead (EDW)
Location: Sacramento, CA (Hybrid – 2 Days Onsite)
Duration: Long-term Contract
Note: Candidates must be located within 90 miles of Sacramento, CA
Job Description:
We are seeking a Senior Oracle Technical Data Lead / Data Management Consultant to lead a large-scale Enterprise Data Warehouse (EDW) initiative. The ideal candidate will have deep expertise in Oracle technologies, strong leadership skills, and hands-on experience in cloud-based data warehouse solutions.
Key Responsibilities:
Lead end-to-end Oracle Data Warehouse (EDW) implementations
Design and define data architecture and cloud strategy
Develop and optimize ETL processes using Oracle tools (ODI preferred)
Work hands-on with PL/SQL, Oracle ADW, and OCI
Implement data modeling techniques (Star, Snowflake, Hybrid schemas)
Mentor cross-functional teams including DBAs, Data Engineers, and BI teams
Translate business requirements into scalable technical solutions
Collaborate with stakeholders and leadership teams
Required Skills:
10+ years of experience in Data Warehousing / Data Management
Strong experience with Oracle Database and PL/SQL
Hands-on experience with Oracle Autonomous Data Warehouse (ADW)
Experience working in Oracle Cloud Infrastructure (OCI)
Strong ETL experience using Oracle Data Integrator (ODI) or similar tools
Expertise in performance tuning and database optimization
Strong data modeling experience
Preferred Qualifications:
Oracle Certifications (OCI / SQL / DBA)
Experience working with State or Federal clients
Experience in large-scale EDW implementations
Required Keywords (for search optimization):
Oracle, Oracle ADW, OCI, PL/SQL, ODI, ETL, Data Warehouse, EDW, Data Modeling, Star Schema, Snowflake Schema, Data Architect, Oracle Cloud, Performance Tuning
Soft Skills:
Strong communication and stakeholder management
Leadership and mentoring experience
Ability to work in a hybrid team environment
Never miss an opportunity! Create an alert based on the job you applied for.
