Solutions Architect

Mission Pet Health; Birmingham (AL); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Mission Pet Health is hiring a Solutions Architect to own end-to-end design of the data platform that connects hundreds of systems. You will stay hands-on while guiding architecture for ingestion, storage, modeling, serving, and governance, with a focus on AI-assisted tooling and secure data handling.

You’ll lead design reviews, mentor engineers, and translate executive intent into concrete delivery roadmaps, with hybrid work at our Birmingham, AL site.

Qualifications

• 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 comparable columnar engine such as Snowflake, BigQuery, or Databricks).
• Strong production-grade skills in Python, Go, or a comparable backend language.
• Comfort designing event-driven systems (REST, NATS or Kafka, CDC) and operating workloads on Kubernetes.
• Fluency with AI-assisted engineering and tooling, and a disciplined approach to testing and documentation.
• Track record of partnering with executives to translate business problems into durable technical designs.

Responsibilities

• Own the target-state architecture for the data platform end-to-end — ingestion, storage, modeling, serving, and governance.
• Set the direction for the analytical layer on SQL Server, SSAS, and ClickHouse, and for the integration fabric across Azure Data Factory, REST APIs, NATS, and CDC.
• Design and operate event-driven, service-oriented workloads on Kubernetes using Go and Python.
• Lead adoption of agentic tooling for AI-assisted development to accelerate delivery and improve quality.
• Define data contracts, schema standards, and quality SLAs for engineering and analytics teams.
• Embed PII/PHI handling, access control, and auditability into the platform.
• Mentor engineers, lead design reviews, and translate executive intent into delivery roadmaps.

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

If you're using NVDA, press NVDA key + space to enable focus mode to read the slider properly.