Principal Data Warehouse Engineer (Oracle DB, PL/SQL)

iRobot; Bedford (MA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading company in the robotics industry is seeking an experienced Data Warehouse Engineer to develop and maintain large-scale database systems. The role involves designing scalable data warehouse solutions, managing ETL processes, and optimizing database performance while collaborating with business stakeholders. Ideal candidates will have extensive experience in data warehouse development and a strong proficiency in Oracle databases.

Benefits

Competitive Compensation Package

Comprehensive healthcare coverage

Employee Assistance Program

Wellness initiatives

Retirement Savings Plan with Employer Contribution

Professional Development Opportunities

Qualifications

• 8+ years of experience in enterprise data warehouse development.
• Expert proficiency in Oracle DB 19c, SQL, and PL/SQL.
• Hands-on experience with data warehouse architecture and ETL design.

Responsibilities

• Design and maintain scalable data warehouse solutions.
• Develop and manage ETL processes to ensure data quality.
• Monitor and optimize database performance.

Skills

Oracle DB 19c

SQL

PL/SQL

Data Modeling

ETL Design

Problem-Solving

Critical Thinking

Education

Bachelor's degree in Computer Science

Tools

Tableau Server

Bitbucket

JIRA

Confluence

Job description

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.”