Azure Data Engineer (QA)

At Elanco (NYSE: ELAN) – it all starts with animals!

As a global leader in animal health, we are dedicated to innovation and delivering products and services to prevent and treat disease in farm animals and pets.

We’re driven by our vision of ‘Food and Companionship Enriching Life’ and our approach to sustainability – the Elanco Healthy Purpose™ – to advance the health of animals, people, the planet and our enterprise.

At Elanco, we pride ourselves on fostering a diverse and inclusive work environment.

We believe that diversity is the driving force behind innovation, creativity, and overall business success.

Here, you’ll be part of a company that values and champions new ways of thinking, work with dynamic individuals, and acquire new skills and experiences that will propel your career to new heights.

Making animals’ lives better makes life better – join our team today!

Your Role: Sr Data Engineer

The data engineer’s role is delivery focused.

The person in this role will drive data pipeline and data product delivery through data- architecture, modeling, design, and development a professional grade solution on premise and/or Microsoft Azure cloud.

Partner with data scientists and statisticians across Elanco global business functions to help prepare and transform their data into data products that further drive the scientific and/or business knowledge discovery, insights, and forecasting.

Data engineers will be part of a highly collaborative and cross-functional team of technology and data experts working on solving complex scientific and business challenges in animal health using cutting edge data and analytics technologies.

Your Responsibilities:


* Provide data engineering subject matter expertise and hands-on data- capture, ingestion, curation, and pipeline development expertise on Azure to deliver cloud optimized data solutions.


* Provide expert data PaaS on Azure storage; big data platform services; server-less architectures; Azure SQL DB; NoSQL databases and secure, automated data pipelines.


* Develop and execute test strategies for data pipelines, ETL workflows, and data models.


* Perform data validation (schema, metadata, row counts, referential integrity, business rules).


* Automate regression and unit testing for data pipelines using PySpark, SQL, and testing frameworks (e.g., pytest).


* Conduct data reconciliation testing between source and target systems.


* Implement monitoring and alerting for data quality issues.


* Participate in data/data-pipeline architectural discussions to help build cloud native solutions or migrate existing data applications from on premise to Azure platform.

Perform current state “AS-IS” and future state “To-Be” analysis

What You Need to Succeed (minimum qualifications):


* Bachelors or higher degree in Computer Science or a related discipline.


* At least 5 years of data pipeline and data product design, development, delive...