Application Enablement - Senior Data Engineer (Hybrid)

Job Description

Our Support Functions deliver services and make recommendations about ways to enhance our workplace and the culture of our organization. Our Support Functions include HR, Finance, Information Technology, Legal, Procurement, Administration, Facilities and Security.

Data Engineer for Application Enablement will be part of the Scientific data consumption product team. In this role, they will work with product teams, technical teams, SMEs and stakeholders to define, design, develop and maintain data products.

In this role, they will work closely with multi-disciplinary teams helping to solve complex data problems and building data products to enable AI/ML. They will have to understand complexities in Research data and work with product team to make data understandable and analytics ready.

The Scientific Data Consumption Product Line (SDC) provides a combination of technology, infrastructure, software, and personnel to support large scale scientific data consumption and computing comprising of the Scientific Data Platform, Modeling and Machine Learning Platforms, High Performance Computing (HPC) workflows, and "experience" products such as visualization, modeling workbenches, and analytics development environments.

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 Product Analyst, Data Scientists, and Machine Learning Engineers to identify and transform data to make data understandable.
• 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
• Analyze data
• Use Git for version control and understand various branching strategies
• Work as part of an agile team
• Create technical documentation as needed

Education:

• B.Sc. or higher degree in computer sciences or an equivalent field required

Required Experience and Skills:

• 3-6 years of relevant experience
• Solid experience with AWS services (S3, IAM, Redshift, Sagemaker, Glue, Lambda, Step Functions, CloudWatch)
• Experience with platforms like Databricks, Dataiku
• Proficient in Python / Java
• Proficient with SQL - Redshift preferred
• Proficient in Jenkins, CloudFormation, Terraform, Git, Docker
• 2-3 years of Spark - PySpark
• Ability to work in cross functional teams

Our Support Functions deliver services and make recommendations about ways to enhance our workplace and the culture of our organization. Our Support Functions include HR, Finance, Information Technology, Legal, Procurement, Administration, Facilities and Security.

NOTICE FOR INTERNAL APPLICANTS

In accordance with Managers' Policy - Job Posting and Employee Placement, all employees subject to this policy are required to have a minimum of twelve (12) months of service in current position prior to applying for open positions.

If you have been offered a separation benefits package, but have not yet reached your separation date and are offered a position within the salary and geographical parameters as set forth in the Summary Plan Description (SPD) of your separation package, then you are no longer eligible for your separation benefits package. To discuss in more detail, please contact your HRBP or Talent Acquisition Advisor.

Residents of Colorado

Click here to request this role's pay range.

Employees working in roles that the Company determines require routine collaboration with external stakeholders, such as customer-facing commercial, or research-based roles, will be expected to comply not only with Company policy but also with policies established by such external stakeholders (for example, a requirement to be vaccinated against COVID-19 in order to access a facility or meet with stakeholders). Please understand that, as permitted by applicable law, if you have not been vaccinated against COVID-19 and an essential function of your job is to call on external stakeholders who require vaccination to enter their premises or engage in face-to-face meetings, then your employment may pose an undue burden to business operations, in which case you may not be offered employment, or your employment could be terminated. Please also note that, where permitted by applicable law, the Company reserves the right to require COVID-19 vaccinations for positions, such as in Global Employee Health, where the Company determines in its discretion that the nature of the role presents an increased risk of disease transmission.

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

For more information about personal rights under Equal Employment Opportunity, visit:

EEOC Know Your Rights

EEOC GINA Supplement

Pay Transparency Nondiscrimination

We are proud to be a company that embraces the value of bringing diverse, talented, and committed people together. The fastest way to breakthrough innovation is when diverse ideas come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another's thinking and approach problems collectively. We are an equal opportunity employer, committed to fostering an inclusive and diverse workplace.

U.S. Hybrid Work Model

Effective September 5,2023 our U.S. Hybrid work model will be as follows: 1. Three total days on site per week: Tuesday and Wednesday - plus one additional day of choice based on what works best for organizations and/or teams. 2. Fridays will formally be a remote-working day unless business critical tasks require onsite presence.

Under New York City, Colorado State, Washington State, and California State law, the Company is required to provide a reasonable estimate of the salary range for this job. Final determinations with respect to salary will take into account a number of factors, which may include, but not be limited to the primary work location and the chosen candidate's relevant skills, experience, and education.

Expected salary range:

Available benefits include bonus eligibility, health care and other insurance benefits (for employee and family), retirement benefits, paid holidays, vacation, and sick days. For Washington State Jobs, a summary of benefits is listed here.

Learn more about your rights, including under California, Colorado and other US State Acts

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:
Regular

Relocation:
No relocation

VISA Sponsorship:
Yes

Travel Requirements:
10%

Flexible Work Arrangements:
Hybrid

Shift:
1st - Day

Valid Driving License:
Yes

Hazardous Material(s):
N/A

Required Skills:
Business Intelligence (BI), Database Administration, Data Engineering, Data Management, Data Modeling, Data Visualization, Information Management, Information Technology (IT) Infrastructure, Network Infrastructures, Software Development

Preferred Skills:
Agile Systems, AWS CloudFormation, Data Applications, Data Integration, Data Quality Assessments, Data Transformation, Data Warehouse Development, Delivery Management, Documentations, Git, Git Flow, GitHub, HPC, HR Service Delivery, Information Technology Strategies, IT Documentation, IT Service Delivery, Pipeline Management, Project Documentation, Qualitative Analysis Software, Service Delivery, Software Application Testing, Software Documentation, Workflow Management

Requisition ID:R247735