Analytics Engineer

Esperta Health•Nashville, TN

About The Position

We are hiring a United States based Analytics Engineer to support reporting, ad-hoc analysis, and analytics development across the organization while helping evolve our data platform over time. This role sits between data engineering and the business. You’ll own day-to-day analytics needs—Power BI dashboards, ad-hoc reporting, SQL development—while growing into more advanced responsibilities such as gold-layer data modeling and, eventually, advanced analytics and machine learning use cases. Ad-hoc analysis and reporting will remain a core responsibility of this role as the analytics function matures. You’ll work closely with a Senior Solutions Engineer who focuses on data ingestion and integrations, allowing you to focus on transforming data into insight and impact. Why This Role Matters This role is central to how data is used across the company. You’ll enable faster decision-making today while helping build a more scalable analytics foundation for the future. You’ll have visibility, ownership, and a clear growth path as our data capabilities mature.

Requirements

Strong expertise in SQL development with a knack for modular design
Proven ability working with large and complex datasets
Hands on experience building reports or dashboards (Power BI preferred)
Experience handling ad-hoc analysis and evolving business questions
Experience and understanding of dimensional modeling
Ability to communicate clearly with non-technical stakeholders
Curiosity and motivation to grow technically

Nice To Haves

2+ years of SQL development experience
Experience with Databricks, Snowflake, or other cloud-based data platforms
Familiarity with analytics engineering concepts
Familiarity with version control & CI/CD tools (GitHub, Gitlab, etc.)
Exposure to healthcare, EMR, or regulated data environments
Interest in machine learning or advanced analytics (not required)

Responsibilities

Own ad-hoc reporting and analysis for operations, finance, and leadership
Build and maintain Power BI dashboards and reports
Translate ambiguous business questions into clear analytical outputs
Partner with stakeholders to define and refine KPIs and metrics
Ensure reporting is accurate, performant, and trusted
Write high-quality SQL to support reporting and analytics
Build and improve analytics-ready (gold-layer) datasets
Contribute to dimensional and fact-based data models
Help improve consistency, usability, and documentation of core datasets
Gradually take on more responsibility in data modeling and analytics engineering
Collaborate on improving analytics architecture and best practices
Explore advanced analytics or ML use cases over time (as interest and readiness allow)