Data Analytics Engineer

About the role

The data warehouse is central to how the business operates, serving multiple stakeholders including executives, finance, operations, and clinic-level providers and staff. The Analytics Engineer will own the SQL side of the house, designing, building, and maintaining the reporting view layer, translating business definitions into SQL logic, and ensuring data quality and performance.

Responsibilities

• Own the reporting schema: Design, build, and maintain the reporting view layer of the SQL Server / Azure SQL data warehouse.
• Translate business definitions into durable SQL logic so metrics are defined once, in one place, and reused everywhere.
• Own the structure of the Analysis Services / Power BI semantic models, ensuring tables, relationships, and core measures are clean and performant.
• Build validation checks and reconciliation queries to catch and resolve discrepancies before stakeholders notice them.
• Write efficient T-SQL, tune queries and views, and decide when to use indexed views, materialized tables, or redesign the schema.
• Maintain clear documentation of the reporting schema, metric definitions, and data lineage.
• Use AI-assisted development tools to draft, review, and debug complex SQL, ensuring correctness before deployment.
• Partner with data engineering on upstream schema changes, with BI developers on model needs, and with business stakeholders to define precise data definitions.

Requirements

• 3+ years working hands-on with SQL Server or Azure SQL in an analytics, data warehousing, or reporting context.
• Expert-level T-SQL skills, including complex joins, window functions, CTEs, and the ability to judge query correctness.
• Real experience with dimensional modeling and reporting-layer design, such as star schemas, conformed dimensions, and slowly changing logic.
• Working knowledge of the Microsoft BI stack, including Analysis Services (tabular), Power BI semantic models, and DAX.
• Comfort using AI-assisted development tools like GitHub Copilot, ChatGPT, or Claude to draft, review, and debug SQL.
• A track record of turning vague business questions into precise data definitions and defending data quality.

Qualifications

• Experience in healthcare, clinical, or other regulated data environments is a plus.
• Version-controlled model development experience (TMDL, Tabular Editor, Git-based workflows) is a plus.
• Power Query / M experience or experience supporting Excel-based analytical consumers of the warehouse is a plus.
• Experience with modern analytics engineering tooling and practices (dbt or similar) is a plus.
• Experience evaluating or adopting AI-assisted BI features (Power BI Copilot, natural language query tools) is a plus.

Skills

• Expert T-SQL skills, including complex joins, window functions, CTEs, and judgment to ensure correctness.
• Dimensional modeling and reporting-layer design expertise.
• Microsoft BI stack proficiency, including Analysis Services, Power BI semantic models, and DAX.
• Comfort using AI-assisted development tools to draft, review, and debug SQL.
• Ability to turn vague business questions into precise data definitions and defend data quality.

Benefits

• Full benefits package including health insurance, vision, dental, life insurance, long and short-term disability, critical illness and accident insurance, and GAP insurance.
• Flexible spending accounts and health savings accounts.
• A generous paid time off policy.
• A 401(k) plan with employer match.
• Access to a financial planner.
• Professional development and continuing education opportunities.

Pay

TBD

Schedule

This is a primarily in-office position with remote work flexibility available.