Design, implement, and maintain enterprise Master Data Management solutions for healthcare provider and member domains using Informatica (IDMC/PowerCenter). Build ETL pipelines into MDM using Oracle and Snowflake, manage metadata and deployments, collaborate with data architects and stakeholders, enforce governance and security standards, and develop/validate AI prompt/query templates for master data retrieval and synthesis.
This is a remote position.
The Master Data Architect will support the Health and Human Services Commission (HHSC) on the Enterprise Information Management (EIM) / Performance Management & Analytics System (PMAS) project. This position is an Information Technology role embedded within the EIM team, working in collaboration with the Office of Data Analytics and Performance (DAP) within the HHS system's business domain. The architect will design and implement master data solutions for a multi-terabyte Master Data Management (MDM) implementation using the Informatica application tool stack in the Informatica Data Management Cloud (IDMC). The role supports the mission of ensuring HHS master data is visible, accessible, understandable, trusted, and uniformly governed to advance data quality and enable integrated analytics across the HHS system. Work will follow an agile methodology consistent with current HHSC practices.
Responsibilities:
- Design and implement MDM solutions for healthcare provider and managed care member domains using the Informatica tool stack.
- Develop extract, transform, and load (ETL) processes for HHS system data into MDM applications using Oracle, Snowflake, and Informatica tools.
- Develop, test, and maintain enhancements and upgrades to MDM application layers.
- Collaborate with EIM data architects, HHS subject matter experts, and HHS system data models to accurately represent as-is and to-be process models involving HHS master data.
- Perform operational responsibilities for metadata loads and planning and monitoring of MDM and metadata project lifecycle deployments using agile methods.
- Ensure that the build and deployment of MDM components comply with HHSC IT coding and security standards.
- Develop and refine AI prompt and query strategies to retrieve and synthesize master data across complex data domains, including maintaining a library of standardized prompt and query templates.
- Validate AI-generated outputs with a focus on identifying and mitigating hallucinations, and ensure all data outputs adhere to agency reporting standards, data governance, and compliance regulations.
- Work with program areas and project sponsors to plan and execute multiple analytics projects asynchronously, communicating findings and data limitations to agency leadership in non-technical language.
- Collaborate with data engineering, IT, and program teams to troubleshoot data-related issues, address inconsistencies, and develop mitigation strategies.
Requirements
Minimum Qualifications:
- 8 years of experience with advanced Informatica and ETL development skills.
- 8 years of experience and understanding of Enterprise Information Management best practices.
- 8 years of experience designing and implementing Master Data Management solutions.
- 8 years of experience designing and implementing Informatica PowerCenter custom solutions.
- 8 years of experience with Erwin and ERStudio data modeling tools or equivalent functional toolsets.
- 8 years of demonstrated strong communication, analytical, and interpersonal skills across all levels of an organization.
- 8 years of proven ability to work successfully with technical and non-technical groups while managing multiple responsibilities.
- 8 years of demonstrated strong technical writing skills.
Preferred Qualifications:
- 5 years of experience as an Oracle DBA.
- 5 years of experience installing and configuring Informatica Metadata Manager architecture.
- 5 years of experience architecting Master Data Management solutions.
- Bachelor's degree in Computer Science, Systems Engineering, or equivalent experience.
Additional Requirements:
- Candidates must currently live in Texas; out-of-state candidates or candidates planning to relocate will not be considered.
- Criminal background check as authorized by Texas law prior to placement.
- All work products resulting from this engagement are considered works made for hire and are the property of HHSC.
Work Location and Schedule:
Location: 4601 W. Guadalupe, Austin, Texas 78751
Schedule: Monday through Friday, 8:00 AM to 5:00 PM, excluding Texas state holidays; evening, weekend, and holiday work may be required with advance approval.
Work Arrangement: Remote
Similar Jobs
Information Technology • Software • Financial Services • Big Data Analytics
Global Quantitative Researchers at Citadel leverage advanced statistical and quantitative techniques to drive investment strategies and optimize portfolios.
Top Skills:
C++Python
Digital Media • Information Technology • News + Entertainment
Full‑stack .NET developer responsible for writing, maintaining and optimizing code, designing APIs and system architecture, implementing unit/integration tests, supporting deployments, troubleshooting performance issues, and collaborating with QA and stakeholders. May work variable hours including nights/weekends.
Top Skills:
AjaxAngularAsp.NetBootstrapperC#Continuous IntegrationCSSEntity FrameworkGitHTMLIisIocJavaJavaScriptJqueryJSONLinqMvc 5Net Core 2.0Net FrameworkOrmSalesforce Experience CloudSap AbapSQL ServerTfsTypescriptVb.NetVisual StudioWeb ApiXML
Digital Media • Information Technology • News + Entertainment
Design, build, test, and deploy scalable Salesforce solutions across multi-cloud environments using Apex, LWC, Visualforce, declarative tools and integrations (MuleSoft/REST/SOAP). Lead configuration, data modeling, CI/CD, code reviews, troubleshooting, and Agile delivery while mentoring junior engineers and supporting platform governance and long-term architectural alignment.
Top Skills:
ApexCi/CdCopadoCSSFlowsGitHTMLJavaScriptLightning App BuilderLightning Web Components (Lwc)Media CloudMulesoftRest ApisSales CloudSalesforce Experience CloudService CloudSoap ApisSOQLSoslVisualforce
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
