Job Description
Required Skills:
Business Intelligence (BI), Database Administration, Data Engineering, Data Management, Data Modeling, Data Visualization, Design Applications, Information Management, Software Development, Software Development Life Cycle (SDLC), System Designs
Preferred Skills:
Current Employees apply HERE
Current Contingent Workers apply HERE
Secondary Language(s) Job Description:
The Opportunity
- Based in Hyderabad, join a global healthcare biopharma company and be part of a 130- year legacy of success backed by ethical integrity, forward momentum, and an inspiring mission to achieve new milestones in global healthcare.
- Be part of an organisation driven by digital technology and data-backed approaches that support a diversified portfolio of prescription medicines, vaccines, and animal health products.
- Drive innovation and execution excellence. Be a part of a team with passion for using data, analytics, and insights to drive decision-making, and which creates custom software, allowing us to tackle some of the world's greatest health threats.
Our Technology Centers focus on creating a space where teams can come together to deliver business solutions that save and improve lives. An integral part of our companys’ IT operating model, Tech Centers are globally distributed locations where each IT division has employees to enable our digital transformation journey and drive business outcomes. These locations, in addition to the other sites, are essential to supporting our business and strategy.
A focused group of leaders in each Tech Center helps to ensure we can manage and improve each location, from investing in growth, success, and well-being of our people, to making sure colleagues from each IT division feel a sense of belonging to managing critical emergencies. And together, we must leverage the strength of our team to collaborate globally to optimize connections and share best practices across the Tech Centers.
Role Overview:
The Senior Data Engineer will serve as the primary internal expert responsible for modern data engineering and database design across the Business Operations Technology (BOT) product line. This role delivers a unified, scalable, and high‑quality data foundation across multiple business areas—eliminating silos, ensuring performance, and strengthening consistency in database schemas, data models, pipelines, and architecture patterns.
In addition to building and operating data pipelines, this role owns end‑to‑end database design—from conceptual and logical modeling through physical implementation—ensuring data structures are performant, secure, extensible, and aligned with enterprise standards.
The Senior Data Engineer will design and maintain efficient data pipelines using SQL, Databricks, Airflow, and DBT, while enabling reliable ingestion, transformation, and orchestration of data across domains. Over time, this position may evolve into a data architecture leadership role, shaping BOT’s strategic data and database direction.
Key Responsibilities:
Data Engineering & Pipeline Development
- Design, build, and optimize scalable ETL/ELT pipelines using modern data engineering tools (SQL, Databricks, Airflow, DBT).
- Automate data ingestion, transformation, and validation to support both analytical and operational use cases.
- Ensure data pipelines are reliable, maintainable, and aligned with enterprise engineering standards.
Database Design & Data Architecture
- Design and govern database schemas, including conceptual, logical, and physical data models, to support both transactional and analytical workloads.
- Apply database normalization, denormalization, indexing, partitioning, and query optimization techniques to ensure performance and scalability.
- Define and enforce naming conventions, schema standards, data types, constraints, and referential integrity rules across databases.
- Design and evolve OLTP, OLAP, and Lakehouse data structures, balancing performance, flexibility, and cost.
- Lead the definition of data integration and database design patterns that promote reuse and cross‑domain consistency.
- Partner with architecture and product teams to align database and data architecture decisions with the broader technical roadmap.
Performance, Quality, & Governance
- Monitor, tune, and enhance data performance across ingestion, transformation, and compute layers.
- Implement best practices for quality assurance, including automated data quality checks, lineage capture, and validation processes.
- Contribute to documenting database designs, data dictionaries, schema evolution strategies, and engineering standards to support strong governance and long‑term maintainability.
Collaboration & Leadership
- Work closely with product teams, analysts, and data consumers to translate business requirements into scalable engineering solutions.
- Collaborate with DevOps and cloud engineering teams to ensure database schema deployments, version control, and infrastructure as code operate seamlessly within CI/CD pipelines.
- Mentor junior team members and foster a culture of best practices in data engineering across the BOT organization.
Required Qualifications
Education
- Bachelor’s degree in Data Engineering, Computer Science, Information Systems, or related field preferred.
Technical Expertise
- 6+ years of hands-on experience in data engineering or large-scale data pipeline development.
- Strong proficiency in SQL and modern data processing tools (Databricks, Airflow, DBT, Spark, or similar).
- Experience designing and maintaining production-grade data pipelines in cloud environments.
- Solid understanding of ETL/ELT principles, data modeling, distributed processing, and data orchestration frameworks.
- Ability to troubleshoot complex data issues across ingestion, transformation, and processing layers.
- Familiarity with DevOps concepts, CI/CD integration, and source-controlled data workflows.
- Expert T-SQL: Mastery of DDL, DML, CTEs, and window functions for complex data manipulation.
- Azure SQL Database: Deep knowledge of PaaS offerings, including scaling, security, and backup/recovery.
- Azure Data Factory: Experience with triggers, parameters, and linked services for orchestration.
- Automation: Proficiency in database management, elastic job agent, and infrastructure automation.
Soft Skills
- Strong analytical problem-solving skills with a focus on long-term maintainability.
- Clear communicator capable of working effectively with cross-functional technical and business teams.
- Proactive, ownership-driven, and committed to high-quality engineering practices.
Preferred Qualifications
- Experience with enterprise data governance, metadata management, or lineage tools.
- Knowledge of Azure or AWS data services and cloud-native data patterns.
- Experience influencing architectural direction or contributing to enterprise-level data strategies.
- Comfort working in fast-paced, multi-team product-line environments.
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.
#HYDIT2026
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:
VISA Sponsorship:
Travel Requirements:
Flexible Work Arrangements:
Hybrid
Shift:
Valid Driving License:
Hazardous Material(s):
Job Posting End Date:
03/6/2026
*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.
