Job description

Optum Insight is improving the flow of health data and information to create a more connected system. We remove friction and drive alignment between care providers and payers, and ultimately consumers. Our deep expertise in the industry and innovative technology empower us to help organizations reduce costs while improving risk management, quality and revenue growth. Ready to help us deliver results that improve lives? Join us to start Caring. Connecting. Growing together. Position Summary Optum is seeking an experienced Master Data Management (MDM) Technical Lead Architect to provide technical leadership and hands-on delivery for Master Data Management services supporting the Health and Human Services Innovation Incubator (HHSi2) project led by the Illinois Department of Healthcare and Family Services (HFS). This role will focus on Informatica MDM, Informatica PowerCenter, data integration, data quality, data governance, and analysis capabilities that support a unified cross-agency client/member view across State programs, as well as individual statewide MDM use cases. The Informatica MDM Architect to own the technical architecture and delivery of an on-premises Informatica MDM environment. The architect will provide expertise across Informatica MDM, PowerCenter, ETL, databases, complex SQL, Python automation, networking, servers, infrastructure, security, capacity, performance, and production operations. This position requires someone who can design the complete solution, make architecture decisions, guide technical teams, and personally troubleshoot issues across application and infrastructure layers. MDM Services Summary · • Partner with the MDM Statewide initiative supporting and combining different agency data sources. • Integrate State agency data to create a holistic view of the clients that the State serves and to administer all State agency programs more effectively and efficiently. • Provide advanced analytics, data quality analysis, business/data analysis, and MDM data specialists in support of the Illinois Health and Human Services Incubator (HHSi2) project. • Partner with the State to develop custom dashboards using data as part of the HHSi2 project • Provide technical expertise using Informatica MDM and related integration tools to support MDM data processing, data quality, and downstream system(s) needs. • Support data quality strategy while allowing for data quality analysis and other data governance activities. • Maintain data quality by using timely and consistent processes and evaluating data quality with the State. • Leverage established data governance practices and work with State staff and other vendors/partners to improve and validate data consistency and integrity. • Provide a structure to support business and data analysis using industry standard practices. • Data analysis to support policy development and program evaluation. • Identify opportunities/use-cases that help translate data analysis into cost savings and improved outcomes in programs and service areas. You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. Prefer CST time zone For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week. Primary Responsibilities: • Own MDM technical solution delivery, including review of technical documentation to design MDM solutions that meet business needs. • Design MDM solution with security by design and privacy by design and align with the Chief Information Security Office (CISO) guidelines. • Provide leadership and coordinate or lead work for Informatica Master Data Management and related MDM ETL delivery activities. • Use Informatica MDM tool to combine source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process. • Provide project direction and assign work to MDM ETL Specialists. • Ability to provide expertise and guidance with MDM and the Informatica MDM tool. • Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency. • Implement MDM jobs by creating mappings, mapplets, sessions, and workflows. • Work with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter. • Schedule and monitoring ETL/Informatica jobs in development, system testing, and production environment. • Document workflows and technical specifications. • Develop proactive processes for monitoring capacity and performance tuning. • Support and advise the development teams on technical issues. • Troubleshoot production support issues post-release deployment and produce solutions. • Troubleshoot server or software issues in coordination with State IT department • Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata. • Work directly with the Quality Assurance and business team to support validation, defect resolution, and testing of MDM-related data processes. • Participate in project discussions to document and recommend alternative technical solutions or requirements. • Participate in unit, integration, and system testing. • Maintain effective communication and relationships with all individuals involved with the project. • Learn new technologies as needed to be able to perform job duties effectively. • Provide status updates and meet deliverables to Optum's leadership and the State Project Managers. • Use other software tools such as Python as necessary to enhance MDM and data integration. You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in. Required Qualifications: • 8+ years of experience in MDM, ETL, data integration, enterprise data platforms. • 5+ years of hands-on experience with Informatica MDM and Informatica PowerCenter. • Strong experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs. • Strong SQL experience, with large MDM and DBMS enterprise relational platforms. • Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts. • Experience supporting ETL/MDM operations, performance tuning, issue resolution, and SDLC delivery. • Experience with Python programming for scripting, automation, testing, or data processing support. Preferred Qualifications: • Experience working in other MDM tools including Cloud-native MDM solutions. • Experience developing software or workflows in Python or other open-source tools. • Experience working in State Government, public sector, or regulated environments. • Experience with Agile/Scrum Sprint development and iterative/incremental delivery. • Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data. • 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, Data Lake, or comparable technologies is a plus. • Experience with on-prem-to-cloud migration, MDM modernization, or EDW / ETL modernization initiatives. • Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality is a plus. • Ability to operate in a telecommute environment and matrix organization with minimal direction. • Bachelor's degree in computer science, Data Analytics, Information Systems, Engineering, or equivalent experience. *All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $112,700 - $193,200 annually based on full-time employment. We comply with all minimum wage laws as applicable. Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants. At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission. UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations. UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.

Requirements

Must-haves

MDM Services Summary
Partner with the MDM Statewide initiative supporting and combining different agency data sources.
Integrate State agency data to create a holistic view of the clients that the State serves and to administer all State agency programs more effectively and efficiently.
Provide advanced analytics, data quality analysis, business/data analysis, and MDM data specialists in support of the Illinois Health and Human Services Incubator (HHSi2) project.
Partner with the State to develop custom dashboards using data as part of the HHSi2 project
Provide technical expertise using Informatica MDM and related integration tools to support MDM data processing, data quality, and downstream system(s) needs.
Support data quality strategy while allowing for data quality analysis and other data governance activities.
Maintain data quality by using timely and consistent processes and evaluating data quality with the State.
Leverage established data governance practices and work with State staff and other vendors/partners to improve and validate data consistency and integrity.
Provide a structure to support business and data analysis using industry standard practices.
Data analysis to support policy development and program evaluation.
Identify opportunities/use-cases that help translate data analysis into cost savings and improved outcomes in programs and service areas.
You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. Prefer CST time zone

Nice-to-haves

Experience working in other MDM tools including Cloud-native MDM solutions.
Experience developing software or workflows in Python or other open-source tools.
Experience working in State Government, public sector, or regulated environments.
Experience with Agile/Scrum Sprint development and iterative/incremental delivery.
Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data.
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, Data Lake, or comparable technologies is a plus.
Experience with on-prem-to-cloud migration, MDM modernization, or EDW / ETL modernization initiatives.
Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data quality is a plus.
Ability to operate in a telecommute environment and matrix organization with minimal direction.
Bachelor's degree in computer science, Data Analytics, Information Systems, Engineering, or equivalent experience.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonagilescrumazureaimlllm

Platform: radancy
Effort: medium

Benefits

Benefits detected in the listing.

401k