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

Job Details

Merck & Co, Inc

Datamodeler Lead - Supply Chain (Remote)


Lead Developer


Rahway, New Jersey, United States

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.

Job Description

As Data modeler lead , you will be responsible for following but not limited to ,

  • Deliver our Manufacturing Division divisional analytics initiatives with primary focus on data modeling for all analytics uses cases e,g Self Services , Business Intelligence & Analytics, Data exploration, Data Wrangling etc.

  • Host and lead requirement/process workshop to understand the requirements of data modeling .

  • Analysis of business requirements and work with architecture team to deliver & contribute to feasibility analysis , implementation plans and high-level estimates.

  • Based on business process and analysis of data sources, deliver detailed ETL design with mapping of data model covering all areas of Data warehousing for all analytics use cases .

  • Creation of data model & transformation mapping in modeling tool and deploy in databases including creation of schedule orchestration jobs .

  • Deployment of Data modeling configuration to Target systems ( SIT , UAT & Prod ) .

  • Understanding of Product ownership and management . 8Lead Datamodel as a product for focus areas of our Manufacturing Division Divisional supply chain domain .

  • Creation of required SDLC documentation as per project requirements.

  • Optimization/industrialization of existing database and data transformation solution

  • Prepare and update Data modeling and DWH best practices along with foundational platforms .

  • Work very closely with foundational product teams , Business , vendors and technology support teams to build team to deliver business initiatives .

Education Requirement: Bachelors degree ( prefer B.S. or M.S. in IT, Engineering, Computer Science, or related field)


  • 8+ years working experience with Data modeling in Data Warehousing (DWH) , Data Mesh or any analytics related implementation.

  • 5+ years of working experience in creating logical & Physical datamodels in any modeling tool ( SAP Power designer ,Wherescape etc ).

  • 5+ years of working experience in implementing end to end DWH solutions involving creating design of DWH and deploying the solution

  • Working experience in creating datamodeling standards , best practices and implementation process.

  • High Proficiency in Information Management, Data Analysis and Reporting Requirement Elicitation

  • Experience working with extracting business rules to develop transformations, data lineage, and dimension data modeling

  • Advanced knowledge of SQL and data transformation practices

  • Excellent communication skills.

  • Previous work experience in Redshift or similar databases using DDL, DML, Query optimization, Schema management, Security, etc

  • Previous work experience with Airflow or similar orchestration tool

Preferred Experience and Skills:

  • Independently support business discussions, analyze, and develop/deliver code

  • Exposure to AWS modules such as S3, AWS Console, Glue, Spectrum, etc management

  • Has knowledge of ETL methods, willingness to learn ETL technologies

  • Experience working with validating legacy and developed data model outputs

  • Development experience using Wherescape or similar ETL/Data Modeling tools

  • Exposure to Qlik or similar BI dashboarding applications

  • Experience working on projects where Agile methodology is leveraed

  • Understanding of data management best practices and data analytics

  • Ability to lead requirements sessions with clients and project teams

  • Strong leadership, verbal and written communication skills with ability to articulate results and issues to internal and client teams

  • Demonstrated experience in the Life Science space

  • Exposure to SAP domain data is a plus

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., Rahway, 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.


For positions located in the United States and Puerto Rico – Subject to applicable law, all new hires (including internal transfers) must demonstrate that they are fully vaccinated against COVID-19 or that they qualify for a medical or religious exemption to this vaccination requirement. New hires (including internal transfers) to a position that, as determined by the Company, requires routine collaboration with external stakeholders (such as roles in health services or customer-facing commercial or research-based roles) (“Customer-Facing Role”) who are not vaccinated must qualify for a medical or religious exemption and be in a position that the Company determines can accommodate unvaccinated employees without causing an undue burden to business operations. If, following dialog with the candidate as appropriate, it is determined that the candidate either a) does not qualify for a religious or medical exemption or, b) for candidates applying for Customer-Facing roles, it is determined that allowing the candidate to work without vaccination would cause an undue burden to the Company, the candidate will be ineligible for hire or transfer, or any offer of employment or transfer (if applicable) will be revoked. Please note that notwithstanding the approval of any reasonable accommodation, the Company reserves the right to monitor, modify, or revoke any such accommodation if it is determined, following dialog with the employee, that the accommodation is no longer effective or results in an undue burden to the Company.

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.

Under New York City 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:

$96,700.00 - $164,500.00

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:



No relocation

VISA Sponsorship:


Travel Requirements:


Flexible Work Arrangements:

Remote Work


Valid Driving License:

Hazardous Material(s):

Number of Openings:


Requisition ID:R201786