Data Engineer

Key Responsibilities 

• The Data Engineer will be responsible for developing and maintaining ETL/ELT pipelines for ingesting data from various sources into our data warehouse. 

• Work with an end-to-end ownership mindset, innovate and drive initiatives through completion. 

• Optimize data storage and retrieval to ensure efficient performance and scalability 

• Collaborate with data architects, data analysts and data scientists to understand their data needs and ensure that the data infrastructure supports their requirements 

• Ensure data quality and integrity through data validation and testing 

• Implement and maintain security protocols to protect sensitive data 

• Stay up-to-date with emerging trends and technologies in data engineering and analytics 

• Closely partner with the Enterprise Data and Analytics Platform team, other functional data teams and Data Community lead to enable adoption of data and technology strategy.  

• Knowledgeable in evolving trends in Data platforms and Product based implementation 

• Comfortable working in a fast-paced environment with minimal oversight 

• Prior experience working in an Agile/Product based environment. 

Qualifications & Experience 

• 3-5 years of hands-on experience working on implementing and operating data capabilities and cutting-edge data solutions, preferably in a cloud environment.  Breadth of experience in technology capabilities that span the full life cycle of data management including data lakehouses, master/reference data management, data quality and analytics/AI ML is needed.  

• Expertise in Databricks 

• Expertise in designing and building real time data ingestion data pipelines in AWS 

• Expertise in CloudFormation   

• Developing and using Custom Resources in CFTs  

• Expertise in developing GitHub Workflows & integrating GitHub workflows with AWS 

• Expertise with using boto3 apis for Lambda, S3, Glue, Crawlers, Data Zone (preferred) 

• Expert in building APIs using AWS services   

• In-depth knowledge and hands-on experience with ASW Glue services and AWS Data engineering ecosystem.  

• Hands-on experience developing and delivering data, ETL solutions with some of the technologies like AWS data services (Redshift, Athena, lakeformation, etc.), Cloudera Data Platform, Tableau labs is a plus  

• 5+ years of experience in data engineering or software development 

• Create and maintain optimal data pipeline architecture, assemble large, complex data sets that meet functional / non-functional business requirements. 

• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. 

• Strong programming skills in languages such as Python, R, PyTorch, PySpark, Pandas, Scala etc. 

• Experience with SQL and database technologies such as MySQL, PostgreSQL, Presto, etc. 

• Experience with cloud-based data technologies such as AWS, Azure, or Google Cloud Platform 

• Strong analytical and problem-solving skills 

• Excellent communication and collaboration skills Functional knowledge or prior experience in Lifesciences Research and Development domain is a plus 

• Experience and expertise in establishing agile and product-oriented teams that work effectively with teams in US and other global BMS site.   

• Initiates challenging opportunities that build strong capabilities for self and team 

• Demonstrates a focus on improving processes, structures, and knowledge within the team. Leads in analyzing current states, deliver strong recommendations in understanding complexity in the environment, and the ability to execute to bring complex solutions to completion.​