Factspan - MDM Data Analyst - SQL

Job Description :

We are seeking a highly skilled and detail-oriented MDM Data Analyst to support enterprise-wide Master Data Management initiatives. The ideal candidate will possess strong expertise in MDM concepts, data analysis, migration validation, data quality, and large-scale data transformation using modern data engineering tools and platforms.

The role involves working closely with business, engineering, and data governance teams to ensure accurate, consistent, and reliable master data across systems and domains.

Key Responsibilities :

Master Data Management & Data Analysis :

- Analyze and manage master data across multiple domains including customer, product, vendor, and reference data.

- Understand and implement MDM concepts including entities, domains, hierarchies, relationships, and survivorship rules.

- Support MDM design, data mapping, and governance activities across enterprise applications.

- Identify data inconsistencies, duplication, and quality issues and recommend corrective actions.

Data Querying, Validation & Transformation :

- Develop and optimize complex SQL queries for large-scale data analysis and validation.

- Utilize PySpark and Python for data transformation, cleansing, and reconciliation activities within Databricks environments.

- Perform data profiling, data quality analysis, and validation checks across multiple systems.

- Support ingestion, transformation, and synchronization of master data between enterprise platforms.

Migration & Integration Support :

- Participate in pre-migration, migration, and post-migration analysis activities.

- Conduct reconciliation analysis and validate migrated data accuracy and completeness.

- Support integration of MDM systems with downstream and upstream applications using REST APIs and data interfaces.

- Work on cross-system data integration and data consistency validation.

Testing & Quality Assurance :

- Support SIT (System Integration Testing) and UAT (User Acceptance Testing) activities.

- Create test scenarios, test cases, and validation frameworks for MDM implementations.

- Validate data relationships, business rules, and hierarchy structures during testing cycles.

- Collaborate with QA and business teams to resolve defects and data-related issues.

Stakeholder Collaboration & Governance :

- Work closely with data governance, engineering, business, and application teams.

- Support documentation of data flows, transformation logic, and business rules.

- Ensure adherence to enterprise data governance standards and compliance requirements.

- Contribute to continuous improvement initiatives within MDM and data management processes.

Desired Candidate Profile :

- 6-11 years of experience in Data Analysis, Master Data Management, or Data Engineering roles.

- Strong understanding of MDM concepts, data models, entities, hierarchies, and relationships.

- Hands-on experience with Informatica MDM, Reltio, or similar MDM platforms.

- Strong proficiency in SQL, PySpark, and Python.

- Experience working with Databricks and modern data platforms.

- Exposure to REST APIs and enterprise data integration frameworks.

- Experience in data migration, reconciliation, validation, and testing activities.

- Strong analytical, problem-solving, and communication skills.

- Ability to work in cross-functional and fast-paced environments.

Preferred Skills :

- Master Data Management (MDM)

- Informatica MDM

- Reltio

- SQL

- PySpark

- Python

- Databricks

- Data Validation