Job
Description
MDM Associate Analyst We are seeking an MDM Associate Analyst with 25 years of development experience to support and enhance our enterprise MDM (Master Data Management) platforms using Informatica/Reltio . This role is critical in delivering high-quality master data solutions across the organization, utilizing modern tools like Databricks and AWS 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) in configuration (L3 Configuration, Assets creation, Data modeling, etc), ETL and data mappings (CAI, CDI), data mastering (Match/Merge and Survivorship rules), and source/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 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
