Senior Data Engineer

Introduction

As a Senior Data Engineer, you will work in a dynamic organization supporting enterprise data operations, analytics and reporting for iRobot. 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 Manager of Data Engineering, you will help define and support iRobot's Enterprise Data Warehouse function and expand its capabilities to service a growing and diverse business user community.

What You Will Do:

• 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 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 JIRA 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

To Be Successful You Will Have:

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

• 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 iPaaS 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