← Back to jobsJob ID col-cmv8hbmgr08mioz01nvqkw7fn

Heritage Vet PartnersPosted 30+ days ago

Data Analytics Engineer

Full-time
On-site
3+ years
Competitive
Posted 30+ days ago

Heritage Vet Partners is hiring a Data Analytics Engineer to own the SQL reporting layer between its data warehouse and downstream analytics. The role builds and maintains trusted reporting views, business logic, semantic model foundations, data quality checks, and documentation, while partnering with engineering, BI, and business stakeholders.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • 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
  • Translate business definitions into durable SQL logic so metrics are defined once, in one place, and reused everywhere
  • 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
  • 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
  • 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
  • Maintain clear documentation of the reporting schema, metric definitions, and data lineage so the warehouse is understandable, not tribal knowledge
  • 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
  • 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

Qualifications

  • 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

Preferred

  • 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
  • Healthcare Data Experience
  • Clinical Data Experience
  • Natural Language Query Tools

Required skills

SQL ServerAzure SQLT-SQLDimensional ModelingAnalysis ServicesPower BIDAXData Quality and ReconciliationGitHub CopilotChatGPTClaudeHealthcare Data

Full job description

Heritage Vet Partners is hiring a Data Analytics Engineer to own the SQL reporting layer between its data warehouse and downstream analytics. The role builds and maintains trusted reporting views, business logic, semantic model foundations, data quality checks, and documentation, while partnering with engineering, BI, and business stakeholders.

Responsibilities

  • 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
  • Translate business definitions into durable SQL logic so metrics are defined once, in one place, and reused everywhere
  • 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
  • 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
  • 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
  • Maintain clear documentation of the reporting schema, metric definitions, and data lineage so the warehouse is understandable, not tribal knowledge
  • 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
  • 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

Preferred

  • 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
  • Healthcare Data Experience
  • Clinical Data Experience
  • Regulated Data Environments
  • Version-Controlled Model Development
  • TMDL
  • Tabular Editor
  • Git-Based Workflows
  • Power Query
  • Power Query M
  • Excel Analytics Support
  • Analytics Engineering
  • Analytics Engineering Tooling
  • dbt
  • SQL
  • AI-Assisted BI
  • Power BI Copilot
  • Natural Language Query Tools
  • Reporting Analytics

Benefits

  • Various health insurance plan options
  • Vision insurance
  • Dental insurance
  • Life insurance
  • Long and short term disability insurance
  • Critical illness and accident insurance
  • GAP insurance
  • Flexible Spending Accounts
  • Health Savings Accounts
  • A generous paid time off policy
  • A company sponsored 401k plan with employer match
  • Access to a financial planner
  • The option for career advancement
  • Professional development
  • Continuing education
  • Flexibility for remote work if needed

Company

  • Veterinary partnership for mixed and large animal practices.
  • West Point, Nebraska, USA
  • https://heritagevetpartners.com/
  • 51-200 employees

Qualifications

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

Required skills

  • SQL Server, Azure SQL, T-SQL, Dimensional Modeling, Analysis Services, Power BI, DAX, Data Quality and Reconciliation, GitHub Copilot, ChatGPT, Claude, Healthcare Data

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 13, 2026

Work mode

On-site

Job source

Ethic Leaf recruiter

Company

Heritage Vet Partners

Information Technology & AI

Veterinary partnership for mixed and large animal practices.

Similar jobs

Matched on role, skills and location · live jobs only

See more Analytics Engineer jobs in Overland Park

Energy

1d ago

New

Sr Data & Analytics Engineer

Full-timeRemoteUnited StatesCompetitive

Baltimore Aircoil Company (BAC) is hiring a Senior Data & Analytics Engineer to support and modernize enterprise data and analytics capabilities using Microsoft Fabric and Power BI.

Why similarSame roleDAXRemote

MSRcosmos LLC

1d ago

New

Business Intelligence/Data Analytics Developer

Full-timeRemoteUnited StatesCompetitive

MSRcosmos LLC is hiring a Business Intelligence/Data Analytics Developer to modernize healthcare data warehouse reporting by converting SAP BusinessObjects reports and universes to Power BI.

Why similarSame roleDAXRemote

Amazon

1d ago

New

Data Engineer, Central InfraOps Analytics Team

Full-timeOn-siteSeattle, WA$101K – $160K/yr

Amazon Data Services, Inc. is hiring a Data Engineer to support data-driven decision-making for AWS Data Center Infrastructure Operations.

Why similarSame role

Get new Analytics Engineer jobs in Overland Park by email

Create job alert

Data Analytics Engineer

Heritage Vet Partners · Competitive

Apply via Ethic Leaf