Data Engineer

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

Requirements:

• 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