MDM Data Architect – Insurance Master Data

Tech Mirrors; New Jersey; On-site; Full time

Job description

Position:Data Architect
Location:Warren, NJ | Hybrid –Nearby state

Need candidates with strong P&C insurance domain experience.

Key Responsibilities

• Platform Implementation & ConfigurationLead end-to-end design, configuration, and deployment of theProfisee MDM platform, including entity modeling, stewardship workflows, matching/merging rules, and survivorship logic.
• Architect and build master data domains includingPolicy, Customer/Party, Agent, Vendor, Location, and Productreference 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 & StewardshipPartner 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 & IntegrationDesign 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 > Silver > Gold layers.
• Ensure high availability, disaster recovery, and scalability of the Profisee deployment on Azure.
• Data Quality & AnalyticsDefine, 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 & DocumentationTranslate 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’s 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.