Employment in this role is conditional upon successful execution of the contract by the client.

The Work

The Enterprise Architect III serves as a senior master data architect and is responsible for translating business requirements into specific systems, applications, and process designs with interlocked financial modeling for very large, complex technical solutions. The role analyzes service requirements and designs end‑to‑end solutions that meet business, technical, and financial objectives.

This position is a key expert in constructing comprehensive solutions, including scope, architecture, risk profile, staffing model, and corresponding financials. The Enterprise Architect III maintains deep industry and internal services knowledge to construct industry‑leading solutions that integrate process, technology, and people. The role also provides trusted advisory support as a subject matter expert (SME) for technical services and follows defined standard operating procedures for cost modeling, approvals, reviews, and all associated workflows and deliverables.

This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables

• 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.
• Other duties as assigned.

Here’s What You Need

The qualifications and skills listed below are intended to provide a general overview of the requirements for this position. However, due to the anticipated nature of the contract and the absence of a finalized task order from the client, this list should not be considered all-encompassing. Additional qualifications, certifications, skills, or experience specific to the client’s requirements may be identified and requested upon award of the task order. Candidates should demonstrate flexibility and a willingness to adapt to evolving responsibilities as outlined by the client.

• 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).
• Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

Minimum Skills:

• Exceptional interpersonal skills with the ability to communicate in a clear, professional, and articulate manner.
• Exceptional verbal and written communication skills.  
• Excellent organizational, analytical, and problem-solving skills with high-level attention to detail.
• Proven ability to multitask and prioritize in a fast past environment with changing priorities; adaptable to change and a quick learner.
• Must be self-motivated and able to work well independently as well as on a multi-functional team.
• Ability to handle sensitive and confidential information appropriately
• Proficient in MS Office, Word, Outlook, PowerPoint, and Excel.

Desired Qualifications:

• 5+ years of experience as an Oracle DBA or equivalent exposure to database administration concepts (performance, tuning, security, backup/recovery).
• 5+ years of experience installing and configuring Informatica Metadata Manager architecture or similar metadata management platforms.
• 5+ years of experience architecting enterprise‑scale MDM solutions, including multi‑domain implementations.
• 4+ years of experience with a Bachelor’s degree in Computer Science, Information Systems, Systems Engineering, or a related field; equivalent experience may be considered in lieu of a degree.

Our Commitment to you / overview of benefits

• 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

Reports to: Program Manager

Working Conditions

• Professional office environment with the ability to work on-site at the clients facility.
• Must be physically and mentally able to perform duties extended periods of time.
• Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
• Must be able to establish a productive and professional workspace.
• Must be able to sit for long periods of time looking at computer screen.

• May be asked to work a flexible schedule which may include holidays.
• May be asked to travel for business or professional development purposes.
• May be asked to work hours outside of normal business hours.

Other Duties: Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job.  Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer.  All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.