Data Engineer

About this role

<p>At Bloomerang, we believe change happens on purpose. We champion the power and potential of nonprofits, igniting next-level impact with the team and technology built for purpose. Our powerful giving platform and stellar support enable tens of thousands of nonprofits to raise more, recruit more, and retain more, fueling maximum impact and raising the bar on what’s possible for the nonprofit sector. That's why, even as the nonprofit sector sees declines in giving, Bloomerang customers raise more year over year.</p> <p>We're also in the business of creating thriving employees. Join a mission-driven culture built on our core values of Simplify, Care and Act. We know our people are the key to our success, and we're proud to be home to some of the most innovative and skilled individuals in the workforce today. Come feel invigorated and unstoppable with us!</p> <p><strong> </strong></p> <p><strong>The Role</strong></p> <p class="p1">As a Data Engineer on the Finance team, you’ll lead the end-to-end design, implementation, and maintenance of Bloomerang’s enterprise data warehouse. This role blends traditional data engineering with data warehouse development, giving you ownership over how the organization’s internal data is structured, governed, and delivered. You’ll drive the migration and refactor of our current data warehouse from Google BigQuery to Databricks, powering all internal analytics across Bloomerang. You’ll also establish the data warehouse standards and guidelines that shape how every team builds on top of our data platform going forward. You’ll partner with cross-functional stakeholders across Finance, Sales, Marketing, Customer Success, and People to turn business questions into reliable, well-modeled data.</p> <p><strong> </strong></p> <p><strong>What You Will Do</strong></p> <ul> <li class="p1">Lead the end-to-end design, development, and implementation of enterprise data warehouse solutions supporting corporate analytics</li> <li class="p1">Own the migration and refactor of Bloomerang’s data warehouse from Google BigQuery to Databricks, supporting all internal analytics use cases</li> <li class="p1">Establish and maintain data warehouse standards, guidelines, and best practices across the organization</li> <li class="p1">Design and build scalable ETL and ELT pipelines that ingest, transform, and integrate data from internal systems, including MySQL, PostgreSQL, Salesforce, and more</li> <li class="p1">Work closely with analytics engineers to develop dimensional data models and enterprise data architecture that support reporting and business intelligence needs across the company</li> <li class="p1">Partner with cross-functional stakeholders to translate business requirements into scalable, well-governed data solutions</li> <li class="p1">Build automated data quality monitoring, validation, and governance processes to ensure accuracy and reliability of enterprise data</li> <li class="p1">Optimize data warehouse performance, reliability, and cost across cloud environments</li> <li class="p1">Create and maintain documentation for data architecture, pipelines, and data warehouse standards</li> <li class="p1">Mentor team members and collaborate with engineering on data warehouse best practices</li> </ul> <p><strong> </strong></p> <p><strong>What You Need to Succeed</strong></p> <ul> <li class="p1">3-5 years of experience in data engineering or data warehouse development, ideally with experience leading enterprise data warehouse implementations</li> <li class="p1">Hands-on experience migrating or working across modern cloud data warehouse platforms (e.g., BigQuery, Snowflake, Redshift); Databricks experience preferred</li> <li class="p1">Expert-level SQL skills and strong data modeling capabilities for complex querying, transformation, and enterprise reporting</li> <li class="p1">Experience with modern ETL and ELT tools and practices</li> <li class="p1">Strong understanding of dimensional modeling, data warehouse design patterns (star and snowflake schema), and enterprise data architecture</li> <li class="p1">Experience establishing data governance, standards, and best practices for agrowing organization</li> <li class="p1">Proficiency in Python or similar programming languages for data pipelinedevelopment</li> <li class="p1">Experience integrating with core business systems and APIs, including Salesforce,MySQL, and PostgreSQL</li> <li class="p1">Familiarity with cloud platforms (preferably Google Cloud Platform) and moderndata stack tools</li> <li class="p1">Experience with version control, CI/CD practices, and collaborative developmentworkflows</li> <li class="p1">Strong analytical and problem-solving skills with close attention to data qualityand accuracy</li> <li class="p1">Excellent communication skills and the ability to lead cross-functional collaboration in a fast-paced, growing organization</li> <li class="p1">Experience working in a SaaS or technology company is a plus, but not required</li> </ul> <p> </p> <p> </p> <p><strong>Benefits</strong></p> <p><strong>Health + Wellness</strong><br>You’ll have access to generous health, vision, and…