Solutions Architect, Senior

Trinity Health • Livonia, MI

2d • $122,855 - $202,711

About The Position

The Senior Solutions Architect partners with business users and executive stakeholders to translate business needs into well-defined requirements and scalable data solutions. The role is responsible for the architecture, design, and delivery of enterprise data warehouse, analytics, and healthcare application solutions, with deep expertise in data modeling and ETL. It provides strategic direction for data platforms, business intelligence, interoperability, data governance, and advanced analytics, aligning technology investments with organizational goals.

The architect defines end-to-end data architectures aligned with enterprise standards and business strategy; designs enterprise data warehouse and master data management solutions; and leads scalable, secure, high-performing, cost-efficient cloud solutions in Microsoft Azure. The role also architects unified analytics solutions on Microsoft Fabric, including OneLake, data engineering, data warehousing, and Power BI integration.

The position works directly with business users and executive stakeholders to elicit and document requirements, translate needs into functional specifications and solution designs, and deliver custom applications, KPI frameworks, operational reports, executive scorecards, and analytics for revenue cycle and payer/provider domains. It designs conceptual, logical, and physical data models and oversees ETL integration from multiple source systems, using SQL and Python for transformation, integration, and analysis. Reporting and analytics tools include Power BI, Tableau, and Business Objects.

Healthcare responsibilities include architecting provider data management solutions, provider master data and directories, credentialing and enrollment, network and affiliation, and payer/provider contract data. The role designs provider data models, MDM and data quality frameworks, and integrations across EHR, credentialing, payer, and enterprise systems to establish a trusted source of provider information. It requires knowledge of healthcare operations, clinical workflows, payer/provider business models, regulatory requirements, EHR platforms, and healthcare interoperability standards.

This is a full-time, day-shift position in a typical office environment. The incumbent may travel up to 20% for project assignments. The employer cannot sponsor H-1B visas or accommodate STEM OPT EADs for this role.

Requirements

• Bachelor's degree in healthcare or information technology, or an equivalent combination of education and experience.
• Eight to ten years of progressively responsible experience in information technology, or an equivalent combination of education and experience.
• Eight to ten years of progressive experience with expert-level knowledge of hardware, software, application, and systems engineering in multiple IT disciplines.
• At least five years of experience in the healthcare industry and three years in enterprise solution architecture.
• Expert technical knowledge and understanding of multiple architectures, applications, systems design, entity relationships, and integration.
• Thorough understanding of modern enterprise architecture and commitment to following and holding others accountable to best practices.
• Expert knowledge of healthcare processes and data linkages across clinical, financial, and patient administrative areas in acute care and outpatient settings.
• Ability to understand and communicate in nontechnical terms how components interact as a whole; knowledge of multiple components of enterprise architecture.
• Knowledge of business re-engineering principles and processes, and basic knowledge of financial analysis and models.
• Ability to lead, coach, and mentor across teams in communication, collaboration, best practices, and quality of work.
• Ability to drive short-term actions consistent with long-term goals, balance short- and long-term implications, and apply multiple solutions to business problems.
• At least seven years of experience designing and developing processing, reporting, analytic, and application solutions that support end-user decision-making.
• Experience writing functional and design specifications; developing data enhancement processes and applications; and developing and integrating standard structures, processes, delivery methods, and end-user solutions.
• Experience with multiple technical architectures and languages.
• Excellent organizational, analytical, interpersonal, written, and verbal communication skills.
• Ability to work collaboratively across product management methodology teams and in a collaborative, shared-leadership environment.
• Demonstrated knowledge of healthcare nomenclature and clinical and financial business processes.
• Personal presence characterized by honesty, integrity, and caring, with the ability to inspire and motivate others in support of Trinity Health's philosophy, mission, vision, goals, and values.
• Extensive experience architecting and delivering provider data management solutions, including provider master data and directories, credentialing and enrollment, network and affiliation, and payer/provider contract data.
• Deep knowledge of healthcare operations, clinical workflows, payer/provider business models, and regulatory requirements.
• Experience working with EHR platforms such as Epic, Cerner, Meditech, or Allscripts.
• Strong understanding of healthcare standards and interoperability, including HL7, FHIR, X12, ICD-10, and CPT.
• Ability to meet established deadlines and manage multiple projects while adapting to interruptions.
• Ability to travel up to 20% for project assignments.

Responsibilities

• Define end-to-end solution data architectures aligned with enterprise architecture standards, business strategy, and organizational goals.
• Architect Enterprise Data Warehouse (EDW) and Master Data Management (MDM) solutions.
• Design scalable cloud-based data platforms in Microsoft Azure, with attention to scalability, security, performance, and cost efficiency.
• Architect unified analytics solutions on Microsoft Fabric, including OneLake, data engineering, data warehousing, and Power BI integration.
• Provide strategic direction for data governance, interoperability, and advanced analytics initiatives.
• Partner with business users and executive stakeholders to elicit, define, and document business and technical requirements.
• Translate business needs into functional specifications, data requirements, and solution designs for development teams.
• Design custom applications, KPI frameworks, operational reports, and executive scorecards for revenue cycle and payer/provider business domains.
• Deliver analytics solutions that support executive leadership and operational decision-making.
• Design conceptual, logical, and physical data models for enterprise data warehouse, MDM, and reporting needs.
• Architect and oversee ETL processes integrating, transforming, and loading data from multiple source systems into enterprise data platforms.
• Apply SQL and Python to data transformation, integration, and analysis.
• Architect and deliver provider data management solutions, including provider master data and directories, credentialing and enrollment, network and affiliation, and payer/provider contract data.
• Design provider data models, MDM and data quality frameworks, and ETL integration across EHR, credentialing, payer, and enterprise systems.
• Develop and integrate standard structures, processes, delivery methods, and comprehensive end-user solutions.
• Develop data enhancement processes and applications, and write functional and design specifications.
• Develop and enforce change management processes.
• Lead, coach, and mentor across teams in communication, collaboration, best practices, and quality of work.
• Collaborate across product management methodology teams, including Management, Engineering, and Optimization.
• Travel up to 20% for project assignments and meet established deadlines.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior