Associate Director, Data Engineering

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. What will you do in this role: Enterprise Technical Leadership: Serves as a senior technical leader and key advisor for data engineering, partnering with Enterprise Architecture to co-create technical vision, data blueprints, and engineering standards across the organization. Complex Pipeline Architecture: Leads the design and implementation of highly complex, end-to-end data pipeline architectures utilizing IDMC (Informatica Intelligent Data Management Cloud), Databricks, and AWS to support global commercial and manufacturing analytics. Enterprise Platform Strategy: Establishes best-practice architectures for Databricks Lakehouses (Unity Catalog, Delta Lake optimization) and highly secure AWS infrastructures. Salesforce & Veeva Ecosystem Mastery: Champions the architectural strategy for massive data replication, migration, and synchronization between Salesforce (e.g., Salesforce Life Sciences Cloud, Veeva CRM) and downstream analytical platforms. Data Integration & ETL Governance: Owns the enterprise architecture for IDMC, defining patterns for secure agents, high-throughput mappings, reusable taskflows, and hybrid cloud integration strategies. Cross-Functional Architecture Alignment: Collaborates intensively with principal architects, product owners, and commercial business leads to translate corporate objectives into robust, compliant, and scalable technical solutions. Compliance & Quality Standards: Holds ultimate accountability for the technical compliance, data quality, and security of delivered assets, ensuring strict adherence to SDLC software validation, privacy laws, and security protocols. Innovation & Advanced Technology R&D: Spearheads technical exploration, prototyping, and proof-of-concept initiatives for emerging trends such as real-time streaming, generative AI pipeline components, and automated data quality monitoring. Mentorship & Talent Cultivation: Mentors senior engineering talent and guides engineering squads, raising the collective technical capability and establishing a strong "community of practice." Primary skills (must-have) Principal-Level Programming: Mastery of programing languages and advanced SQL; deep understanding of memory management, cluster configuration, and query tuning in distributed systems. Enterprise IDMC Architecture: Demonstrated expertise in designing large-scale integration solutions using Informatica Intelligent Data Management Cloud (IDMC), including API management, performance tuning, and Secure Agent architecture. Databricks Lakehouse Mastery: Advanced experience structuring enterprise Lakehouses, managing global schema permissions via Unity Catalog, and optimizing read/write speeds using Delta Lake configurations. AWS Cloud Engineering: Mastery in building serverless cloud architectures on AWS using Infrastructure as Code and orchestrating services like S3, Lambda, IAM, and Step Functions. Salesforce & Commercial Analytics Integration: Proven track record of architecting high-volume synchronization processes from Salesforce/Veeva CRM to central warehouses while preserving performance and data integrity. Enterprise Data Modeling: Industry-leading expertise in dimensional modeling, data lake design patterns, Slowly Changing Dimensions (SCD), and semantic layer architecture. Compliance & Validation Governance: Solid understanding of data privacy frameworks, commercial compliance standards, and SDLC validation workflows. Technical Influence & Advisory: Outstanding ability to communicate technical roadmaps, architectural risks, and complex trade-offs to senior leadership, and business stakeholders. Primary skills (must-have) · Enterprise IDMC Architecture · Databricks Lakehouse Mastery · Salesforce & Commercial Analytics Integration · Enterprise Data Modeling · Technical Influence & Advisory Secondary skills (nice to have) · AWS Cloud Engineering 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. Additional location(s) Compensation Information: Required Skills: Amazon Web Services (AWS), Amazon Web Services (AWS), Business Architecture, Business Intelligence (BI), Cloud Architectures, Cloud Technology, Database Administration, Databricks Unified Data Analytics Platform, Data Compliance, Data Engineering, Data Lake, Data Management, Data Modeling, Data Visualization, Design Applications, Engineering Leadership, Enterprise Architecture Strategy, Information Management, Platform Design, Platform Development, Platform Management, Proof of Concept (POC), Serverless Computing, Software Development, Software Development Life Cycle (SDLC) {+ 4 more} Preferred Skills: Current Employees apply HERE Current Contingent Workers apply HERE Secondary Language(s) Job Description: #MSDHYDIT 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: Domestic VISA Sponsorship: No Travel Requirements: No Travel Required Flexible Work Arrangements: Hybrid Shift: Not Indicated Valid Driving License: No Hazardous Material(s): n/a Job Posting End Date: 11/5/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.