Data Integration Engineer – SnapLogic & Snowflake

About the Role

We are looking for a Data Integration Engineer to join our Animal Health Omnichannel & Marketing Automation data platform initiative.

In this role, you will be responsible for onboarding new data sources into our Snowflake platform by designing, building, and maintaining data ingestion pipelines using SnapLogic. You will integrate data from various enterprise systems, APIs, databases, and cloud services, ensuring reliable and high-quality data is available for analytics, reporting, and downstream engineering activities.

You will work closely with Business Analysts during source system analysis and data discovery activities, and collaborate with Data Engineers to support the delivery of scalable data solutions supporting customer engagement, marketing, and commercial capabilities.

Key Responsibilities

• Design, build, and maintain data ingestion pipelines using SnapLogic.
• Integrate data from enterprise applications, REST APIs, databases, cloud storage, and file-based sources.
• Load data into Snowflake and ensure data quality, completeness, and reliability.
• Implement full and incremental data ingestion processes.
• Analyze source data structures and support data discovery activities.
• Perform data validation and troubleshoot integration issues.
• Monitor and optimize ingestion pipelines.
• Support onboarding of new data sources and enhancements to existing integrations.
• Create and maintain technical documentation.

Required Skills & Experience

• Experience in Data Integration, ETL/ELT, or Data Engineering.
• Hands-on experience with SnapLogic.
• Experience building data ingestion pipelines into Snowflake.
• Strong SQL skills.
• Experience integrating REST APIs, relational databases, and file-based data sources.
• Good understanding of ETL/ELT concepts and data integration best practices.
• Experience with incremental loading and data quality validation.
• Strong analytical and problem-solving skills.
• Ability to collaborate effectively with both technical and business stakeholders.
• Experience working in Agile delivery environments.

Nice to Have

• Experience with dbt.
• Knowledge of Snowflake architecture and cloud data platforms.
• Experience with AWS, Azure, or Google Cloud Platform.
• Experience working in Life Sciences, Pharma, Animal Health, CRM, Customer Data Platform (CDP), Omnichannel, or Marketing Automation environments.
• Familiarity with CI/CD practices and modern data engineering practices