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.
The Data Engineer will work as a part of a dedicated data warehousing team to design and implement ETLs for both internal and external data sets. They will also be responsible for collaborating with the Data Science team and other departments within Bonterra to support their work and assist with data modeling.
Responsibilities
Design and implement ETL processes in a cloud environment
Monitor and maintain pipelines for multiple cloud-hosted data warehouses
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:
3+ years of experience building ETL processes
2+ 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 skills
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 Have's:
Experience with dbt (dbt certified is a plus)
Experience utilizing third-party ETL tools (FiveTran, Qlik Replicate, Airbyte)
Experience with Python, PowerShell, or other scripting languages
Experience managing semi-structured data
Experience within an Agile environment
Experience with AWS technologies
Compensation
The range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.
Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and in addition to benefits this role may be eligible for discretionary bonuses/incentives, and equity.
US Base Salary Range: $85,000 - $115,000
Please note that the compensation range and benefits specified in this job posting is applicable to candidates based in the United States. For international applicants, actual salary offers and benefit plans may vary based on the local market compensation standards and will be determined in accordance with regional considerations, including but not limited to applicable laws, cost of living, and industry norms.
We will be accepting applications for this role until 11/2/24
Our Culture: Our team is made up of industry experts and advocates who are 100% committed to supporting the doers of social good. We are currently undergoing an effort to create the vision and values that embody our collective organization and embrace the individuals who make up our community.
Our comprehensive and competitive benefits include:
Generous Flexible Time Off (FTO) Policy
Up to 15 paid company holidays including some commemorating social justice events and self-care
Paid volunteer time
Resources for savings and investments
Paid parental leave
Paid sick leave
Health, vision, dental, and life insurance with additional access to health and wellness programs.
Opportunities to learn, develop, network, and connect
Please note the benefits specified on this page are applicable to full-time employees based in the United States. For international employees, actual benefits may vary based on local standards and regulations and will be determined in accordance with regional considerations, including but not limited to applicable laws and industry norms.
We are committed to being an equal opportunity employer and evaluate qualified applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, diversity of thought and any other characteristic protected by applicable law.