Lead Architect, MDM (Master Data Management)- OI Government State Solutions - Remote

UnitedHealth Group•US, Illinois, IL

1d•$112,700 - $193,200•Remote

About The Position

Optum is seeking an experienced Master Data Management (MDM) Technical Lead Architect to provide technical leadership and hands-on delivery for MDM services supporting the Health and Human Services Innovation Incubator (HHSi2) project led by the Illinois Department of Healthcare and Family Services. The role focuses on Informatica MDM, Informatica PowerCenter, data integration, data quality, data governance, and analysis to support a unified cross-agency client/member view and statewide MDM use cases. The position leads MDM technical delivery, guides MDM/ETL specialists and developers, supports Informatica workflows and data loads, develops and optimizes SQL and Python-enabled automation, troubleshoots production issues, supports QA and testing, and helps maintain reliable MDM operations. The role partners with State agencies to combine data sources, support advanced analytics and data quality activities, develop custom dashboards, and use analysis to inform policy development and program evaluation. This is a 100% telecommute role for candidates located within the continental United States, aligned with project requirements; a Central U.S., Illinois, or Midwest location is preferred. Occasional travel may be required. Employees in the Minneapolis or Washington, D.C. area must work in the office at least four days per week. The salary range is $112,700–$193,200 annually, based on full-time employment.

Requirements

8+ years of experience in MDM, ETL, data integration, or enterprise data platforms.
5+ years of hands-on MDM experience on any platform.
5+ years of Python programming for scripting, automation, testing, or data-processing support.
Solid experience developing Informatica ETL mappings, mapplets, sessions, workflows, and transformations, and scheduling, monitoring, and troubleshooting Informatica jobs.
Solid SQL experience with large MDM and enterprise relational database platforms.
Experience with data quality, matching, unique client/member identifiers, standardization, reconciliation, and data governance concepts.
Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery.
Must be located within the continental United States in alignment with project requirements.
Remote employees must adhere to UnitedHealth Group’s Telecommuter Policy.
Candidates are required to pass a drug test before beginning employment.

Nice To Haves

Experience with other MDM tools, including cloud-native MDM solutions.
Experience developing software or workflows in Python or other open-source tools.
Experience in State Government, the public sector, or regulated environments.
Experience with Agile/Scrum sprint development and iterative or incremental delivery.
Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data.
Experience with on-premises-to-cloud migration, MDM modernization, or EDW/ETL modernization initiatives.
Exposure to interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR.
Exposure to cloud data platforms or modernization initiatives such as Azure, ADF, Databricks, Snowflake, or Data Lake.
Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality.
Ability to work effectively in a telecommute environment and matrix organization with minimal direction.
Central U.S., Illinois, or Midwest location.

Responsibilities

Own MDM technical solution delivery, including reviewing technical documentation and designing solutions that meet business needs.
Design MDM solutions with security and privacy by design, aligned with Chief Information Security Office guidelines.
Lead and coordinate Informatica MDM and related MDM ETL delivery activities, providing project direction and assigning work to MDM ETL Specialists.
Use Informatica MDM to combine agency source data, apply transformations and corrections, and add fields through the change request process.
Automate data staging by scheduling scripts to run at optimal times to improve system performance and efficiency.
Implement MDM jobs by creating mappings, mapplets, sessions, and workflows, using ETL transformations such as Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank, Source Qualifier, Lookup, and Sorter.
Schedule and monitor Informatica ETL jobs in development, system testing, and production environments.
Document workflows and technical specifications, and develop proactive capacity-monitoring and performance-tuning processes.
Advise development teams on technical issues and troubleshoot production issues after deployment, producing solutions.
Troubleshoot server and software issues in coordination with the State IT department.
Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata.
Work with Quality Assurance and business teams on validation, defect resolution, and testing of MDM-related data processes.
Participate in project discussions, recommend alternative technical solutions or requirements, and participate in unit, integration, and system testing.
Maintain effective communication and relationships with project participants; provide status updates and meet deliverables for Optum leadership and State Project Managers.
Use Python and other software tools as needed to enhance MDM and data integration, and learn new technologies as necessary.
Support data quality analysis and governance, validate data consistency and integrity with State staff and partners, and help identify use cases that translate analysis into cost savings and improved program outcomes.
Partner with State agencies to integrate data, support advanced analytics and business/data analysis, and develop custom dashboards for the HHSi2 project.