Job Overview
This senior level role is built for someone who thrives in complex Oracle environments and can deliver results without constant oversight. Expect a fast pace, high standards, and a lot of trust. If you bring deep experience in enterprise data design, automated ETL, and technical mentorship, you’re already halfway to the interview.
Must Haves
• Advanced experience designing and implementing enterprise Oracle databases across on prem and cloud environments
• Strong background developing automated ETL processes using flat files, APIs, and relational sources
• Mastery of SQL and PL SQL with a track record building complex procedures, functions, and scripts
• Expertise in dimensional modeling and tabular data modeling
• Hands on experience with Oracle Analytics Cloud
• Ability to translate complex business requirements into scalable technical solutions
• Disciplined approach to documentation, coding standards, and metadata management
• Proven success mentoring technical talent across multiple experience levels
What the Client Needs You to Do
This role drives data architecture across the organization. You’ll design modern data structures, build automated pipelines, and help steer major modernization initiatives. You’ll be the person teams rely on for clarity, accuracy, and technical leadership. The work is independent, collaborative, and heavily impact focused.
Key Responsibilities
• Design and maintain enterprise Oracle data repositories across hybrid environments
• Develop automated ETL pipelines integrating flat files, APIs, and other data sources
• Build high performing SQL and PL SQL procedures, views, and scripts
• Model data using dimensional and tabular methods to support advanced analytics
• Troubleshoot database performance, integration issues, and automated processing failures
• Create architectural diagrams, system documentation, and training materials
• Collaborate with developers, analysts, database administrators, and external partners
• Support system migrations, modernization projects, and platform expansions
• Implement consistent coding standards, logging practices, and documentation workflows
• Mentor technical staff at varying experience levels
W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), 401(k) starting on day one, a variety of voluntary benefits including life and disability insurance, and sick time if required by law in the worked-in state/locality.
#25240
