Solutions Architect - Hybrid

Mission Pet Health; Birmingham (AL); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Hybrid work in Birmingham

onsite in Birmingham

Job summary

Mission Pet Health is hiring a Solutions Architect to own the end-to-end design of the data platform tying together hundreds of systems across clinical, financial, HR, and marketing domains. This hybrid Birmingham, AL role requires hands-on leadership to drive architecture and governance while mentoring engineers.

The candidate will focus on SQL Server, SSAS, ClickHouse, Azure Data Factory, and service-oriented workloads on Kubernetes.

Qualifications

• 8+ years across data engineering, software engineering, or platform architecture.
• Deep hands-on experience with SQL Server, SSAS, and Azure Data Factory.
• Experience with ClickHouse or comparable engines; production-grade Python/Go.
• Designing event-driven, service-oriented workloads on Kubernetes.
• Genuine fluency with AI-assisted engineering and governance in multi-site setups.
• Proven track record partnering with executives to translate business needs into durable designs.
• Residence or willingness to relocate to Birmingham, Alabama, onsite.

Responsibilities

• Own end-to-end target-state architecture for the data platform, including ingestion, storage, modeling, serving, and governance.
• Guide analytical layer on SQL Server, SSAS, ClickHouse, and integration fabric across Azure Data Factory, REST APIs, NATS, and CDC.
• Design and operate event-driven workloads on Kubernetes using Go and Python.
• Promote AI-driven development with agentic tooling to improve speed, tests, and documentation.
• Define data contracts, schema standards, and quality SLAs for engineering and analytics teams.
• Embed PII/PHI handling, access control, and auditability; mentor engineers and translate executive intent into roadmaps.

Skills

Executive collaboration

Architecture design

Mentoring

Cross-functional leadership

Regulated environment

Tools

T-SQL

SQL Server

SSAS

Azure Data Factory

ClickHouse

Snowflake

BigQuery

Databricks

Python

Go

Kubernetes

REST APIs

NATS

Kafka

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.

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.

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. This is a hybrid opening in Birmingham, AL.

Key Responsibilities

• 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

REQUIRED EXPERIENCE

• 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).