Bonterra is seeking a Senior Data Engineer to build AI-first, cloud-native data platforms that empower nonprofits to make data-driven impact. The goal is to shape the analytics and insights product, ensuring reliable, well-modeled, and AI-enhanced data for nonprofit partners.
Requirements
- AI Competency: Proven experience applying AI and machine learning techniques to real-world data engineering challenges.
- AI-First Workflow: Daily use of AI-assisted coding tools (Cursor, Copilot, Claude Code, etc.) to improve speed, quality, and maintainability.
- Python Proficiency: Strong expertise in Python for data transformation, automation, and pipeline development.
- DBT/Jinja SQL Expertise: Proven ability to write, extend, and maintain DBT macros using Jinja SQL.
- Snowflake – advanced usage including Snowpipe, streams, tasks, data sharing, and performance tuning.
- DBT – for modular, testable transformations and model orchestration.
- AWS Glue – for scalable ETL/ELT jobs and integration.
Responsibilities
- Lead & Design Scalable Data Models: Spearhead the creation of scalable, efficient, and accurate data models using Medallion architecture, Kimball, or similar approaches, ensuring they meet the diverse reporting needs of nonprofit organizations.
- Snowflake-Centered Engineering: Build advanced solutions leveraging Snowflake features such as Snowpipe for streaming and batch ingestion, tasks, and streams to automate and optimize data pipelines.
- Build & Maintain ELT Pipelines: Develop robust, scalable, reusable, and self-correcting idempotent data pipelines using DBT, AWS Glue, and Snowflake as the primary stack, with orchestration through Airflow or Databricks as needed.
- Develop DBT Macros: Write and maintain DBT macros using Jinja SQL, driving consistency, reusability, and maintainability across transformations.
- Apply AI Daily: Use AI-assisted coding tools (Cursor, Copilot, Claude Code, etc.) as part of your standard workflow to accelerate development, testing, and documentation.
- Strong AI Foundation: Apply machine learning and AI techniques to optimize pipelines, improve data quality, and unlock advanced analytics capabilities.
- Mentor and Guide: Share knowledge, promote best practices in Snowflake and DBT, and champion AI-first engineering across the team.
Other
- At Bonterra, we are seeking a highly skilled Senior Data Engineer who combines strong data modeling expertise with mastery of the modern data stack.
- Excellent written and verbal communication skills, capable of translating technical concepts clearly.
- We value people who will champion AI and bring diverse perspectives from different industries, backgrounds, and cultures.
- At this time, we are unable to consider candidates who require current or future sponsorship for employment authorization.
- We foster an inclusive, equitable culture where every team member belongs and contributes to meaningful impact.
