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