Enterprise Architect III

Cayuse Holdings

Enterprise Architect III at Cayuse responsible for advanced data architecture and MDM solutions. Collaborating with technical and non-technical groups to deliver comprehensive solutions.

Posted 6/11/2026full-timeAustin • Texas • 🇺🇸 United StatesSeniorLead💰 $118,560 - $166,400 per yearWebsite

Tech Stack

Tools & technologies

ETLInformaticaOracle

About the role

Key responsibilities & impact

Translate complex business requirements into specific system, application, integration, and process designs that support large‑scale enterprise solutions.
Develop end‑to‑end architectural blueprints encompassing data, application, integration, security, and infrastructure components, with a focus on MDM and analytics.
Construct detailed solution scope documents, including functional and non‑functional requirements, architectural decisions, and traceability back to business outcomes.
Define and maintain reference architectures, standards, and patterns for MDM, data integration, and analytics platforms.
Design and implement master data solutions for multi‑terabyte MDM implementations, with emphasis on healthcare provider and member domains.
Lead the development and implementation of new MDM capabilities using the Informatica application tool stack in IDMC (or equivalent platforms).
Collaborate with data architects and subject matter experts to model as‑is and to‑be processes involving master data, identity resolution, survivorship, and trusted attribution.
Ensure MDM solutions support enterprise data quality, data stewardship, and cross‑program data integration objectives.
Design and oversee extract/transform/load (ETL) processes using Oracle, Snowflake, Informatica PowerCenter, and related tools to load data into MDM and analytics environments.
Provide technical leadership for the development, testing, and maintenance of enhancements and upgrades to MDM application layers and related integration components.
Assume operational responsibility for metadata loads and metadata management processes, including lineage, cataloging, and impact analysis.
Ensure that build and deployment of MDM and ETL components comply with coding, security, and data governance standards.
Participate in the construction of detailed financial models that align with complex services proposals and solution architectures.
Develop risk assessments and corresponding mitigation plans for complex services and technology proposals, including technical, operational, and financial risks.
Align solution architectures with budgetary constraints, cost recovery models, and long‑term total cost of ownership (TCO) considerations.
Develop and refine effective AI prompts and query strategies to retrieve and synthesize master data for complex data domains.
Build and maintain a library of standardized prompts and query templates for common reporting and analytics needs.
Provide subject matter expertise on validating AI output, including identifying and mitigating hallucinations and ensuring adherence to data governance and compliance regulations.
Promote a data‑driven culture by enabling and empowering staff to effectively utilize data and AI capabilities for decision‑making.
Stay current on emerging AI, data analytics, and MDM tools and techniques and incorporate relevant innovations into enterprise architectures.
Work with program areas and sponsors to plan and execute multiple analytics and MDM‑related projects asynchronously.
Translate complex architectural concepts, project findings, and data limitations into simple, non‑technical language for leadership and program staff.
Provide expert guidance on interpreting data trends, master data impacts, and complex data questions across business domains.
Serve as a “trusted expert advisor” on technical services for internal stakeholders, including formal presentations and technical briefings.
Ensure that all solution designs, MDM implementations, and related integrations adhere to enterprise architecture standards, data governance policies, and security requirements.
Contribute to the definition and refinement of standards, guidelines, and best practices for MDM, data integration, and analytics.
Follow all organizational Standard Operating Procedures related to cost modeling, approvals, reviews, and associated workflows and deliverables.

Requirements

What you’ll need

8+ years of advanced Informatica and ETL development experience.
8+ years of experience and understanding of Enterprise Information Management (EIM) best practices.
8+ years of experience designing and implementing Master Data Management (MDM) solutions.
8+ years of experience designing and implementing custom solutions using Informatica PowerCenter (or equivalent ETL tooling).
8+ years of experience with data modeling tools such as Erwin and ER/Studio or equivalent functional toolsets.
8+ years of strong communication, analytical, and interpersonal experience working with stakeholders at all organizational levels.
8+ years of proven ability to work successfully with both technical and non‑technical groups and to manage multiple concurrent responsibilities.
8+ years of strong technical writing experience, including architecture documents, design specifications, and Statements of Work (SOWs).

Benefits

Comp & perks

Medical, Dental and Vision Insurance
Wellness Program
Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
Short-Term and Long-Term Disability options
Basic Life and AD&D Insurance (Company Provided)
Voluntary Life and AD&D options
401(k) Retirement Savings Plan with matching after one year
Paid Time Off

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

InformaticaETL developmentMaster Data Management (MDM)data modelingdata integrationanalyticsAI prompt developmentmetadata managementdata qualitydata governance

Soft Skills

communicationanalytical skillsinterpersonal skillstechnical writingstakeholder managementproject managementleadershipcollaborationproblem-solvingpresentation skills