Analytics Engineer

Chapter One seeks a mid-level Analytics Engineer to design, build, and optimize scalable analytical data models in PostgreSQL hosted on Heroku, delivering insights through Sigma. This role reports to the Director of Data and requires a minimum of two years of relevant experience.

Responsibilities

• Design and implement scalable, production-grade analytical data models in a PostgreSQL database.
• Create, maintain, and optimize SQL-based ELT transformations within the Heroku/Postgres environment.
• Translate business and reporting needs into clean, reusable data transformations and views.
• Collaborate with business stakeholders to define metrics and reporting logic.
• Develop and enhance Sigma dashboards and data models to improve clarity, usability, and trust in metrics.
• Improve query performance, indexing strategies, and materialization approaches in Postgres.
• Maintain and improve existing transformation workflows for reliability and maintainability.
• Implement data quality checks, documentation, and testing practices.
• Establish and follow data modeling and naming standards across the analytics layer.
• Investigate and resolve data discrepancies and performance issues.

Requirements

• 2 to 5 years of experience in analytics engineering, data analytics, or a related data role.
• Direct experience working with PostgreSQL in an analytics context.
• Experience supporting business intelligence and reporting workflows.
• Advanced SQL proficiency, including complex joins and common table expressions.
• Advanced SQL proficiency with window functions.
• Advanced SQL proficiency with query performance tuning.
• Advanced SQL proficiency with indexing strategies in Postgres.
• Strong experience building analytical models in PostgreSQL.
• Hands-on experience with Heroku-hosted data environments or similar PaaS platforms.
• Proficiency building dashboards and data models in Sigma or comparable BI tools.
• Solid understanding of dimensional modeling (facts, dimensions, grain, slowly changing dimensions).
• Experience with Git-based version control.

Technologies

• PostgreSQL
• Sigma
• Heroku
• SQL
• Git

Location

Remote

Salary

USD 115,000 - 125,000 per year

Benefits

• 401(k) matching
• Dental insurance
• Health insurance
• Paid time off
• Retirement plan
• Vision insurance

Company Overview

Chapter One centers on literacy as a civil right and aims to significantly improve reading abilities for elementary students. The organization combines technology, targeted support, and corporate volunteerism to advance early literacy and equitable access to education. As it scales nationwide, Chapter One seeks leaders to propel its mission forward.

Performance Metrics

• Quality, reliability, and scalability of Postgres analytical models
• Performance improvements in SQL transformations and dashboard queries
• Adoption and trust of Sigma dashboards by business stakeholders
• Reduction in data discrepancies and metric conflicts
• Completeness and clarity of model and dashboard documentation
• Responsiveness to stakeholder reporting needs
• Stability of Heroku-based data workflows

Equal Opportunity Employer

Chapter One is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, age, protected veteran or disabled status, or genetic information.

Application Process

Important: Applications are only reviewed if submitted through our official application form. Applying directly through Indeed will not be received by our team.