Senior Data Engineer

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 Senior Data Engineer will work as a part of a dedicated data warehousing team to design and implement the core technologies of which it is comprised. 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
• 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
• Data Modeling expertise
• 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 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:$115,000 - $130,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/2024
Our Culture: At Bonterra, we're innovating with a higher purpose: to increase giving to 3% of US GDP by 2033, creating $573 billion more in global impact every year. To achieve our vision, we cultivate an inclusive environment where diversity is embraced and every team member feels empowered to contribute. Innovation, curiosity, and a commitment to equity guide our work. We foster a culture of belonging, ensuring that every individual is valued, respected, and given the tools to succeed. Together, we are dedicated to making a positive impact in the world.
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.