Technical Lead - IT (ETL Engineer)

Eurofins Scientific is an international life sciences company, providing a unique range of analytical testing services to clients across multiple industries, to make life and the environment safer, healthier and more sustainable. From the food you eat to the medicines you rely on, Eurofins works with the biggest companies in the world to ensure the products they supply are safe, their ingredients are authentic and labelling is accurate. Eurofins is a global leader in food, environmental, pharmaceutical and cosmetic product testing and in agroscience CRO services. It is also one of the global independent market leaders in certain testing and laboratory services for genomics, discovery pharmacology, forensics, CDMO, advanced material sciences and in the support of clinical studies.

In over just 35 years, Eurofins has grown from one laboratory in Nantes, France to 62,000 staff across a network of over 1,000 independent companies in 61 countries, operating 900 laboratories. Performing over 450 million tests every year, Eurofins offers a portfolio of over 200,000 analytical methods to evaluate the safety, identity, composition, authenticity, origin, traceability and purity of biological substances and products, as well as providing innovative clinical diagnostic testing services, as one of the leading global emerging players in specialised clinical diagnostics testing.

Eurofins is one of the fastest growing listed European companies with a listing on the French stock exchange since 1997. 

Eurofins IT Solutions India Pvt Ltd (EITSI) is a fully owned subsidiary of Eurofins and functions as a Global Software Delivery Center exclusively catering to Eurofins Global IT business needs. The code shipped out of EITSI impacts the global network of Eurofins labs and services.

The primary focus at EITSI is to develop the next generation LIMS (Lab Information Management system), Customer portals, e-commerce solutions, ERP/CRM system, Mobile Apps & other B2B platforms for various Eurofins Laboratories and businesses. Young and dynamic, we have a rich culture and we offer fulfilling careers.

TITLE: ETL Engineer

REPORTING TO: GSC IT Reporting Lead

WORKING LOCATION: India (Bangalore or Chennai)

OVERALL OBJECTIVES:

Eurofins is currently strengthening its IT Reporting team, which is responsible for controlling governance and operational data, producing and maintaining reports utilized by several IT departments (IT Quality Assurance, IT Service Management, IT Risk & Compliance, Information Security, IT Infrastructure, Fixed & Intangible Assets). The data encompasses the performance of IT Services, compliance of IT Assets, licensing, cloud capacity, and security posture of the IT environment as a whole.

The role of the ETL Engineer is to analyse requirements, source data, orchestrate data transformation, and then maintain and support (level 3) data pipelines, in close collaboration with BI Analysts in the same team. We are currently seeking candidates with medium-level competencies to join our team. Apply now to leverage your skills and contribute to exciting projects in a dynamic and collaborative work environment.

SPECIFIC ASSIGNMENTS: The ETL Engineer:

• Analyses approved requirements from stakeholders (across IT and business functions).
• Works with domain experts and data/app owners to extract and transform data.
• Implements reusable business logic/transformation bricks.
• Designs, creates, orchestrates, and maintains data pipelines.
• Assesses and ensures data quality.
• Deploys data pipelines to production.
• Documents the data dictionary and data pipelines/business rules.
• Implements data ACLs.
• Participates in the Agile SCRUM development process.
• Provides L2/L3 support for investigating and resolving ETL incidents and data quality issues.

REQUIRED PROFILE: Personal Skills:

• Data design, modelling, transformation, orchestration.
• Excellent communication skills (in English, both orally and in writing, including moderating meetings).
• Comfortable with distant and international communications through various technologies (ticketing tool, documents and forums, phone, instant messaging, email), Microsoft End User computing tools.

Type and duration of previous experience:

• 6+ years of experience as a data engineer/expert.
• Strong expertise with SQL (MS SQL is a plus).
• Previous experience with IT Infrastructure (system engineer) is a plus.
• Experience in DataOps and/or Agile/SCRUM is a plus.

Technical knowledge:

• Row-level security.
• SQL (MS SQL).
• Python, PowerShell: is a plus.

• Bachelor's degree or diploma.

Language skills and expected level:

• Fluent English required.