Analytics Engineer

TrulyHired; Cincinnati (OH); Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Flexible PTO

11 paid company holidays

Parental leave

Health, Dental, Vision insurance

401(k) with company match

Equity options

Monthly wellness stipend

Job summary

Abre is seeking an Analytics Engineer to build, optimize, and scale the data transformation and semantic reporting infrastructure across the Abre Platform. You will craft scalable data models, dashboards, and AI-driven reporting tools that power analytics for customers and internal teams.

This role sits at the intersection of product, data engineering, and business intelligence, requiring collaboration across Produkt, Software, and Data teams to standardize metrics and ensure data quality.

Qualifications

• 3+ years in Analytics Engineering, Data Engineering, or BI Engineering.

Responsibilities

• Develop and maintain scalable dbt models and semantic layers to standardize metrics across the Abre Platform.
• Build out-of-the-box client dashboards and support AI reporting tools.
• Implement automated data validation, testing, and monitoring to ensure data integrity.

Skills

Advanced SQL

Data modeling

Python or R

CI/CD practices

Tools

dbt

Dagster

Airflow

Snowflake

BigQuery

Redshift

Tableau

Looker

Power BI

ThoughtSpot

Python

Job description

Analytics Engineer Full Description

Location: Remote (U.S.-based applicants only)

Headquarters: Cincinnati, Ohio

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