Job Description

Ingestion pipeline from various connectors to consolidated warehouse Setting up CICD pipeline Schema DesignCreate and mantain ELT pipelines using orchestration tools Data quality checks Apply business logic transformation based on business requirements Setting up connectors with different BI tools Setting up connectors including data gateways from consolidated platform to platforms like Power BI and ThoughtSpot  Data Cataloguing Data governance and access control Documenting data transformation pipelines Documenting and managing Technical and Business MetadataTechnical Proficiency:Proven experience in ETL pipeline development using orchestration tools SQL skills and experience with RDBMS Proficiency in programming languages such as PythonExperience with cloud data warehousing solutions like AWS RedshiftBI Tools Experience:Hands-on experience setting up and configuring BI tools like ThoughtSpot and PowerBI.Ability to optimize data models and schema designs for efficient BI tool performance.Data Management:Knowledge of data cataloguing tools (e.g., Apache Atlas, Informatica, Alation).Familiarity with data governance frameworks and best practices.

Current Employees apply HERE

Current Contingent Workers apply HERE

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:

Intern/Co-op (Fixed Term)

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Hybrid

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

07/31/2025

*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:R331653