What are the responsibilities and job description for the Data Warehouse Engineer position at Delphi-US, LLC - Peacemakers in the Talent War?
Title: Data Warehouse Engineer (Contract) - Job#5350
Location: Hybrid, Augusta, Maine
Our client in Augusta, Maine is looking for a Data Warehouse Engineer to join their team. This individual will serve as a daily subject-matter expert for all Oracle technologies and toolsets. Much of the work will focus on data modeling and developing automated ETL processes that pull data from a variety of data sources.
Responsibilities:
- Develop, monitor, and maintain a variety of automated DB processes.
- Research and resolve database issues as they arise.
- This individual will be assigned a variety of database management and maintenance tasks.
- Serve as a trusted technical advisor and will serve as a technical mentor to other IT staff.
- Collaborate with other developers, analysts, and DBAs.
- Work closely with IT vendors, IT leadership, and business partners.
- Play a key role in upcoming system migrations, system expansions, and data modernization efforts.
Requirements:
- Extensive practical experience with the modern Oracle platforms and technologies. This includes the following:
- Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.
- Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.
- Practical experience utilizing API calls for automated data refreshes.
- Practical experience with Oracle Analytics Cloud (OAC)
- Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.
- Expertise in dimensional modeling.
- Experience with tabular data models.
- Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable.
- Demonstrates a disciplined approach to process and error logging.
- Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.
- Ability to serve as a technical mentor to both senior and junior IT staff.
- Ability to develop architectural diagrams and system documentation, and train others on the content.
- Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.
- Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.
Top 3 Skills:
- Developing automated ETL
- Designing & Implementing Enterprise class data repositories built upon Oracle on prem and cloud hosted databases
- Expertise in dimensional modeling and ability to act as a technical mentor
About Delphi-US
Delphi-US is a national recruiting firm based in Newport, Rhode Island. We specialize in IT, Engineering and Professional Staffing services for premier corporations and a multitude of industries across the United States. We are the Peacemakers In The Talent War – bringing the best and brightest talent to Employers of Choice, enabling critical project success, fostering progressive employment relationships, and promoting competitive advantages for our Clients and the Talent Marketplace we serve. Delphi accomplishes this with a proprietary skill-based and cultural matching process that results in higher qualified submissions along with increased interviews and offer rates. You’ll find our team is highly experienced, friendly, professional and ready to advocate on your behalf, armed with industry trends, and an understanding of employer expectations.
