Specialist, Data Engineering

Job Description

Specialist Data Engineering

At our company we are leveraging analytics and technology as we invent for life on behalf of patients around the world. We are seeking those who have a passion for using data analytics and insights to drive decision making that will allow us to tackle some of the worlds greatest health threats.

Within our commercial Insights Analytics and Data organization we are transforming to better power decision-making across our end-to-end commercialization process from business development to late lifecycle management. As we endeavor we are seeking a dynamic talent for the role of Data Engineer

For the Data Engineer role we are looking for professional with experience in designing developing and maintaining data pipelines. We intend to make data reliable governed secure and available for analytics within the organization. As part of a team this role will be responsible for data management with a broad range of activities like data ingestion to cloud data lakes and warehouses quality control metadata management and orchestration of machine learning models. We are also forward looking and plan to bring innovations like data mesh and data fabric into our ecosystem of tools and processes.

Primary Responsibilities:

Design develop and maintain data pipelines to extract data from a variety of sources and populate data lake and data warehouse

Develop the various data transformation rules and data modeling capabilities

Collaborate with Data Analyst Data Scientists Machine Learning Engineers to identify and transform data for ingestion exploration and modeling

Work with data governance team and implement data quality checks and maintain data catalogs

Use Orchestration logging and monitoring tools to build resilient pipelines

Use test driven development methodology when building ELT/ETL pipelines

Develop pipelines to ingest data into cloud data warehouses

Analyze data using SQL

Use serverless AWS services like Glue Lambda StepFunctions

Use Terraform Code to deploy on AWS

Containerize Python code using Docker

Use Git for version control and understand various branching strategies

Build pipelines to work with large datasets using PySpark

Develop proof of concepts using Jupyter Notebooks

Work as part of an agile team

Create technical documentation as needed

Education:

Bachelors Degree or equivalent experience in a relevant field such as Engineering (preferably computer engg.) Computer Science

Required Experience and Skills:

4-8 years of relevant experience

Good experience with AWS services like S3 ECS Fargate Glue

StepFunctions CloudWatch Lambda EMR

SQL

Proficient in Python PySpark

Good with Git Docker Terraform

Ability to work in cross functional teams

Preferred Experience and Skills

Any AWS developer or architect certification

Agile development methodology

Our Human Health Division maintains a patient first profits later ideology. The organization is comprised of sales marketing market access digital analytics and commercial professionals who are passionate about their role in bringing our medicines to our customers worldwide.

Required Skills:

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully
Merck & Co. Inc. Rahway NJ USA also known as Merck Sharp & Dohme LLC Rahway NJ USA does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place introductions are position specific. Please no phone calls or emails.

Employee Status:

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

*A job posting is effective until 11:59:59PM on the day BEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.