Job was saved successfully.
Job was removed from Saved Jobs.

Job Details

Merck & Co, Inc

Data Architecture and Engineering Lead ( MERCUSR137111ENUS)

Engineering and Architecture

Architectural Engineering



Madison, New Jersey, United States

Job Description

Subject to applicable law, all prospective hires will be required to demonstrate that they have been fully vaccinated for COVID-19 or intend to be vaccinated for COVID-19 by November 1, 2021, or qualify for a medical or religious accommodation to this vaccination requirement. Hired candidates who are not vaccinated by November 1, 2021, and who have not been approved for a legally-required medical or religious accommodation will be subject to disciplinary action up to and including termination of employment, in accordance with applicable law.

Our IT team operates as a business partner proposing ideas and innovative solutions that enable new organizational capabilities. We collaborate internationally to deliver the services and solutions that help everyone to be more productive and enable innovation.


Experience with AWS cloud implementation using EC2 instance, S3 storage, Redshift and different services.

Lead a team of experienced Data Engineers to solve complex business Data Ingestion and Analytics solutions.

Proficiency to create and run AWS Glue, EMR, StreamSets, DataBricks or other ETL toolsets. Multiple toolsets knowledge is preferable.

Demonstrate ability to design and develop complex database loads and maintenance process.

Experience in developing Data Lake solutions on Redshift and developing data ingestion pipelines through AWS S3 or similar technologies.

Highly proficient in the use of SQL as well as extensive knowledge of OLAP technologies.

Deliver on data-driven projects through organization of team efforts and hands-on approach working.

Actively listen, and collaboratively translate commercial and business questions into data analysis and commercial solutions. Ability to work
across the organization and manage vendors.

Exposure to MDM (Master Data Management) integration such as SAP MDG, Informatica, Veeva Network.

Perform data management releases following our Company's standard SDLC as well as DevOps including hyper-care and follow-ups.

Partner with domain experts to verify and drive model capabilities and translate modeling outputs into business language.

Education: Bachelor's degree. University Degree in Computer Science, Math


7+ years of working experience developing database loads and ETL tools.

4+ years of working experience in developing and / or deploying complex Business Analytics solutions.

2+ years of delivering end-to-end data analysis including working with large data sets.

Must have worked on Agile development methods or DevOps CI/CD.

Must be Certified AWS Solutions Architect Associate or other Cloud certification.

Preferred Skills:

Experience with Enterprise data sets – Across Value chain of Commercial, Supply chain, and Research.

Managed vendor teams that handle technical development and support.

BI development experience for OLAP cubes with Spotfire / Qlik / PowerBI, etc.

Worked or supported Data Governance tools such as Collibra, Informatica, etc.

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.

Who we are …

We are known as Merck & Co., Inc., Kenilworth, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, we have been inventing for life, bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.

What we look for …

Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.


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.

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 Poster

EEOC GINA Supplement​

OFCCP EEO 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.

Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Kenilworth, NJ, USA, also known as Merck Sharp & Dohme Corp., Kenilworth, 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:



No relocation

VISA Sponsorship:


Travel Requirements:


Flexible Work Arrangements:



Not Indicated

Valid Driving License:


Hazardous Material(s):

Number of Openings:


Requisition ID:R137111