Data Engineer

Insulet started in 2000 with an idea and a mission to enable our customers to enjoy simplicity, freedom and healthier lives through the use of our Omnipod product platform. In the last two decades we have improved the lives of hundreds of thousands of patients by using innovative technology that is wearable, waterproof, and lifestyle accommodating.

We are looking for highly motivated, performance driven individuals to be a part of our expanding team. We do this by hiring amazing people guided by shared values who exceed customer expectations. Our continued success depends on it

Position Overview
Insulet Corporation, maker of the OmniPod, is the leader in tubeless insulin pump. We are seeking a highly skilled Data Engineer to join our team. This role involves designing and implementing robust data architectures using Databricks, AWS, and Azure platforms. The ideal candidate will have experience in big data technologies, cloud platforms, and data engineering. We are looking for a high performing individual who is passionate about data to provide data pipeline support, operations and engineering across multiple data domains and data platforms. Initially you will proactively identify and resolve data pipeline issues to ensure high quality on time data for our clients. In addition, you will optimize pipeline performance and understand how our clients use their data

Responsibilities

• Design, implementation and maintenance of Insulet's data lake, warehouse and overall architecture
• Work with IT, analytics and cross functional teams to identify data sources, determine data collection and design aggregation mechanisms
• Perform data quality checks and data clean up
• Interface with business stakeholders in cross-functional teams, including manufacturing, quality assurance, and post-market surveillance in order to understand various applications and their data sets
• Develop data preprocessing tools as needed
• Maintenance and understanding of the various business intelligence tools used to visualize and report team analytics results to the company

Education And Experience

• Bachelors degree in Mathematics, Computer Science, Electrical and Computer Engineering, or a closely related STEM field is preferred
• 2-3 year's experience working with data technologies,
• Experience in data quality assurance, control and lineage for large datasets in relational/non-relational databases
• Experience managing robust ETL/ELT pipelines for big real-world datasets that could include messy data, unpredictable schema changes and/or incorrect data types
• Experience with both batch data processing and streaming data
• Experience in implementing and maintaining Business Intelligence tools linked to an external data warehouse or relational/non-relational databases is required
• Experience in medical device, healthcare, or manufacturing industries is desirable

Preferred

• HIPAA experience
• Master's Degree in Mathematics, Computer Science, Electrical and Computer Engineering, or a closely related STEM field

Skills/Competencies

• Demonstrated knowledge in SQL and relational databases is required
• Knowledge in non-relational databases (MongoDB) is a plus
• Demonstrated knowledge of managing large data sets in the cloud (Azure SQL, Databricks, snowflake) is required
• Knowledge of ETL and workflow tools (Azure Data Factory, AWS Glue, Databricks workflows etc) is a plus
• Demonstrated knowledge of building, maintaining and scaling cloud architectures (Azure, AWS, etc), specifically cloud data tools that leverage Spark, is required
• Demonstrated coding abilities in Python, Java, C or scripting languages
• Demonstrated familiarity with different data types as inputs (e.g. CSV, XML, JSON, etc)
• Demonstrated knowledge of database and dataset validation best practices
• Demonstrated knowledge of software engineering principles and practices
• Ability to communicate effectively and document objectives and procedures

NOTE: This position is eligible for hybrid working arrangements and requires on-site work from an Insulet office at least three (3) days per week.

Travel is estimated at 10% but will flex depending on business needs