Analytics Engineer | SQL, PostgreSQL, Sigma
Chapter One
Job description:
Important: Applications are only reviewed if submitted through our official application form. Applying directly through Indeed will NOT be received by our team.
Please copy and paste the link below into your browser to apply:
https://form.asana.com/?k=CqUazsdmPzvsuFEQOvhMNw&d=1204804994771245
Company Overview:
At Chapter One, we believe that learning to read is a fundamental civil right—one with the power to transform lives. Our mission is 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 throughout life.
By integrating technology, targeted support, and corporate volunteerism we create meaningful human connections that have a proven impact on early literacy. This proven approach advances literacy outcomes, actively promoting equitable access to education for all young children. As we continue to scale our impact nationwide, we are seeking leaders to help drive our mission forward.
Job Description:
The Analytics Engineer (Mid-Level) sits at the intersection of data engineering, analytics, and business intelligence. This role is responsible for designing, building, and optimizing scalable analytical data models that power reporting, insights, and decision-making across the organization and reports directly to the Director of Data.
In this environment, the Analytics Engineer will primarily leverage PostgreSQL-based data workflows hosted in Heroku and deliver business-facing insights through Sigma. The ideal candidate combines strong SQL expertise, sound data modeling practices, and a product mindset toward data quality, performance, and usability.
Role Details:
- Job Type: Remote, Full-time, Exempt position
- Location: United States Required, Eastern Time Zone Preferred
- Salary: $115,000- $125,000 per year (based on experience)
- Background Check Required: Must successfully pass a Chapter One background check.
- Reporting Structure: Director of Data
Key Responsibilities:
- Implement scalable, production-grade analytical data models in 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 closely 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.
Required Qualifications
Experience:
- 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.
Technical Skills:
- Advanced SQL proficiency, including:
- Complex joins and CTEs
- Window functions
- Query performance tuning
- 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.
Core Competencies:
- Strong analytical thinking and structured problem solving.
- Ability to translate ambiguous business questions into scalable data solutions.
- High attention to data accuracy, documentation, and maintainability.
- Strong cross-functional communication skills.
- Ownership mindset with the ability to manage multiple priorities.
Preferred Qualifications:
- Experience with Postgres performance tuning at scale.
- Familiarity with Heroku data pipelines, scheduling, or automation patterns.
- Experience implementing data quality tests and monitoring.
- Exposure to semantic layer or metric standardization work.
- Working knowledge of Python or scripting for data tasks.
- Experience supporting product, or education analytics.
Performance Metrics
Success in this role will be measured by:
- 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.
Benefits:
- 401(k) matching
- Dental insurance
- Health insurance
- Paid time off
- Retirement plan
- Vision insurance
Work Location: Remote
Full Time
Salary range:
$100,000 – $150,000