Master Data Management Consultant

Company Description

Excelque is a US-based IT consulting startup known for its high-performance delivery and a commitment to quality. Our team of highly skilled technical professionals supports clients in meeting their technology staffing requirements efficiently and successfully. By leveraging our quick turnaround times and expertise, Excelque creates tailored solutions for diverse business needs. We are dedicated to providing value-driven consulting services that help organizations thrive in an ever-evolving technology landscape.

Master Data Management (MDM) Consultant – Profisee Platform

Department: Data & Analytics / Enterprise Architecture

Location: Warren, NJ | Hybrid -(Onsite Interview )

Employment Type: Contract

If you are interested in this position, please share your updated resume at:

praneetha@excelque.org

Job Description

leading Property & Casualty insurance company and a subsidiary of MS&AD Insurance Group

We are seeking an experienced Master Data Management (MDM) Consultant with deep, hands-on expertise in the Profisee MDM platform to join our Data & Analytics team. This role is pivotal in establishing and maturing our enterprise MDM capabilities, ensuring the integrity, consistency, and governance of critical business data across our P&C insurance operations.

The ideal candidate brings a blend of technical platform expertise, data governance acumen, and insurance domain knowledge to design, implement, and operationalize robust MDM solutions that serve as the authoritative source of truth for our enterprise data assets.

Key Responsibilities

Platform Implementation & Configuration

• Lead end-to-end design, configuration, and deployment of the Profisee MDM platform, including entity modeling, stewardship workflows, matching/merging rules, and survivorship logic.
• Architect and build master data domains including Policy, Customer/Party, Agent, Vendor, Location, and Product reference data tailored to P&C insurance business needs.
• Configure Profisee's Hub, Spoke, and Registry styles of MDM as appropriate for each data domain.
• Develop and maintain data quality rules, validation logic, and survivorship hierarchies within Profisee.
• Integrate Profisee with upstream and downstream systems including Microsoft Fabric, Databricks, Azure Data Lake (OneLake), Snowflake, policy administration systems, and claims management systems.

Data Governance & Stewardship

• Partner with Data Governance and business stakeholders to define Master Data policies, standards, and stewardship workflows.
• Design and configure business stewardship workflows in Profisee, enabling data stewards across Underwriting, Claims, and Actuarial domains to manage data quality exceptions.
• Establish golden record definitions and survivorship rules in alignment with business requirements.
• Support the development of data lineage, data catalog integration, and metadata management using tools such as Microsoft Purview.

Architecture & Integration

• Design MDM integration patterns using REST APIs, Azure Service Bus, Event Hub, and ETL/ELT pipelines to ensure bi-directional synchronization between Profisee and enterprise systems.
• Collaborate with the Enterprise Architecture team to align MDM solutions with the broader Data Mesh / Data Platform strategy, ensuring master data is published as trusted data products to domain teams.
• Build and maintain Delta Lake / Medallion architecture pipelines that ingest, cleanse, and promote master data from Bronze $B"*(B Silver $B"*(B Gold layers.
• Ensure high availability, disaster recovery, and scalability of the Profisee deployment on Azure.

Data Quality & Analytics

• Define, implement, and monitor Data Quality KPIs and dashboards for master data health across all domains.
• Conduct root cause analysis on data quality issues and drive remediation efforts in collaboration with source system owners.
• Develop data profiling and anomaly detection processes to proactively identify master data integrity issues.

Stakeholder Engagement & Documentation

• Translate complex MDM and data governance concepts into clear, actionable guidance for business and technical stakeholders.
• Produce and maintain comprehensive technical documentation including solution designs, data models, integration specifications, runbooks, and stewardship guides.
• Provide training and enablement to data stewards, analysts, and IT teams on Profisee platform usage and MDM best practices.
• Actively participate in Agile/Scrum ceremonies, contributing to sprint planning, backlog grooming, and retrospectives.

Required Qualifications

Education

• Bachelor$B!G(Bs degree in computer science, Information Systems, Data Management, or a related field. Master's degree preferred.

Experience

• 5 years of experience in enterprise data management, with at least 3 years of hands-on, production-level experience with the Profisee MDM platform.
• Demonstrated experience delivering MDM solutions in financial services, insurance, or similarly regulated industries.
• Proven track record of implementing Party/Customer, Policy, or Product master data domains in complex enterprise environments.

Technical Skills

• Profisee MDM: Entity modeling, match/merge configuration, survivorship rules, stewardship workflows, Profisee APIs, Profisee Hub administration.
• Cloud & Data Platforms: Microsoft Azure (Data Lake Gen2, Azure SQL, Azure Service Bus, Azure DevOps), Microsoft Fabric / OneLake, Databricks, Snowflake.
• Integration: REST APIs, Azure Data Factory, Azure Logic Apps, Event-driven architectures.
• Data Engineering: SQL (T-SQL/ANSI), Python, PySpark, Delta Lake, Medallion architecture.
• Data Governance: Microsoft Purview, data cataloging, data lineage, metadata management.
• DevOps: CI/CD pipelines, Git, Infrastructure-as-Code (Bicep/Terraform preferred).

Soft Skills

• Strong analytical and problem-solving skills with a detail-oriented mindset.
• Excellent communication skills — able to bridge the gap between technical teams and business stakeholders.
• Self-starter with the ability to manage multiple priorities in a fast-paced, regulated environment.

Preferred Qualifications

• Profisee Certification or formal Profisee training credentials.
• Experience with P&C insurance data including Policy, Claims, Reinsurance, Actuarial, or Agent/Producer data.
• Familiarity with NAIC regulatory reporting requirements and insurance data standards.
• Experience with Data Mesh architectures and domain-oriented data ownership models.
• Knowledge of SOC 2, CCPA, or GDPR compliance requirements as they relate to master data.
• Experience with Collibra, Alation, or Microsoft Purview for enterprise data catalog and governance.
• Familiarity with Agile/SAFe delivery methodologies.