Senior Specialist, Data Architect, #HCGT 7189

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 company ’ s 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 Specialist, Data Architect will play a key role in the design, development, and global rollout of enterprise analytics solutions on modern data platforms. This role involves close collaboration with business stakeholders, functional teams, and external partners to deliver analytical and reporting solutions aligned with organizational standards and strategic goals. The incumbent will participate in end-to-end implementation activities, including requirements gathering, solution and data design, development, testing coordination, and post–go-live support. A strong focus will be placed on adhering to SDLC standards and lifecycle management processes while ensuring high-quality, secure, and scalable analytics solutions are delivered to our most critical finance and corporate stakeholders. The role will also contribute to ongoing remediation initiatives related to enterprise ERP modernization programs, working within a diverse, globally distributed team environment. This position requires strong technical leadership across data architecture and analytics engineering, effective cross-functional collaboration skills, and a commitment to operational excellence and knowledge sharing. What will you do in this role: Be part of implementation projects and contribute to global rollouts of analytics solutions Partner with stakeholders to capture and refine analytical requirements and define measurable outcomes Translate functional requirements into technical solution designs (data models, interfaces, and reporting layers) Design and evolve canonical data models (conceptual, logical, and physical) aligned to business domains Define and enforce data architecture standards (naming conventions, modeling patterns, integration approaches) Develop and review data pipelines, transformations, and curated datasets to support reporting and self-service analytics Coordinate selected delivery tasks with external teams and ensure quality through code review and design review Support and help coordinate testing activities (SIT/UAT), including reconciliation and data quality validation Provide post-go-live and hyper care support and contribute to knowledge transfer sessions to support teams Follow company’s lifecycle management processes and ensure adherence to SDLC standards Deliver on remediation activities related to ERP modernization and downstream reporting impacts. You will work in a diverse environment and collaborate with colleagues from different locations . What should you have: Primary Skill: Expertise in data architecture ,Strong architectural design skills, Proficiency in SAP Datasphere, In-depth understanding of data migration and related details Bachelor's degree in computer science , Information Technology, or a related field, or equivalent experience. 7+ years of experience delivering enterprise data, analytics, and reporting solutions in complex environments Experience supporting ERP/finance data domains (e.g., record-to-report, order-to-cash, procure -to-pay) and translating business processes into analytical needs Strong data architecture and data modeling skills (conceptual/logical/physical modeling ; dimensional modeling ; normalization vs. denormalization) Practical experience designing data integration patterns (batch/ELT/ETL, CDC, API/event-based) and defining interface contracts Proficiency with SQL and hands-on experience implementing transformations, reusable semantic layers, and performance-optimized datasets Experience with modern data platforms and tooling (cloud data warehouses/lakes, orchestration, metadata/ catalog capabilities) Solid understanding of data quality, reconciliation, lineage, and controls required for regulated environments Experience contributing to ERP modernization or migration programs and managing downstream analytics impacts is a plus Ability to work effectively within a cross-functional, multicultural team environment Very good communication skills and ability to support multiple initiatives in a regulated pharma environment However, we will be happy if you know or have exposure to one of these: Programming/scripting for data engineering (e.g., Python) Common enterprise BI/reporting tools (e.g., Power BI, BusinessObjects) Semantic/metrics layers and self-service analytics enablement 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 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. #HYDIT2025 Required Skills: Animal Vaccination, Business Intelligence (BI), Business Partnerships, Cross-Functional Collaboration, Database Administration, Data Engineering, Data Management, Data Modeling, Data Visualization, Design Applications, Digital Technology, Digital Transformation, Dimensional Modeling, Enterprise Data, Information Management, Information Technology Operations, Metadata Management, Operational Excellence, Procure-to-Pay, Software Development, Software Development Life Cycle (SDLC), System Designs, Technical Leadership 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: 06/18/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.