MDM Associate Analyst

MDM Associate Analyst

MDM Associate Analyst

SQL

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

  13 years

  of experience in Business, Engineering, IT or related field

• Bachelor's degree

  with

  25 years

  of experience in Business, Engineering, IT or related field

• Diploma

  with

  68 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 (e.g., L3 configuration, Data modeling, Asset creation, API integrations, Orchestration)
• Strong experience in building data mappings, profiling, and implementing business rules for data quality and transformation
• Expertise in implementing match/merge rules and survivorship of golden records
• Experience integrating master data records with downstream systems
• Good understanding of data warehouse (DWH) concepts and strong knowledge of data modeling
• Experience with IDQ, data modeling, 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

  (e.g., 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