Senior Informatica MDM Architect

Overview

Allied Consultants, Inc is a proudly Austin based firm with over 34 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Senior Informatica MDM Architect to play a key role within a high-impact technical services team.

 

At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including:

• Highly competitive pay rates
• Local support staff for responsive, personal service
• Comprehensive benefits package, including:
  • Medical insurance (with employer cost sharing)
  • Life insurance
  • A 401(K) plan with company match
  • Flexible spending through a cafeteria plan

Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks.

 

Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Responsibilities

Client's IT is continuing to develop a Master Data Management (MDM) function under the Performance Management & Analytics System (PMAS) on the Enterprise Information Management (EIM) team. This development effort will utilize an agile methodology based upon the approach currently in use at client's for the Performance Management & Analytics System (PMAS). As a lead and member of the EIM team, the worker responsibilities may include:

 

Overview

The MDM Architect position is an Information Technology (IT) position and will be a part of the Enterprise Information Management (EIM) team working in collaboration with the Office of Data Analytics & Performance (DAP) within the client’s business domain. This architect designs and implements master data solutions for a multi-terabyte Master Data Management (MDM) implementation.

 

The mission of EIM is to ensure client's master data is visible, accessible where appropriate, understandable in context, trusted by users, and uniformly governed in order to advance data quality and support integrated data analytics in the Integrated Continuum of Care Analytics initiative. This enables data-driven decision making across the client's system.

 

The worker:

• Has an excellent understanding of MDM principles, goals, and tools and how these relate to overall client's data quality and cross-program data integrations.
• Is responsible for development and implementation of new MDM capabilities using the Informatica application tool stack in IDMC.
• Works collaboratively with EIM program staff, with client's Information Technology (IT) resources, and MDM business analysts to implement new program requirements for mastering critical agency data, identity resolution, trusted attribution, and governed reference data.

The applicant will be able to demonstrate extensive experience in:

• Developing MDM solutions for healthcare provider and managed care member domains (using an Informatica tool stack).
• Developing extract/transform/load processes for client's system data into MDM applications (using Oracle, Snowflake and Informatica tools).
• Developing, testing, and maintenance of enhancements/upgrades to MDM application layer(s).
• Working closely with EIM data architects, client's subject matter experts, and client's system data models to accurately represent as-is and to-be process models involving client's master data.
• Operational responsibility for metadata loads.
• Planning and monitoring MDM/Metadata project lifecycle deployment using agile methods.
• Ensuring that the build and deployment of the MDM components are of high quality and comply client's IT coding and security standards.

Strategic Liaison and Translation

• Work with program areas and project sponsor to plan and execute multiple analytics projects asynchronously. 
• Explain project findings and data limitations in simple, non-technical language to agency leadership and program staff.

AI Prompting and Data Synthesis

• Develop and refine effective AI prompts and query strategies to retrieve and synthesize master data for complex data domains.
• Develop a library of standardized prompts and query templates for common reporting needs.
• Provide subject matter expertise on validating output from AI, particularly with respect to identifying and mitigating hallucinations.
• Ensure all data outputs adhere to