Analytics Engineer

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 #J-18808-Ljbffr TrulyHired