Data Analytics Engineer

Heritage Vet Partners; Overland Park (KS); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health insurance

Dental and vision benefits

401(k) with company match

Paid time off

Job summary

Heritage Vet Partners in Overland Park, KS seeks an Analytics Engineer to own the curated SQL reporting layer of our data warehouse. You will design and maintain the views, translate business definitions into durable logic, and ensure data quality across executives, finance, and clinics.

You will work with SQL Server/Azure SQL, T-SQL, and dimensional models, building semantic models in Analysis Services and Power BI. AI-assisted tools speed development, but you own correctness and data quality.

Qualifications

• 3+ years hands-on with SQL Server or Azure SQL in analytics, data warehousing, or reporting contexts.
• Expert-level T-SQL with complex joins, window functions, and CTEs.
• Experience with dimensional modeling and reporting-layer design (star schemas, conformed dimensions).
• Working knowledge of Microsoft BI stack: Analysis Services, Power BI semantic models, and DAX basics.
• Comfort using AI-assisted development tools to draft, review, and debug SQL while ensuring correctness.

Responsibilities

• Design, build, and maintain the reporting view layer of our data warehouse (SQL Server / Azure SQL).
• Translate business definitions into durable SQL logic for consistent metrics.
• Own the Analysis Services / Power BI semantic models and their measures.
• Build validation checks and reconcile data to ensure trustworthiness for stakeholders.
• Write efficient T-SQL and optimize views, with guidance on when to index or redesign objects.
• Maintain documentation and data lineage for the warehouse.

Skills

SQL Server / Azure SQL

T-SQL

Dimensional modeling

Data definitions

Documentation

AI-assisted development

Data quality

SQL performance

Tools

Analysis Services

Power BI

DAX

Job description

LOCATION: OVERLAND PARK, KS or OMAHA, NE

Company Overview

Heritage Vet Partners (HVP) is the nation’s leading veterinary partnership specializing in mixed/large animal practices. We believe there is great value in the legacy, customer relationships, brand, culture, and team that veterinarians have built. Our goal is to provide services and support around the foundation veterinarians have developed. Most importantly, we believe that together we can best meet the changing needs of the customers and industries that we serve. We are very excited about the future of mixed and large animal practice and want our partnering practices and veterinarians to enjoy the success of Heritage Vet Partners. HVP currently has offices in Omaha, NE, Overland Park, KS and West Point, NE, as well as clinics/locations in 14 states! Learn more on our website!

About The Role

Our data warehouse sits at the center of how the business runs: it is used by stakeholders ranging from executives to finance to operations to clinic level providers and staff. We have data architecture/engineering to keep the pipelines flowing and report builders turning models into insight. What we need now is the person who owns the layer in between.

As our Analytics Engineer, you will own the SQL side of the house: the curated schema of reporting views, business logic, and semantic model foundations that transform raw warehouse tables into clean, consistent, trustworthy data products. When a metric shows up on an executive dashboard or inside one of our applications, your work is the reason everyone trusts the number.

This is a hands‑on builder role for someone who thinks in data models, writes SQL fluently and defensively, and takes pride in being the person who makes messy source data make sense. You'll also lean on AI tools as part of how you build using coding assistants to move faster on SQL and documentation without ever outsourcing your judgment about what's correct. You will be the connective tissue between the engineers who land the data and the analysts who present it, and you will have real ownership of how that middle layer is designed.

What You’ll Own

• The reporting schema: Design, build, and maintain the reporting view layer of our SQL Server / Azure SQL data warehouse: the governed, documented views that serve as the single contract between raw data and everything downstream.
• Business logic in SQL: Translate business definitions into durable SQL logic so metrics are defined once, in one place, and reused everywhere.
• Semantic model foundations: Own the structure of our Analysis Services / Power BI semantic models: tables, relationships, and core measures, so report builders can work from a clean, performant model rather than reinventing logic per report.
• Data quality and reconciliation: Build validation checks and reconciliation queries that catch problems before stakeholders do. Investigate discrepancies, trace them to root cause, and fix them at the right layer.
• Performance of the reporting layer: Write efficient T‑SQL, tune the queries and views that power reporting workloads, and know when a view should become an indexed view, a materialized table, or a redesign.
• Documentation and lineage: Maintain clear documentation of the reporting schema, metric definitions, and data lineage so the warehouse is understandable, not tribal knowledge.
• AI-assisted development: Use AI coding assistants (e.g., GitHub Copilot, ChatGPT, Claude) to accelerate T‑SQL development, documentation, and code review while retaining full ownership and accountability for the correctness of what goes live into production.
• Cross‑functional partnership: Partner with data engineering on upstream schema changes, with BI developers on model needs, and with business stakeholders to turn ambiguous asks into concrete, correct data definitions.

What You Bring

• 3+ years working hands‑on with SQL Server or Azure SQL in an analytics, data warehousing, or reporting context
• Expert‑level T‑SQL: complex joins, window functions, CTEs, and the judgment to know when a query is correct versus merely returning rows
• Real experience with dimensional modeling and reporting‑layer design (star schemas, conformed dimensions, slowly changing logic), and opinions about when to break the rules
• Working knowledge of the Microsoft BI stack: Analysis Services (tabular), Power BI semantic models, and enough DAX to design models that measure‑writers can build on
• Comfort using AI‑assisted development tools (e.g., GitHub Copilot, ChatGPT, Claude) to draft, review, and debug complex SQL with the judgment to validate AI‑generated logic before it goes into production, rather than accepting output at face value
• A track record of turning vague business questions into precise data definitions, and of defending data quality when it would be easier to ship the number
• Strong written communication: your documentation, view comments, and metric definitions will be read by engineers and executives alike

NICE TO HAVE

• Experience in healthcare, clinical, or other regulated data environments
• Exposure to version‑controlled model development (TMDL, Tabular Editor, Git‑based workflows)
• Power Query / M experience, or experience supporting Excel‑based analytical consumers of the warehouse
• Familiarity with modern analytics engineering tooling and practices (dbt or similar), even if our stack is SQL‑native
• Experience evaluating or adopting AI‑assisted BI features (e.g., Power BI Copilot, natural language query tools) in a reporting environment

WHY THIS ROLE

You will not be one of fifty analytics engineers maintaining someone else’s decisions. The reporting layer is yours to design, improve, and be known for. Your work will be visible in every board deck, every operational dashboard, and every application screen that shows a number, and the people who depend on it will know exactly who made it trustworthy.

Benefits

HVP offers a full benefits package, including various health insurance plan options, vision, dental, and life insurance, long and short term disability, critical illness and accident insurance, and GAP insurance. We also offer Flexible Spending Accounts as well as Health Savings Accounts. A generous paid time off policy allows our employees the flexibility they need for work/life balance. HVP invests in your future by offering a company sponsored 401k plan with employer match, along with access to a financial planner!

Along with the above, other perks include the option for career advancement, professional development, and continuing education. This is a primarily in‑office position, but with the flexibility for remote work if needed!

STATEMENT

All applicants are considered for all positions without regard to race, religion, color, sex, gender, sexual orientation, pregnancy, age, national origin, ancestry, physical/mental disability, medical condition, military/veteran status, genetic information, marital status, ethnicity, citizenship or immigration status, or any other protected classification, in accordance with applicable federal, state, and local laws. By completing this application, you are seeking to join a team of hardworking professionals dedicated to consistently delivering outstanding service to our customers and contributing to the financial success of the organization, its clients, and its employees. Equal access to programs, services, and employment is available to all qualified persons. Those applicants requiring an accommodation to complete the application and/or interview process should contact a management representative.

JOB CODE: 85 - MSO