US Salary: $80,000 - $110,000
About the RoleThe 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.
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
Preferred:- 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
At this time, we are unable to consider candidates who require current or future sponsorship for employment authorization.
Compensation & BenefitsWe 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.
