Data Analytics Engineer

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

Benefits offered by this job

Health insurance

Vision & dental coverage

401k with employer match

Paid time off

Job summary

Heritage Vet Partners is seeking an Analytics Engineer to own the SQL layer of the data warehouse, defining curated reporting views and semantic models. You will transform raw data into trusted data products used across executives, finance, and operations.

You’ll collaborate with data engineers and analysts, apply AI-assisted tools to accelerate development, and ensure data quality and governance across reporting surfaces. This is an office-centric role with flexibility for remote work as needed.

Qualifications

• 3+ years working hands-on with SQL Server or Azure SQL in analytics, data warehousing, or reporting.
• Expert-level T-SQL: complex joins, window functions, CTEs, and correct data definitions.
• Experience with dimensional modeling and reporting-layer design (star schemas, conformed dims).
• MS BI stack knowledge: Analysis Services (tabular), Power BI semantic models, and relevant DAX.
• Comfort using AI-assisted development tools to draft, review, and debug SQL for production.
• Track record turning vague business questions into precise data definitions and ensuring data quality.
• Strong written communication read by engineers and executives.

Responsibilities

• Design, build, and maintain the reporting view layer of the data warehouse.
• Translate business definitions into durable SQL logic for metrics.
• Own the semantic model foundations in SSAS/Power BI for efficient reporting.
• Create validation checks and data reconciliation queries.
• Tune performance of the reporting layer; decide when views become indexed or tables materialize.
• Document reporting schema, metrics, and data lineage.
• Use AI coding assistants to accelerate development while owning correctness.
• Collaborate with data engineering, BI developers, and stakeholders.

Skills

SQL Server/Azure SQL experience

T-SQL expert

Dimensional modeling

Power BI/Analysis Services

AI-assisted development tools

Data quality & governance

Strong written communication

Tools

Power BI

Analysis Services

DAX

Job description

LOCATION: OVERLAND PARK, KS or OMAHA, NE

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!

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 ние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