Master Data Management (MDM) Architect
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+3 more
Job description
HCAIβs Office of Technology Services (OTS) is hiring an Information Technology Specialist II - Master Data Management (MDM) Architect to serve as the departmentβs lead expert and technical authority for HCAIβs enterprise MDM platform. Reporting to the Data Operations Section Manager (IT Manager I) within the Infrastructure and Data Operations Branch, this role owns the maintenance, operations, and administration of the MDM environment and its mastered data domains - including the Master Patient Index (HPD Member Index), the Provider Organization Index, and other current and future domains such as the Master Facility Index and Master Address Table. As the lead position, the incumbent leads efforts to design and stand up new mastered domains, trains and mentors team members, and partners with programs across the Department to deliver trusted, governed master data in support of HCAIβs mission., * Own the maintenance, day-to-day operations, and administration of HCAIβs enterprise MDM platform and its mastered domains, including the Master Patient Index (HPD Member Index) and Provider Organization Index.
- Configure and maintain matching/linking rules, survivorship logic, golden-record strategies, and enterprise identifier (EID) assignment to ensure data quality, consistency, and accuracy across connected systems.
- Administer the MDM environment - installation, configuration, patching, upgrades, security (RBAC, Zero Trust alignment), monitoring/alerting, and backup/disaster recovery - in partnership with the Security Operations team.
- Lead the design, architecture, and implementation of new mastered domains, translating business requirements into entity models, source mappings, matching strategies, survivorship rules, workflows, and integration specifications.
- Lead root-cause analysis and resolution of MDM production issues, and oversee onboarding/retirement of source systems.
- Serve as the departmentβs recognized MDM expert; train, mentor, and cross-train team members and data stewards, and deliver knowledge-transfer sessions supporting succession planning.
- Advise management and help formulate MDM strategy, standards, and policy, including cost-benefit/ROI analysis for new domains and enhancements.
- Develop and maintain comprehensive documentation, including architecture diagrams, ERDs, process flows, runbooks, and operational procedures.
Effective July 1, 2025, specific Bargaining Units and associated Excluded State employees are subject to a salary reduction between 2% - 4.62% in exchange for Personal Leave Program 2025 (PLP 2025) hours each month. For more details about PLP 2025, visit the California Department of Human Resources (CalHR) website.
Take a 2-minute survey to tell us why you applied for HCAI! - https://forms.office.com/g/B6eXh2NKpZ, Californiaβs Department of Health Care Access and Information works to ensure that healthcare is available where Californians need it most. With offices in Sacramento and Los Angeles, we strengthen the stateβs healthcare system through facility construction, expanding the health workforce, and providing vital health information. Our diverse team upholds the values of professionalism, innovation, equity, and service. We provide tools and support to help you start, build, or transition your career while making a meaningful impact for all Californians.
At HCAIβs Office of Technology Services, we shape conversations and generate impactful insights about Californiaβs healthcare landscape from data submitted to us by hospitals, health plans, prescription drug manufacturers, and Californiaβs health workforce. These conversations and insights inform policymakers, researchers, community leaders, and the broader healthcare industry regarding topics such as health care cost transparency, the total cost of care, and health outcomes. Our mission is to expand equitable access to quality, affordable health care for all Californians and we want you to join us in our cause!
HCAI is committed to building an inclusive work environment that promotes diversity, where employees are appreciated and feel comfortable being their authentic selves. We value our employeesβ skills, experience, and unique perspectives because they enrich our workforce and make us stronger. We embrace and support a culture of equitable opportunity, empowering our employees to advance health care access and information for the diverse populations we serve across California.
Department Website: http://HCAI.ca.gov/
Application Instructions
Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application. Final Filing Date: 11/29/2026
Who May Apply Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list or LEAP eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply., A Statement of Qualifications (SOQ) is required. (The SOQ is a separate document with your Name and Job Control number noted on the top, typed in Arial 12 pt font, no more than two pages.) Resumes and cover letters do not take the place of the SOQ. Applications without a clearly titled SOQ or failure to follow instructions above will not be considered for the position.
- Describe your hands-on experience administering and operating an enterprise MDM platform. Include the mastered domains you were responsible for, how you configured and tuned matching/linking, survivorship, and golden-record logic, and the measurable improvements in data quality, match rates, or reliability you achieved.
- Describe your experience leading the design and implementation of a new mastered data domain from concept to production. Address how you performed source analysis and entity modeling, defined matching and survivorship rules, engaged data stewards and business owners outside your direct reporting line, and the outcomes delivered.
- As the lead position, this role serves as the departmentβs MDM subject-matter expert. Describe an example where you served as the recognized expert on a data platform - how you mentored or cross-trained team members, documented standards and procedures, and advised management on strategy or policy - and the impact on your teamβs resilience and the platformβs stability.
Requirements
Visa Sponsorship: HCAI is not an E-Verify employer and does not provide visa sponsorship. Applicants must be legally authorized to work in the United States at the time of appointment., In addition to evaluating each candidateβs relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:
- 5+ years of progressive IT experience in data, data platform, or data management roles.
- 3+ years of hands-on experience administering and operating a commercial MDM platform (e.g., Informatica MDM, Profisee, Semarchy, IBM, or Reltio).
- 3+ years designing and tuning matching/linking, survivorship, and golden-record logic across multiple mastered domains.
- 3+ years of hands-on experience with the Microsoft SQL Server stack (SQL Server, SSIS/ETL, and enterprise data warehousing).
- 2+ years leading requirements gathering and technical design for new mastered domains or major MDM enhancements.
- Experience with data governance, stewardship models, and data-quality monitoring with measurable improvements.
- Experience with AI-ready data preparation (data quality, metadata, lineage, and feature readiness).
- 2+ years collaborating with infrastructure, cloud, and cybersecurity peers on enterprise data platform deployments.
- Experience mentoring, cross-training, or leading technical staff on a specialized platform.
- Public-sector, healthcare, or regulated-industry experience preferred., Foreign Degrees or Transcripts - Applicants with foreign degrees or transcripts who wish to apply that coursework toward meeting the minimum qualifications of the classification must provide a transcript evaluation that indicates the number of units to which his/her foreign coursework is equivalent. HCAI accepts foreign transcript evaluations completed by agencies approved by the California Commission on Teacher Credentialing or by current members of the National Association of Credential Evaluation Services (NACES).
Benefits & conditions
HCAI is committed to fostering a flexible, inclusive, and high-performing work environment that supports both operational excellence and employee well-being.
HCAI is housed in a state-of-the-art building outside of downtown off Interstate-5. Enjoy a great work environment with many amenities, including FREE PARKING and fully equipped pay-per-charge electric vehicle charging stations. HCAI is close to many dining and shopping choices., In addition to competitive public employee wages and a comprehensive benefits package, our employees enjoy meaningful and interesting work that supports access to healthcare. To learn more about benefits for State employees, visit the Salary and Benefits page on the CalHR Benefits Website. University of California (UC) and California State University (CSU) employees may qualify to transfer their current and previous employment credit to State of California employment through CalPERS. Human Resources can help with this process upon employment or you can reach out to CalPERS for inquiries at (888) 225-7377.
About the company
HCAI supports a hybrid telework schedule for many positions, consistent with operational requirements. Telework schedules are only available for CA residents. The telework policy is subject to change, and additional in-office days may be required and/or minimal notification may be given to report to the worksite if an urgent need arises.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦