Job Information
Merck Senior Specialist, Data Engineering (multiple openings) in North Wales, Pennsylvania
Job Description
Responsibilities:
Design, develop and maintain data pipelines to extract data from a variety of sources and populate data lake and data warehouse.
Work with data governance team and implement data quality checks and maintain data catalogs.
Use Orchestration, logging, and monitoring tools to build resilient pipelines.
Utilize test driven development methodology when building ELT/ETL pipelines.
Understand and apply concepts like data lake, data warehouse, lake-house, data mesh and data-fabric where relevant.
Develop data models for cloud data warehouses like Redshift and Snowflake.
Develop pipelines to ingest data into cloud data warehouses.
Analyze data using SQL and Collaborate with Data Analyst, Data scientists, Machine Learning Engineers to identify and transform data for ingestion, exploration, and modeling.
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 and create technical documentation as needed.
Requirements:
Bachelor’s degree or equivalent in Mathematics, Computer Science, Engineering, Artificial Intelligence, or a related field and 5 years of experience in the position offered or related.
Must have 5 years of experience with all of the following: SQL and PySpark; Git, Docker, and Terraform; Agile Methodology; and experience with Jenkins pipelines.
Must have 1 year of experience with all of the following: feature engineering pipelines and re-useability in both training and inference stages; creating docker images for ML models and custom python scripts; operationalizing and governing machine learning models using AWS Sagemaker; designing, developing, and maintaining pipelines using Python and serverless AWS services; and AWS services like S3, ECS, Fargate, Glue, StepFunctions, CloudWatch, Lambda, and EMR.
10% domestic and international travel required by year.
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 (https://wd5.myworkday.com/msd/d/task/1422$6687.htmld)
Current Contingent Workers apply HERE (https://wd5.myworkday.com/msd/d/task/1422$4020.htmld)
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 (https://survey.sogosurvey.com/r/aCdfqL) if you need an accommodation during the application or hiring process.
We are an Equal Opportunity Employer, committed to fostering an inclusive and diverse workplace. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status, or other applicable legally protected characteristics. For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit:
EEOC Know Your Rights (https://www.eeoc.gov/sites/default/files/2022-10/22-088_EEOC_KnowYourRights_10_20.pdf)
EEOC GINA Supplement
Pay Transparency Nondiscrimination (https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf)
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.
Learn more about your rights, including under California, Colorado and other US State Acts (https://www.msdprivacy.com/us/en/CCPA-notice/)
U.S. Hybrid Work Model
Effective September 5, 2023, employees in office-based positions in the U.S. will be working a Hybrid work consisting of three total days on-site per week, generally Tuesday, Wednesday and either Monday or Thursday, although the specific days may vary by site or organization, with Friday designated as a remote-working day, unless business critical tasks require an on-site presence. This Hybrid work model does not apply to, and daily in-person attendance is required for, field-based positions; facility-based, manufacturing-based, or research-based positions where the work to be performed is located at a Company site; positions covered by a collective-bargaining agreement (unless the agreement provides for hybrid work); or any other position for which the Company has determined the job requirements cannot be reasonably met working remotely. Please note, this Hybrid work model guidance also does not apply to roles that have been designated as “remote”.
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:
No
Travel Requirements:
10%
Flexible Work Arrangements:
Hybrid
Shift:
1st - Day
Valid Driving License:
No
Hazardous Material(s):
No
Job Posting End Date:
08/6/2024
*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.
Job Posting End Date: 09/03/2024
A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.
Requisition ID: R293352
Merck
-
- Merck Jobs