Solutions Architect

Ohio State University; United States; On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Retirement plan options

Health insurance

Paid vacation & sick leave

Public Service Loan Forgiveness

Job summary

The Ohio State University invites applications for a Solutions Architect within the Health System Shared Services | Analytics Center of Excellence. You will shape enterprise data architecture, guide data platforms, and align analytics with clinical and operational priorities.

You will partner with analytics teams, data governance, security, and platform groups to deliver scalable, secure, and cost-effective data solutions across the enterprise.

Qualifications

• Bachelor’s degree or equivalent practical experience in a related field.
• 6 years of relevant experience required; 8–12 years preferred in data architecture and analytics.
• Experience designing enterprise data architectures, integration patterns, and scalable data platforms.
• Experience with Azure cloud data services and Databricks or equivalent.
• Strong knowledge of lakehouse architecture, medallion patterns, and data governance.

Responsibilities

• Define enterprise architecture, reference patterns, and technical standards for data ingestion and integration.
• Own and evolve lakehouse architecture using Azure services and Databricks.
• Establish medallion architecture standards across ingestion, standardization, and downstream consumption.
• Define data modeling standards using dbt and dimensional modeling concepts.
• Establish data quality, observability, and SLAs with monitoring and governance.
• Define CI/CD for data platforms using Azure DevOps or GitHub Actions.
• Collaborate with analytics, data governance, security, and platform teams to enable governed self-service data access.
• Lead architecture reviews and guide engineering teams on best practices and patterns.

Skills

SQL

Python

Azure

Databricks

dbt

Lakehouse

Data Modeling

Analytics Architecture

Governance

Communication

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field

Tools

Azure DevOps

GitHub Actions

Delta Lake

Job description

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact [e-mail]. 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 DevOps, GitHub 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 patterns, and architectural roadmaps; guide engineering teams in applying approved patterns consistently.
• Coordinate architecture decisions across medical center and university entities; evaluate emerging technologies, external tools, and strategic partners through proofs of concept and architecture assessments to ensure alignment with enterprise standards and long‑term technology strategy.

Minimum Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field (or equivalent practical experience).
• 6 years of relevant experience required.
• 8-12 years of relevant experience preferred of progressive experience in data architecture, data engineering, data warehousing, analytics engineering, or modern data platform design, including responsibility for technical design decisions and standards.
• Demonstrated experience designing enterprise data architectures, integration patterns, data platforms, and scalable data solutions across multiple systems and business domains.
• Demonstrated experience architecting solutions with Azure cloud data services and Databricks or comparable cloud-based data platform technologies.
• Strong knowledge of lakehouse architecture, including Delta Lake, medallion architecture (Bronze/Silver/Gold), data product design, scalability, resiliency, and workload management.
• Strong understanding of enterprise data modeling and data warehousing principles, including dimensional modeling, star schemas, conformed dimensions, semantic layers, and curated data domains.
• Strong working knowledge of SQL, Python, dbt, or equivalent technologies sufficient to evaluate solution designs, establish engineering patterns, review implementations, and provide technical guidance.
• Experience defining data quality, reliability, observability, and operational standards, including testing, reconciliation, monitoring, validation, SLAs/SLOs, and architecture governance.
• Strong knowledge of data lineage, metadata management, security and privacy architecture, performance optimization, cloud cost management, data governance, and enterprise architecture practices.
• Demonstrated ability to lead architecture discussions, communicate technical tradeoffs to technical and non‑technical stakeholders, influence cross‑functional teams, and establish standards that guide implementation across the enterprise.
• Demonstrated ability to lead architecture discussions, communicate technical tradeoffs to technical and non‑technical stakeholders, influence cross‑functional teams, and establish standards that guide implementation across the enterprise.

Additional Information

Our Comprehensive Employee Benefits Include:

• An array of retirement plan options, each with a generous employer contribution.
• Affordable health insurance options, including dental, vision and prescription coverage that begin on day one.
• Paid vacation and sick leave, including short and long‑term disability and paid parental leave.
• Get the most out of the Public Service Loan Forgiveness program.
• And much more!

Ohio State benefits give you options to take care of what matters most to you — and opportunities to make adjustments as your life and needs change, including:

• Medical, dental and vision coverage, with Ohio State paying a significant portion of the cost.
• Paid time off, including sick and vacation time and 11 holidays.
• State retirement plan or an alternative retirement plan, both with generous employer contributions.

Location: University Hospital - Doan Hall (0089)

Position Type: Regular

Scheduled Hours: 40

Shift: First Shift

Final candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process.

Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions.

The university is an equal opportunity employer, including veterans and disability.

At Ohio State, you’ll find work that inspires you. We offer roles and growth opportunities in countless fields and specialties — including a job that’s right for you.

Ohio State benefits give you options to take care of what matters most to you — and opportunities to make adjustments as your life and needs change, including:

Medical, dental and vision coverage, with Ohio State paying a significant portion of the cost.

Paid time off, including sick and vacation time and 11 holidays.

State retirement plan or an alternative retirement plan, both with generous employer contributions.

As Buckeyes, we accomplish more together. No matter your role, you’ll be part of creating what people need now: pathways to education, research and health care.

Working at Ohio State means you’re part of a team with a strong sense of community and an unwavering commitment to excellence — and, of course, incomparable Buckeye spirit. We bring out the best in people, help each other succeed and learn together. By joining Ohio State, you become part of a top‑20 public university with one of America’s leading academic health centers. We’re a team of dedicated colleagues with access to boundless resources that support you.

Review the Frequently Asked Questions for details on using Workday and submitting your application.