MDM Associate Analyst

WS to drive insights and ensure data reliability. The ideal candidate will have strong SQL, data profiling, and experience working with cross-functional teams in a pharma environment. To succeed in this role, the candidate must have strong experience on MDM (Master Data Management) on configuration (L3 Configuration, Assets creation, Data modeling etc), ETL and data mappings (CAI, CDI) , data mastering (Match/Merge and Survivorship rules), source and target integrations (RestAPI, Batch integration, Integration with Databricks tables etc)

Roles & Responsibilities:

• Analyze and manage customer master data using Reltio or Informatica MDM solutions.

• Perform advanced SQL queries and data analysis to validate and ensure master data integrity.

• Leverage Python, PySpark, and Databricks for scalable data processing and automation.

• Collaborate with business and data engineering teams for continuous improvement in MDM solutions.

• Implement data stewardship processes and workflows, including approval and DCR mechanisms.

• Utilize AWS cloud services for data storage and compute processes related to MDM.

• Contribute to metadata and data modeling activities.

• Track and manage data issues using tools such as JIRA and document processes in Confluence.

• Apply Life Sciences/Pharma industry context to ensure data standards and compliance.

Basic Qualifications and Experience:

• Master's degree with 1 - 3 years of experience in Business, Engineering, IT or related field OR

• Bachelor's degree with 2 - 5 years of experience in Business, Engineering, IT or related field OR

• Diploma with 6 - 8 years of experience in Business, Engineering, IT or related field

Functional Skills:

Must-Have Skills:

• Strong experience with Informatica or Reltio MDM platforms in building configurations from scratch (Like L3 configuration or Data modeling, Assets creations, Setting up API integrations, Orchestration)

• Strong experience in building data mappings, data profiling, creating and implementation business rules for data quality and data transformation

• Strong experience in implementing match and merge rules and survivorship of golden records

• Expertise in integrating master data records with downstream systems

• Very good understanding of DWH basics and good knowledge on data modeling

• Experience with IDQ, data modeling and approval workflow/DCR.

• Advanced SQL expertise and data wrangling.

• Exposure to Python and PySpark for data transformation workflows.

• Knowledge of MDM, data governance, stewardship, and profiling practices.

Good-to-Have Skills:

• Familiarity with Databricks and AWS architecture.

• Background in Life Sciences/Pharma industries.

• Familiarity with project tools like JIRA and Confluence.

• Basics of data engineering concepts.

Professional Certifications:

• Any ETL certification (e.g. Informatica)

• Any Data Analysis certification (SQL, Python, 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 teams

EQUAL OPPORTUNITY STATEMENT

Amgen 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.

.