Senior Specialist, Data Analyst

Job Description

R383383 Senior Specialist, Data Analyst

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 Centres focus on creating a space where teams can come together to deliver business solutions that save and improve lives. An integral part of our company’s IT operating model, Tech Centres 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 Centre 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 Centres.

Role Overview

We are looking for a highly skilled Senior Business & Data Analyst to lead the analysis, design, and lifecycle development of data products within the IT Data Domain. In this role, you will partner closely with Product Owners, Data Engineers, Domain SMEs, and stakeholders across the organization to define how data should be structured, transformed, and delivered to create value.

You will analyze complex IT operational and service‑management datasets, design transformation logic, and articulate data requirements that pipeline engineers implement using DBT and modern data stacks. You will also act as a senior voice in the domain—challenging assumptions, influencing design decisions, shaping data standards, and championing high‑quality, meaningful data.

The ideal candidate blends strong analytical depth, data modeling skills, domain expertise, and leadership behaviors such as strategic thinking, active listening, challenging the status quo, and articulating data value clearly.

What will you do in this role

Data Product Analysis & Design

Lead the analysis and definition of data products across the IT Data Domain, shaping product scope, critical data elements, and business rules.

Translate domain needs into clear data models, semantic definitions, and transformation logic consumed by data pipeline engineers (DBT), design and built prototypes proving the value prior the industrialization.

Analyze source systems and upstream IT process data (ITSM, IT Operations, Monitoring, CMDB, etc.) to determine feasibility, linkage, grain, and relationships.

Create detailed logic specifications, including join rules, derivations, filters, and quality expectations.

• Ensure data models meet business objectives around availability, reliability, observability, and usability.

Data Domain Ownership & Standards

• Act as a senior steward of the IT Data Domain—ensuring definitions, business terms, lineage, and transformations are consistent and understandable.
• Contribute to data product governance, metadata quality, and domain‑level documentation aligned with modern SDLC and DQ practices.
• Facilitate alignment on domain conventions, data design decisions, and prioritization across teams.

Stakeholder Engagement & Requirements Leadership

• Engage business and technical stakeholders to elicit, refine, and challenge requirements for new and existing data products.
• Communicate complex data concepts in clear, structured ways to senior leadership and operational teams.
• Rationalize competing requirements, highlight trade‑offs, and propose MVP vs. iterative enhancements.
• Lead requirements grooming, user story definition, acceptance criteria, and refinement sessions.

Senior Analytical Expertise

• Explore and interpret operational, service management, monitoring, and lifecycle data to uncover insights and inform product design.
• Validate data quality and completeness, identify anomalies, and proactively recommend improvements.
• Apply strong SQL and data‑preparation expertise to design transformation prototypes and assess data readiness.

Collaboration With Data Engineers & IT Teams

·Work closely with engineers to ensure transformation logic is fully understood, testable, and implementable using DBT.

·Participate in schema evolution, testing cycles, and design reviews to ensure alignment between analysis and implementation.

·Support efficient query design, performance optimization, and architectural considerations for large‑scale IT data.

Leadership & Influence

·Influence decisions across the IT Data Domain using data‑driven reasoning and domain expertise.

·Challenge the status quo by proposing modern, scalable approaches to modeling, data productization, and transformation.

·Actively listen, build strong relationships, and promote a shared understanding of data’s business value.

·Mentor analysts and partner teams on best practices for data modeling, requirements, and product thinking.

What you should have :

Core Experience

·4-8 years in analytics, business/data analysis, or data product‑related roles.

·Strong experience with IT Service Management, IT Operations processes as well as CMDB concepts.

·Proven record designing datasets, crafting transformation logic, and working with modern data platforms (SQL, data warehouses, or similar).

·Strong understanding of data modeling, data lineage, and semantic layer concepts.

Technical Skills

·Advanced SQL and experience with data querying, analysing transforming and restructuring at scale

·Experience collaborating with engineering teams implementing pipelines (DBT, ETL tools, or similar).

·Familiarity with BI tools (Power BI, Spotfire, etc.) and their data‑shaping requirements.

·Understanding of SDLC, data governance practices, and metadata management.

Leadership Behaviors

• Strong influencing skills and ability to rationalize proposed designs or prototypes.
• Active listener who can balance stakeholder needs and challenge assumptions constructively.
• Clear and compelling communicator with the ability to articulate the business value of data.
• Ability to shape requirements, lead workshops, and guide teams toward high‑quality analytical outcomes.

Nice to Have

• Experience with ITIL processes or enterprise IT data flows.
• Familiarity with AI/ML concepts, feature readiness, and data observability practices.
• Knowledge of data quality frameworks and data product lifecycle management.

Our technology teams operate as business partners, proposing ideas and innovative solutions that enable new organizational capabilities. We collaborate internationally to deliver services and solutions that help everyone be more productive and enable innovation.

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 lives, 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

Required Skills:

Business Intelligence (BI), Data Management, Data Modeling, Data Visualization, Measurement Analysis, Stakeholder Relationship Management, Waterfall Model

Preferred Skills:

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:

Regular

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Hybrid

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

03/11/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.