Sr. Data Warehouse Engineer (Oracle PL/SQL)

Introduction

iRobot is seeking an experienced Data Warehouse Engineer to develop, optimize and maintain large-scale database systems and cloud environments, with a primary focus on Oracle data warehouse. Working closely within a team of data warehouse, ETL and BI engineers, as well as business stakeholders, to define, design, and deliver business-critical data structures and models. This position requires a mix of technical expertise and strategic thinking to build scalable, high-quality database solutions that support operations, reporting, and ETL processes while driving innovation and best practices across the team.

What You Will Do:

• Design and maintain scalable data warehouse solutions across all Oracle server environments to support our business intelligence and analytics needs.
• Develop and manage ETL processes on the data warehouse including schema changes and data infrastructure updates, following best practices to ensure data quality, consistency, and security.
• Monitor, troubleshoot, and optimize database performance while ensuring data integrity.
• Plan, organize, and execute data warehouse code releases using Bitbucket, adhering to SDLC processes and IT change management policies and procedures.
• Conduct rigorous testing, including developer, regression and performance testing, with full business sign-off before code deployment.
• Build and maintain SQL queries, stored procedures, and data models to support business intelligence and analytics teams.
• Ensure clear communication and transparency by thoroughly documenting work in JIRA, fostering knowledge sharing within the team.
• Maintain up-to-date documentation of data architecture, models, and processes in Confluence for long-term sustainability.
• Stay current with emerging database technologies and implement best practices in database engineering.

To Be Successful You Will Have:

• 8+ years of experience in enterprise data warehouse development, including design, troubleshooting, and maintenance.
• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Expert proficiency in Oracle DB 19c (or other versions), SQL, and PL/SQL, with knowledge of advanced features such as database partitioning and dynamic SQL.
• Hands-on experience with data warehouse architecture, data modeling, ETL design and cloud-based data integration techniques.
• Understanding of Oracle eBusiness Suite R12 Financials and Supply Chain data architectures (preferred).
• Familiarity with Tableau Server (a plus).
• Strong problem-solving skills, critical thinking, and ability to manage multiple shifting priorities while delivering high-quality results.

Benefits:

• Competitive Compensation Package
• Comprehensive healthcare coverage (Health, Dental, Vision)
• Employee Assistance Program
• Wellness initiatives
• Retirement Savings Plan with an Employer Contribution
• Professional Development Opportunities

“Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or assume sponsorship of any additional employment visas at this time.”