Analytics Engineer

Analytics Engineer Full Description

Location:

Remote (U.S.

-based applicants only)

Headquarters:
Cincinnati, Ohio

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.

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.

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

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

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

• 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, Big Query, Redshift).
• Familiarity with BI tools (e.g., Tableau, Looker, Power BI) and modern/AI reporting tools (e.g., Thought Spot, 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.

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

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

• 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