Analytics Engineer

Chapter One is seeking a mid level Analytics Engineer to design, build, and optimize scalable analytical data models in PostgreSQL hosted on Heroku, delivering insights via Sigma and reporting to the Director of Data. This remote role requires 2 or more years of relevant experience and offers a salary range of USD 115,000 to 125,000 per year.

Responsibilities

• Implement scalable, production-grade analytical data models in the PostgreSQL database.
• Build, maintain, and optimize SQL based ELT transformations within the Heroku Postgres environment.
• Translate business and reporting requirements into clean, reusable data transformations and views.
• Partner with business stakeholders to define metrics and reporting logic.
• Develop and enhance Sigma dashboards and data models to ensure clarity, usability, and trust in metrics.
• Optimize 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–5 years of experience in analytics engineering, data analytics, or a related data role.
• Demonstrated experience working directly with PostgreSQL in an analytics context.
• Experience supporting business intelligence and reporting workflows.
• Advanced SQL proficiency, including complex joins and CTEs.
• Advanced SQL proficiency, including window functions.
• Advanced SQL proficiency, including query performance tuning.
• Advanced SQL proficiency, including indexing strategies in Postgres.
• Strong experience building analytical models in PostgreSQL.
• Hands-on experience working in 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

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.

Benefits

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

Work Location

Remote

Salary

USD 115,000 - 125,000 per year

Application Questions

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

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.

Company Overview

Chapter One is driven by the belief that learning to read is a fundamental civil right with the power to transform lives. The organization works to substantially improve the reading abilities of elementary students and to ensure that every child, regardless of background, has the opportunity to confidently read to learn, grow, and thrive. By integrating technology, targeted support, and corporate volunteerism, Chapter One creates meaningful human connections that positively impact early literacy and promote equitable access to education for all young children. As the organization scales its impact nationwide, it seeks leaders to help drive its mission forward.