Azure Data Engineer

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, delivery experience and deploying ETL/ELT solutions on Azure Data Factory.

What will give you a competitive edge (preferred qualifications):

• Azure native data/big-data tools, technologies and services experience including – Storage BLOBS, ADLS, Azure SQL DB, COSMOS DB, NoSQL and SQL Data Warehouse.
• Sound problem solving skills in developing data pipelines using Data Bricks, Stream Analytics and PowerBI.
• Strong experience in data testing, ETL testing, and automation frameworks with hands-on expertise in data profiling, reconciliation, and quality checks, along with familiarity with modern data testing tools such Pytest.
• Knowledge on Distributed System.

Additional Information:

• Travel: 0%
• Location: India, Bangalore

Don't meet every single requirement? Studies have shown underrecognized groups are less likely to apply to jobs unless they meet every single qualification. At Elanco we are dedicated to building a diverse and inclusive work environment. If you think you might be a good fit for a role but don't necessarily meet every requirement, we encourage you to apply. You may be the right candidate for this role or other roles

Elanco is an EEO/Affirmative Action Employer and does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status