Remote Sr MDM SaaS Architect

Post Date

May 02, 2023

Location

Cincinnati,
Ohio

ZIP/Postal Code

45202
US
Aug 14, 2025 Insight Global

Job Type

Contract

Category

Data Warehousing

Req #

CIN-621191

Pay Rate

$91 - $137 (hourly estimate)

Job Description

An employer is looking for a Sr MDM Architect to sit fully remote. This person will be joining the MDM team within the data group to help with the creation and management of Enterprise MDM strategy, building of roadmap, and creation and maintenance of MDM multi-domain enterprise level solutions. It is also responsible for providing strategic guidance, tools selection, best practices, and architecture for MDM practice, and leading the initiation and implementation of Master Data Management MDM implementations for their business units. Some additional responsibilities include:



* Responsible for creation, implementation, and management of MDM solution architecture

* Contribute to the development of MDM strategy and roadmap.

* Responsible for applying MDM strategies, requirements, and policies, and supporting an MDM implementation on Informatica platform technologies.

* Accountable for creation and application of MDM standards and best practices, enterprise level data flow diagrams, and project code promotion

* Responsible for analysis, development, testing, deployment, and support of MDM solutions

* Analyze and determine how data fits into the Master Data Management (MDM) platform, including changes to data model, data cleansing rules, data standardization/match-merge rules, survivorship rules, Reference data management, and data visualization.

* Work on design options, data model changes, integration techniques (ingress and egress), and data mastering solutions

* Develop and maintain ETL codes in MDM/ IDQ ingress and egress process.

* Resolve database and data load errors due to data related or other system issues.

* Modify C360 UI and backend mapping based on user requirements

* Conducts MDM unit tests, code reviews & deployments

* Coordinate with Informatica Product Support for critical issues

* Monitor KPI's of the MDM solution to ensure data quality and established policies are working as expected

* Provide Consultation on MDM Data Model to Business and other IT partners

* Build strong partnership with Business SME's. MDM Consumers, and Data Stewards

Required Skills & Experience

1-2 years of experience with Informatica MDM SaaS

10+ years of hands-on data/ETL experience

Data Modeling

Data Integration and analysis

Data Validation

Data Quality/Data Profiling

Data Stewardship

Experience with Informatica MDM CDI and CSQ

Nice to Have Skills & Experience

Experience with Snowflake, data-lakes, enterprise data warehouses, Tableau or other BI reporting solutions

Property and Casualty (P&C) Insurance industry experience

Knowledge of XML, Java, JSONs along with API's development and shell scripting

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.