Senior Data Engineer

Job Description

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.

As our Human Health Insights Engine US Data Hub SR Data Engineer at Merck, you will be part of inventing tomorrow. Our Innovative centers are where great people come together and deliver solutions that save and improve lives.

We are seeking motivated talent interested in solving problems to improve tomorrow.

You will:

The primary responsibility of the senior data engineer will be to perform elicit data requirements, profile datasets and drive the delivery of innovative, quality data products for the Human Health Insights Engine US Data Hub which is a data warehouse that supports US commercial operations. This will include the following:

  • Profile datasets and partner with data suppliers and data owners to prepare data technical metadata/data dictionary and assess the data fit for the requested business purpose
  • Partner with business and IT teams to understand their data needs and to design conformed datasets which can be broadly used to fulfil those requirements
  • Define the data acquisition patterns to be used for new datasets prioritized in the data product backlog
  • Design curated datasets which fulfill the user needs prioritized in the data product backlog. These datasets may include creation of new metrics; application of business rules; harmonization/deduplication of datasets across multiple sources; and aggregation of datasets
  • Actively assess performance and quality of existing datasets to identify opportunities for improvement
  • Identify new data patterns and design standardized methods for addressing those patterns in partnership with the solution architect
  • Provide 3rd line support to investigate complex production data issues which cannot be resolved by production support teams
  • As a data subject matter expert, support the Business in the understanding and interpretation of commercial data and help to derive approaches for how data can be used to support effective commercial operations
  • Communicate requirements to and direct data product developers/testers who will implement the data acquisition and curation activities
  • Define and manage metadata describing the curated and conformed datasets contained within the US Data Hub
  • Present data requirements and outcomes of data analysis to the Business and internal IT colleagues.
  • Actively facilitate in project scoping and/or business requirement sessions
  • Collaborate with vendors to drive solutions and influence product solution road map
  • Provide support to design, construction and testing phases of the project(s)
  • Collaborate with other team members (involved in the requirements gathering, testing, roll-out and operations phases) to ensure seamless transitions.
  • Mentor junior analysts to drive best practice analysis on all projects

You will work and learn more about:
  • US Merck Commercial strategy
  • Enabling data products to support business strategy
  • Working within the market and leveraging the hub network
  • Utilizing external and internal data to support Business driven commercial insights

Educational Requirements:
  • B.S. or M.S. in IT, Engineering, Computer Science, or related field

Required Experience:
  • A minimum of 5 years of relevant work experience, with demonstrated expertise in the BI and Analytics space
  • Experience doing data analysis and engineering, using SQL, GLUE and other standard data querying and profiling tools.
  • Experience with database and ETL Tools
  • Experience with leading requirements sessions with clients and project teams.
  • Excellent written and oral communication skills along with the ability to present clear and concise solutions to stakeholders and IT partners

Preferred Experience:
  • 4+ years of data engineering and design experience
  • 2+ years of experience with cloud-based data warehouse and/or data lake solutions
  • Deep understanding of data management best practices and data analytics
  • Ability to distill complex concepts into easy-to-understand frameworks and presentations
  • Experience with agile development methodologies and best practices.
  • Knowledge of data profiling tools (i.e. Glue).
  • Experience working with pharmaceutical commercial data
  • Up to speed with latest technologies in data engineering, data warehousing, and data management
  • Ability to work independently in a complex environment
  • Experience working with on and off-shore engineering resources, including vendor delivery teams
  • High Proficiency in Information Management, Data Analysis and Data Requirement Elicitation
  • Strong communication and leadership skills and possess the ability to forge strong working relationships with various stakeholders
  • Experience with data warehouse/data lake design and data modeling concepts.

Our Support Functions deliver services and makes recommendations about ways to enhance our workplace and the experience of working at 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 ...

In a world of rapid innovation, we seek brave Inventors who want to make an Impact in all aspects of our business, enabling breakthroughs that will affect generations to come. We encourage you to bring your disruptive thinking, collaborative spirit and diverse perspective to our organization. Together we will continue Inventing For Life, Impacting Lives while Inspiring Your Career Growth.

Invent. Impact. Inspire.


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:


VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:
Remote Work, Telecommuting


Valid Driving License:

Hazardous Material(s):

Number of Openings:

Requisition ID:R113414