Data Engineer

Bonterra•Remote-US-Texas, TX

13d•$80,000 - $110,000

About The Position

The Data Engineer will work as a part of a dedicated data warehousing team to design and implement core data engineering technologies. They will also be responsible for collaborating with data scientists and other teams within Bonterra to support workloads within the data warehouse environment, and assist with data modeling.

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

Nice To Haves

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 metholodogies and scrum/scrumban workflows
Experience with AWS technologies

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