Senior Data Engineer

US Salary Range: $100,000 - $140,000

Bonterra exists to propel every doer of good to their peak impact. We measure that impact against our vision to increase the giving rate as a percentage of GDP from 2% to 3% by 2033. We know that this goal is lofty, but we are confident that the right technology and expertise will strengthen trust in the sector, allowing the social good industry to accelerate growth and reach peak impact. Bonterra's differentiated, end-to-end solutions collectively support a unique network of over 20,000 customers, including over 16,000 nonprofit organizations and over 50 percent of Fortune 100 companies. Learn more at bonterratech.com.

Are you an innovative senior data engineer who thrives on building AI-first, cloud-native data platforms? Do you have deep expertise with ubiquitous data tools like Snowflake, DBT, AWS Glue, and a passion for leveraging advanced features like Snowpipe to deliver seamless data integrations? Are you excited to use AI-assisted development tools to accelerate delivery, while creating scalable data solutions that empower nonprofits to make data-driven impact in their communities?

At Bonterra, we are seeking a highly skilled Senior Data Engineer who combines strong data modeling expertise with mastery of the modern data stack. Your work will directly shape our analytics and insights product, ensuring our nonprofit partners have reliable, well-modeled, and AI-enhanced data at their fingertips.

• 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.

• Drive Continuous Innovation: Explore emerging Snowflake capabilities, AI-driven engineering practices, and next-gen BI approaches to keep our platform best-in-class.

Key Must-Haves

• 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.

Additional Requirements

• Primary Stack Expertise:

  • 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.

• Strong Data Modeling background with Medallion architecture, Kimball, or equivalent approaches.

• Solid SQL skills for complex queries, optimizations, and transformations.

• Experience with Airflow, Databricks, or similar orchestration tools.

• Experience with enterprise BI tools such as Looker (with LookML), QuickSight, or Tableau.

• Familiarity with Agile methodologies (Scrum, Kanban).

• Excellent written and verbal communication skills, capable of translating technical concepts clearly.

At Bonterra, we're building AI-powered tools to solve real human challenges-and we want teammates who share that enthusiasm.We value people who will champion AI and bring diverse perspectives from different industries, backgrounds, and cultures. Together, we create AI that breaks down barriers, empowers communities, and delivers better outcomes.

At this time, we are unable to consider candidates who require current or future sponsorship for employment authorization.

____________________________________________________________________________________

At Bonterra, we're innovating with a higher purpose: to increase giving to 3% of US GDP by 2033, creating $573 billion more in global impact every year. At Bonterra, we foster an inclusive, equitable culture where every team member belongs and contributes to meaningful impact. Read more about our values and culture here.

We offer a comprehensive benefits package that supports your health, well-being and growth - explore full details here.

Compensation and benefits for this role apply to full-time employees in the United States and may vary based on local standards, laws and norms. Pay is determined by location, skills, experience, and education, and is one part of Bonterra's total rewards package, which may also include bonuses, incentives, equity, and a comprehensive benefits program.

____________________________________________________________________________________

At Bonterra, we are proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We provide equal employment opportunities without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, veteran status, or any other characteristic protected by law.

If you require a reasonable accommodation during the application process, please submit a request.