: Senior Data Engineer
8 Crosby Drive Bedford
Bedford, MA 01730

Employee Testimonials

Video

Introduction

As a Senior Data Engineer, you will work in a dynamic IT organization supporting enterprise data operations, analytics and reporting. Working closely within a team of Data Warehouse, ETL, BI engineers and business stakeholders you will help to define, design and deliver business critical data integrations and modeling. Reporting to the Data Operations Manager, you will help define and support iRobots Enterprise Data Warehouse function and expand its capabilities to service a growing and diverse business user community.

Primary Responsibilities

  • Design, develop and maintain enterprise ETL processes as part of data warehouse operations utilizing industry leading tools and best practices
  • Provide data modeling support for fact and dimension table updates, data processing, reporting views and functions
  • Monitor production data integrations and provide first level support for data extracts, integrations and transformations
  • Assist with performance tuning and enhancing existing integrations based on multiple data sources and working directly with end users to provide data processing recommendations
  • Engineer end to end automated solutions for data management, creating notifications and alerts on data variances in systems
  • Organize, plan and manage integration code releases, adhering to SDLC processes and IT change management policy and procedures
  • Work closely with senior architects and IT team members to support all lifecycle phases of integration solutions from design through production support, working on multiple BI platforms, integration technology SnapLogic, with components spanning Windows, Linux, Mobile (IOS/Android), multiple datastores, and future emerging techniques to drive results
  • Monitor, and respond to data integration related requests captured through IT service desk, Jira Kanban boards, Slack, and other user community interfaces
  • Document data sourcing, data architectures, processing schedules and release notes to ensure data operations transparency and long-term sustainability
  • Create and maintain project related stories in Jira with clear and detailed acceptance criteria, business requirements, and dependencies
  • Create and maintain robust documentation of new and existing BI solutions on Confluence

Requirements

Education: BS/BA in Computer Science, Information Systems or equivalent

Experience:

  • Minimum 8+ years experience designing, developing and maintaining integration code and data structures within an enterprise data warehouse environment
  • Hands-on experience with data warehouse architectures, data modeling, ETL design, SOAP/REST API and cloud-based data integration techniques
  • Strong working knowledge of RDBMS Oracle Data Warehouse 19c data models, SQL and PLSQL queries, views and stored procedures to support Reporting and Analytics projects
  • Experience with designing and implementing, processes for data cleansing, data auditing, and data profiling using iPasS tools like SnapLogic/MuleSoft/Dell Boomi or any other equivalent.
  • Demonstrated understanding of Oracle eBusiness Suite R12 Financials and Supply Chain modules
  • Strong Supply Chain, Sales Operations, Logistics, Accounting, and FP&A business support skills including forecast, demand planning, month end close processes
  • Experience with Tableau Server preferred
  • Self-starter who can define their work, manage multiple priorities, leverage critical thinking and attention to detail in all aspects of work product design and delivery
  • Strong verbal, written and presentation skills; proficiency in O365, MS Visio and PowerPoint tools to aid communications and understanding
  • Ability to work collaboratively across the organization: interpret user requirements, identify root causes, research and present possible solutions, consensus building around most feasible solutions
  • Must be able to work creatively, calmly, flexibly and under tight deadlines in order to respond quickly and positively to shifting/multiple demands and opportunities
  • Self-motivated, able to inspire users, work independently as well as with others in a matrix environment
Full-time

Employee Testimonials

Danielle Dean
Technical Director of Machine Learning

"I love how much iRobot emphasizes learning, risk-taking, and innovation, and gives me the opportunity to work with different people."

Eva Moscat
Manager, Software Engineering

"Every day I feel challenged – whether it’s technical problem solving, or getting my team up to speed on a new project and making sure they are happy, motivated, and developing in their careers."

Emiko Komori
Corporate Counsel

"Collaborating with people who are very passionate and dedicated to building products that bring joy and ‘wow!’ to customers is my favorite part of my job."

Brandon Rohrer
Principal Data Scientist

"iRobot is a wonderland for a data scientist. Our data helps us enhance our customers’ experiences by better understanding their needs and delivering new solutions to exceed their expectations."

Victoria Liceaga
Manager, Product Marketing

"The Global Marketing group is dynamic and lively. We are always moving fast to plan for new products, execute seasonal campaigns, and pivot based on changes in the market. We are so fortunate to be marketing products that our customers love as much as we do and that add real value to their lives."

Eric Burbank
Principal Mechanical Engineer

"The hardware engineering group at iRobot is incredibly innovative and fun to work with. We have a full range of engineers with many diversified talents. Everyone is incredibly willing to share their expertise and help out on challenges."

Evn Tomeny
Manager of Enterprise Collaboration

"The collaborative nature of the team is refreshing. Everyone works together to find interesting solutions to complicated problems, and contributions are appreciated from anywhere. Because of the diverse set of backgrounds and experiences, you’ll often find answers where you least expect them!"

Michelle Gattuso
VP Portfolio & Digital Product Management

"iRoboteers know that their contributions matter. They are always doing what they can to make things better and deliver great products that customers will love. We know we’ve had a hand in changing the world and it shows in our drive and determination to keep moving forward."

Lauren Stern
Principal Design Researcher

"Our team is unique because we have so many disciplines within the Design department. Owning and using a robot is a multi-faceted experience, and we all work together to create that experience for our users. The cross-discipline collaboration is really special. It’s a group of funny, enthusiastic, creative, kind people."

Sushmita Bawari
Director, Strategic Sourcing

"It’s great to have the opportunity to manage a global team and work with suppliers from all around the world. It really helps you appreciate how inter-connected everything is."