Note: The job is a remote job and is open to candidates in USA. Bonterra is focused on increasing the giving rate as a percentage of GDP and supports a unique network of over 20,000 customers. The Data Engineer will design and implement data engineering technologies, collaborate with data scientists, and assist with data modeling within the data warehouse environment.
Responsibilities
- Design and implement ETL processes in a cloud environment
- Design and implement monitoring solutions for ETL processes
- Document datasets for data warehouse consumers
- Serve as a technical resource for consumers of the data warehouse, in particular the Data Science Team and other internal business units
Skills
- 5+ years of experience building ETL processes
- 4+ years of experience with one or more cloud-hosted databases (Snowflake, Synapse Analytics, Redshift or similar)
- Strong understanding of ETL principles and practices
- Excellent SQL and Python skills
- Experience with one or more IaC tools, and integrating infrastructure changes into CI/CD pipelines
- Actively incorporates AI tools (e.g. GitHub Copilot, Claude, ChatGPT) into day-to-day development workflows to improve productivity and code quality
- Data Modeling expertise
- Exemplary organization and time management skills while working both independently and within a team structure
- Ability to break down and translate business needs into development tasks
- Experience with Terraform
- Experience with dbt (dbt certified a plus)
- Familiarity with nonprofit CRM data such as donor management, fundraising, or constituent engagement datasets
- Experience utilizing third-party ETL tools (FiveTran, Qlik Replicate, Airbyte)
- Experience with PowerShell or other scripting languages
- Experience managing semi-structured data
- Experience with Agile methodologies and scrum/scrumban workflows
- Experience with AWS technologies
Benefits
- Bonuses
- Incentives
- Equity
- A comprehensive benefits program
Company Overview
Bonterra is a social good software company. It was founded in 1999, and is headquartered in Austin, Texas, USA, with a workforce of 1001-5000 employees. Its website is https://www.bonterratech.com.