Solutions Architect

Solutions Architect# Careers## Solutions Architect Apply:
University Hospital:
Full time:
Posted Today:
R160319

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessible application. If you have questions while submitting an application, please review these frequently asked questions.
** Current Employees and Students:
** If you are currently employed or enrolled as a student at The Ohio State University, please log in to Workday to use the internal application process.

Welcome to The Ohio State University's career site.  We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following:
* Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.
* Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application.##

Job Title:

Solutions Architect## Department:

Health System Shared Services | Analytics Center of Excellence
** Position Summary
** The Solutions Architect serves as a top-level technical authority and architectural lead for complex enterprise data and analytics initiatives that align technology capabilities with clinical, operational, and strategic priorities. This role defines the target-state architecture, standards, patterns, and guardrails for secure, scalable, resilient, and cost-effective data platforms that support analytics, reporting, interoperability, and advanced AI/ML use cases.  This position partners closely with clinical and operational leaders, analytics teams, data engineering, data science, data governance, platform teams, security, vendors, and IT stakeholders to translate business capabilities and data requirements into sustainable enterprise architecture.  

The Solutions Architect provides architectural oversight across the data lifecycle - ingestion, integration, transformation, modeling, storage, security, deployment, observability, and consumption - while establishing reusable standards and reference architectures. Recognized across the organization for expertise in data architecture, cloud and lakehouse strategy, engineering standards, governance, performance, and platform modernization.
** Key Responsibilities
*** Define enterprise architecture, reference patterns, and technical standards for data ingestion and integration (ETL/ELT) using technologies such as SQL and Python, ensuring solutions can support high-volume, high-complexity healthcare data.
* Own and evolve the target-state lakehouse architecture using Azure services and Databricks, including architectural patterns for Delta Lake, scalability, workload isolation, performance optimization, resiliency, and cost management.
* Establish architectural standards for medallion architecture (bronze/silver/gold), including clear responsibilities for ingestion, standardization, integration, curated semantic data products, and downstream consumption.
* Define enterprise data modeling and transformation standards using dbt (or equivalent) and proven modeling practices, including dimensional modeling, star schemas, conformed dimensions, semantic layers, and reusable data products.
* Establish enterprise data quality, reliability, and observability architecture, including standards for automated testing, reconciliation, SLA/SLO monitoring, anomaly detection, lineage, metadata, and data contracts.
* Define CI/CD architecture and release-management standards for data platforms, pipelines, and dbt projects, including Git-based workflows, automated quality gates, environment promotion, and deployment patterns using Azure Dev Ops, Git Hub Actions, or equivalent technologies.
* Partner with reporting & analytics, data science, data governance, security, and platform systems & architecture teams to define trusted data access patterns, semantic standards, and self-service capabilities that accelerate insight delivery while maintaining appropriate governance and controls.
* Lead architecture reviews and provide technical direction for security and privacy, identity and access, performance optimization, scalability, availability, disaster recovery, interoperability, and cloud cost management.
* Develop and maintain reference architectures, architecture decision records, technical standards, data contracts, integration…