Sr. Data Engineer

At Elanco (NYCE: 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!

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 engineer 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. 

The Data Engineer is expected to work with teams spread globally across different time zones. The Data Engineer in this role must also be well versed in Data Management, Data Governance, Master Data Management, and Knowledge Graph Representation. This role requires sound understanding of animal health data from different domains – R&D, Sales & Marketing, Commercial, Regulatory and Supply Chain. Proven learning agility and ability to translate complex business problems and challenges into tangible data pipelines and data products of high value. The ideal candidate would be responsible for developing and delivering highly performant, scalable (small- to big- data), robust and secure Azure cloud data pipelines enabling AI/ML/Deep-Learning, Advanced Analytics, Enterprise Collaboration, Micro-services, IoT and Server-less Compute.

Role & 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 PaaSon Azure storage; big data platform services; server-less architectures; Azure SQL DB; NoSQL databases and secure, automated data pipelines.

  
  

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

  
  

• Participate and help develop Data Engineering community of practice as a global go-to expert panel/resource.

  
  

• Develop and evolve new or existing Data Engineering methods and procedures to create possible alternative, agile solutions to moderately complex problems.

  
  

• Stay abreast with new and emerging Data Engineering technologies, tools, methodologies, and patterns on Azure and other major public clouds.

  
  

• Demonstrate ownership in understanding the organization’s strategic direction as it relates to your team and individual goals.

  
  

• Work collaboratively and use sound judgment in developing robust solution while seeking guidance on complex problems.

  
  

Basic Qualifications (Must have)

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

  
  

• At least 2 years of data pipeline and data product design, development, delivery experience and deploying ETL/ELT solutions on Azure Data Factory.

  
  

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

  
  

• Minimum of 2 years of hands-on experience in programming languages, Azure and Big Data technologies such as PowerShell, C#, Java, Python, Scala, SQL, ADLS/Blob, Hadoop,Spark/SparkSQL, Hive, and streaming technologies like Kafka, EventHub etc.

  
  

• Knowledge on Distributed System

  
  

IT Exp Minimum 4 – 7 

Azure Exp 2.5 to 5 (Minimum 2+) 

Good to Have Skills:

• Hands-on experience in implementing data migration and data processing using Azure services: Windows/Linux virtual machines, Docker Container and Kubernetes Cluster Management, Autoscaling, Azure Functions, Server-less Architecture, ARM Templates, Logic Apps and Data Factory, Azure network security group, Key management service, etc.

  
  

• Knowledge of Spark Framework 3.x version

  
  

• Cloud migration methodologies and processes including tools like Azure Data Factory, Event Hub, etc. 

  
  

• Experience in using Hadoop File Formats and compression techniques.

  
  

• DevOps on an Azure platform.

  
  

• Experience working with Developer tools such as Visual Studio, GitLab’s, Jenkins, etc.

  
  

• Familiarity with metadata management tools, techniques, and technologies such as Data Catalog & Dictionaries, Data Governance, Data Quality, MDM, and Data Lineage.

  
  

• Experience with private and public cloud architectures, pros/cons, and migration considerations. 

  
  

• Proven ability to work independently.

  
  

• Proven ability to work in a team-oriented environment and work collaboratively in a problem-solving environment.

  
  

• Excellent written and oral communication and interpersonal skills.

  
  

• Excellent organizational and multi-tasking.

  
  

Great-to-Have Skills

• Azure MCSA Cloud Platform Training & Certification 

  
  

• MCSD Azure Solutions Architect Training & Certification 

  
  

• Multi-cloud experience is a plus.

  
  

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