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.

Job Title: Analytics Engineer

Department: Analytics Center of Excellence

Manager/Supervisor: Director, Analytics COE

FLSA Status: Exempt

Position Overview:

Insulet Corporation, maker of the OmniPod, is the leader in tubeless insulin pump. The Data Engineer role is responsible for working with the data scientists and the data lake team in the cleaning, development, validation, and documentation of data sets for data science/machine learning consumption and reporting. This position will be reporting the Manager of Analytics Center of Excellence. We are a fast-growing company that provides an energetic work environment and tremendous career growth opportunities.

Responsibilities:

Work with IT and cross functional teams to identify data sources, determine data collection and design aggregation mechanisms

Act as liaison between the data science (Analytics) team and the data lake engineering team in building curated views required for reporting

Perform data quality checks and data clean up

Interface with business stakeholders in cross-functional teams, including manufacturing, quality assurance, and post-market surveillance to understand various applications and their data sets

Develop data preprocessing tools as needed and data sets for the data scientists’ consumption

Maintenance and understanding of the various business intelligence tools used to visualize and report team analytics results to the company

Build, document, and validate datasets for data science, machine learning, and analytics engineering consumption

Education and Experience:

Bachelor’s degree in mathematics, Computer Science, Electrical and Computer Engineering, or a closely related STEM field is required

Master’s degree in Mathematics, Computer Science, Electrical and Computer Engineering, or a closely related STEM field; or a BS with 2-3 year’s experience working with data technologies, is preferred

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

HIPAA experience a plus

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, Google BigQuery, etc) is required

Demonstrated knowledge of building, maintaining, and scaling Business Intelligence Reports (TIBCO Spotfire, PowerBI, Tableau…)

Demonstrated coding abilities in Python or scripting languages

Experience with Salesforce data is a plus

Experience with Databricks and Spark is a plus

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 100% remote working arrangements (may work from home/virtually 100%; may also work hybrid on-site/virtual as desired). #LI-remote