MDM Engineer

Career CategoryInformation SystemsJob DescriptionABOUT AMGENAmgen harnesses the best of biology and technology to fight the world's toughest diseases, and make people's lives easier, fuller and longer. We discover, develop, manufacture and deliver innovative medicines to help millions of patients. Amgen helped establish the biotechnology industry more than 40 years ago and remains on the cutting-edge of innovation, using technology and human genetic data to push beyond what's known today.ABOUT THE ROLERole Description:We are seeking an experienced MDM Engineer with 8–12 years of experience to lead development and operations of our Master Data Management (MDM) platforms, with hands-on experience in data engineering experience. This role will involve handling the backend data engineering solution within MDM team. This is a technical role that will require hands-on work. To succeed in this role, the candidate must have strong Data Engineering experience. Candidate must have experience on technologies like (SQL, Python, PySpark, Databricks, AWS, API Integrations etc).Roles & Responsibilities:Develop distributed data pipelines using PySpark on Databricks for ingesting, transforming, and publishing master dataWrite optimized SQL for large-scale data processing, including complex joins, window functions, and CTEs for MDM logicImplement match/merge algorithms and survivorship rules using Informatica MDM or Reltio APIsBuild and maintain Delta Lake tables with schema evolution and versioning for master data domainsUse AWS services like S3, Glue, Lambda, and Step Functions for orchestrating MDM workflowsAutomate data quality checks using IDQ or custom PySpark validators with rule-based profilingIntegrate external enrichment sources (e.g., D&B, LexisNexis) via REST APIs and batch pipelinesDesign and deploy CI/CD pipelines using GitHub Actions or Jenkins for Databricks notebooks and jobsMonitor pipeline health using Databricks Jobs API, CloudWatch, and custom logging frameworksImplement fine-grained access control using Unity Catalog and attribute-based policies for MDM datasetsUse MLflow for tracking model-based entity resolution experiments if ML-based matching is appliedCollaborate with data stewards to expose curated MDM views via REST endpoints or Delta SharingBasic Qualifications and Experience:8 to 13 years of experience in Business, Engineering, IT or related field Functional Skills:Must-Have Skills:Advanced proficiency in PySpark for distributed data processing and transformationStrong SQL skills for complex data modeling, cleansing, and aggregation logicHands-on experience with Databricks including Delta Lake, notebooks, and job orchestrationDeep understanding of MDM concepts including match/merge, survivorship, and golden record creationExperience with MDM platforms like Informatica MDM or Reltio, including REST API integrationProficiency in AWS services such as S3, Glue, Lambda, Step Functions, and IAMFamiliarity with data quality frameworks and tools like Informatica IDQ or custom rule enginesExperience building CI/CD pipelines for data workflows using GitHub Actions, Jenkins, or similarKnowledge of schema evolution, versioning, and metadata management in data lakesAbility to implement lineage and observability using Unity Catalog or third-party toolsComfort with Unix shell scripting or Python for orchestration and automationHands on experience on RESTful APIs for ingesting external data sources and enrichment feedsGood-to-Have Skills:Experience with Tableau or PowerBI for reporting MDM insights.Exposure to Agile practices and tools (JIRA, Confluence).Prior experience in Pharma/Life Sciences.Understanding of compliance and regulatory considerations in master data.Professional Certifications:Any MDM certification (e.g. Informatica, Reltio etc)Any Data Analysis certification (SQL, Python, PySpark, Databricks)Any cloud certification (AWS or AZURE)Soft Skills:Strong analytical abilities to assess and improve master data processes and solutions.Excellent verbal and written communication skills, with the ability to convey complex data concepts clearly to technical and non-technical stakeholders.Effective problem-solving skills to address data-related issues and implement scalable solutions.Ability to work effectively with global, virtual teamsEQUAL OPPORTUNITY STATEMENTAmgen is an Equal Opportunity employer and will consider you without regard to your race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.We will ensure that individuals with disabilities are provided with reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.GCF Level 05A.