Data Engineer (Hybrid/guadalajara or Tijuana)

Position Overview

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!

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