Solutions Architect

Mission Pet Health; Birmingham (AL); Hybrid; USD 130,000 - 180,000; Full time

Job summary

Mission Pet Health is hiring a Solutions Architect to own the end-to-end design of the platform that ties our systems together while staying hands-on.

The role requires 8+ years across data/ software architecture, deep experience with SQL Server, SSAS, ADF, and production-grade Python/Go code. The position is hybrid in Birmingham, AL with on-site work.

Qualifications

• 8+ years across data engineering, software engineering, or platform architecture.
• Hands-on with T-SQL and SQL Server at scale, SSAS, and Azure Data Factory.
• Production experience with ClickHouse or comparable engines (Snowflake, BigQuery, Databricks).
• Strong backend skills in Python or Go; write robust code, not just diagrams.
• Experience designing event-driven systems (REST, NATS or Kafka, CDC) and running workloads on Kubernetes.
• Fluent with AI-assisted engineering and tooling; knowledge of regulation in multi-site business.
• Proven ability to partner with executives and turn ambiguous problems into durable designs.
• Reside in or relocate to Birmingham, Alabama and work onsite.

Responsibilities

• Own the target-state data platform architecture end-to-end: ingestion, storage, modeling, serving, governance.
• Set direction for analytical layer on SQL Server, SSAS, and ClickHouse; guide Azure Data Factory integration.
• Design and operate event-driven workloads on Kubernetes using Go and Python.
• Drive AI-driven development with agentic tooling to speed up delivery, tests, and docs.
• Define data contracts, schema standards, and quality SLAs for eng and analytics teams.
• Embed PII/PHI handling, access control, and auditability into the platform.
• Mentor engineers, lead design reviews, and translate executive intent into roadmaps.

Skills

Data architecture

T-SQL & SQL Server

Azure Data Factory

ClickHouse / Snowflake

Python / Go

Kubernetes

AI-assisted engineering

Executive collaboration

Tools

ClickHouse

Snowflake

BigQuery

Databricks

Job description

Job Description

At Mission Pet Health, our passion for pets and their families fuels our ambition to build the world’s greatest veterinary organization. We are scaling toward 1,000 hospitals and 20,000+ teammates, and the data behind that growth runs across hundreds of clinical, financial, HR, and marketing systems. We’re hiring a Solutions Architect to own the end-to-end design of the platform that ties it all together — and to stay hands-on while doing it.

Opening Location

This is a hybrid opening in Birmingham, AL.

• Own the target-state architecture for the data platform end-to-end — ingestion, storage, modeling, serving, and governance.
• Set the direction for our analytical layer on SQL Server, SSAS, and ClickHouse, and for our integration fabric across Azure Data Factory, REST APIs, NATS, and CDC.
• Design and operate event-driven, service-oriented workloads on Kubernetes in Go and Python.
• Make AI-driven development a core focus of the team: build and adopt agentic tooling (code-aware agents, retrieval over our own schemas and lineage) so engineers ship faster, with better tests and documentation, and so routine work gets automated rather than repeated.
• Define the data contracts, schema standards, and quality SLAs that engineering and analytics teams build against.
• Embed PII/PHI handling, access control, and auditability into the platform
• Mentor engineers, lead design reviews, and translate executive intent into delivery roadmaps.

Responsibilities And Benefits

• 8+ years across data engineering, software engineering, or platform architecture
• Deep hands-on experience with T-SQL, SQL Server at scale, SSAS, and Azure Data Factory.
• Production experience with ClickHouse (or a comparable columnar engine such as Snowflake, BigQuery, or Databricks).
• Strong production-grade skills in Python, Go, or a comparable backend language — and the discipline to write the code, not just the diagrams.
• Comfort designing event-driven systems (REST, NATS or Kafka, CDC) and operating workloads on Kubernetes.
• Genuine fluency with AI-assisted engineering — coding agents, LLM tooling, retrieval, evals — and a point of view on how to do it responsibly inside a regulated, multi-site business.
• A track record of partnering with executives and turning ambiguous business problems into durable technical designs.
• Reside in or be willing to relocate to Birmingham, Alabama and work onsite.

NICE TO HAVE

• Veterinary, healthcare, or multi-site retail/services experience, particularly with Practice Information Management Systems (PIMS).