Analytics Engineer

Abre; Cincinnati (OH); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Flexible PTO and 11 paid holidays

Remote work options

Summer Fridays

Parental leave

Health, Dental, Vision insurance

401(k) with company match

Stock options available

Monthly wellness stipend

Job summary

Abre is hiring an Analytics Engineer to build and scale data models and semantic reporting across the Abre Platform. You will collaborate with Product, Software, and Data teams to deliver standardized analytics and AI-driven reporting tools.

You will design dbt models, implement automated testing, and contribute to dashboards and data governance efforts, with a focus on data quality and scalability.

Qualifications

• 3+ years in Analytics Engineering, Data Engineering, or BI Engineering.
• Expertise in advanced SQL and data modeling (dimensional, Kimball).
• Experience with modern data transformation tools (dbt) and orchestration tools (Dagster, Airflow).
• Experience with Git, version control, and CI/CD pipelines.

Responsibilities

• Translate business logic into scalable, well-documented data models with Product, Software, and Data teams.
• Build and maintain dbt models and semantic layers to standardize metrics across Abre Platform.
• Develop client dashboards and support AI reporting tools.
• Implement automated data validation, testing, and monitoring (dbt tests) for end-to-end data integrity.
• Maintain documentation for data models, definitions, and lineage.
• Collaborate on data warehouse architecture for performance, security, and scalability.
• Guide SQL performance tuning and data modeling patterns.

Skills

Advanced SQL

Data modeling

dbt

ETL/ELT pipelines

Git + CI/CD

Python or R

Dagster / Airflow

Tools

Snowflake

BigQuery

Redshift

dbt

Dagster

Airflow

Tableau/Looker/Power BI

ThoughtSpot

Job description

About Abre

Abre is a leading provider of education technology solutions, dedicated to empowering schools and districts with innovative tools that enhance learning outcomes. Our platform simplifies data management, streamlines workflows, and improves communication between educators, students, and families. At Abre, we are committed to making education more accessible, efficient, and impactful.

About the Role

The Analytics Engineer reports to the VP of Analytics Engineering and is responsible for building, optimizing, and scaling the data transformation and semantic reporting infrastructure across the Abre Platform. Working at the intersection of product, data engineering, and business intelligence, you will transform raw data into scalable, tested data models that power internal analytics, out-of-the-box client dashboards, and AI‑driven reporting tools. Your work will directly enable standardized data solutions and consistent analytics across all customer accounts.

Key Responsibilities

Data Modeling, Analytics Development, & Automation (75%)

• Partner with Product, Software, and Data teams to translate business logic into scalable, well‑documented data models.
• Design, build, and maintain efficient dbt models and semantic layers that standardize metrics across the Abre Platform.
• Develop out-of-the-box client‑facing dashboards and support productized AI reporting tools.
• Implement automated data validation, testing, and monitoring (e.g., dbt tests) to ensure end‑to‑end data integrity.
• Maintain clear documentation for data models, business definitions, and lineage.

Data Warehouse & Architecture Optimization (15%)

• Collaborate with Data Engineers to structure analytics data warehouse assets for performance, security, and scalability.
• Implement best practices for version control, CI/CD, data governance, and data security.
• Provide technical guidance on SQL performance tuning, data modeling patterns, and analytics best practices.

Cross‑Functional Collaboration & Continuous Improvement (10%)

• Work with client‑facing and product teams to refine analytics tooling based on user feedback.
• Identify opportunities to reduce manual data tasks through automation and standard reporting frameworks.
• Stay current with modern data stack trends, tools, and AI‑driven analytics workflows.

Required Skills and Qualifications

• 3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering.
• Expertise in advanced SQL and data modeling techniques (e.g., dimensional modeling, Kimball).
• Strong proficiency with modern data transformation tools (e.g., dbt) and orchestration tools (e.g., Dagster, Airflow).
• Experience with software development workflows, including Git, version control, and CI/CD pipelines.
• Hands‑on experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).
• Familiarity with BI tools (e.g., Tableau, Looker, Power BI) and modern/AI reporting tools (e.g., ThoughtSpot, conversational BI).
• Proficiency in Python or R for data processing and automation.
• Strong problem‑solving skills with a track record of translating complex technical logic into business insights.

Preferred Qualifications

• First‑hand experience working with K‑12 education data or Ed‑Tech platforms.
• Familiarity with education data interoperability standards (e.g., Ed‑Fi, OneRoster).

Why Join Abre?

• Be part of a mission‑driven company making a real impact in education.
• Collaborate with passionate, supportive colleagues who value learning and growth.
• Enjoy flexibility with remote work options and a healthy work‑life balance.
• Contribute to a culture that prioritizes inclusivity, accessibility, and human‑centered design.

Benefits

• Time Off: Flexible PTO and 11 paid company holidays
• Summer Fridays: Early office closures on designated Fridays during summer months to support work‑life balance
• Parental Leave: Paid parental leave
• Insurance: Health, Dental, and Vision insurance; Employer‑paid Basic Life and Short‑Term Disability insurance
• Retirement: 401(k) with company match
• Equity: Stock options available
• Wellness: Monthly employee wellness stipend