Data Engineer

Salary: [Not Specified] Location Type: [Not Specified] Employment Type: [Not Specified]

Position Overview

Bloomerang is a leading provider of fundraising and donor CRM software, empowering tens of thousands of nonprofits to raise more funds and achieve their missions. We are committed to creating a world-class experience for our clients and a thriving environment for our employees, guided by our core values of Simplify, Care, and Act.

As a Data Engineer, you will be instrumental in developing and maintaining the data infrastructure that underpins our AI-driven insights. You will design and implement robust data pipelines to normalize and integrate data from various products, enabling us to monitor the health metrics of the nonprofit organizations we serve. This role blends traditional data engineering with cutting-edge AI integration, utilizing off-the-shelf LLMs and AI services to build intelligent features that enhance nonprofit operations and fundraising efforts. You will collaborate with cross-functional teams to support project initiatives and ensure our data infrastructure scales with our rapid growth.

Responsibilities

• Design and build scalable data pipelines using Google BigQuery to normalize and integrate data across multiple product lines.
• Develop comprehensive data models that capture nonprofit organization health metrics and performance indicators.
• Integrate with off-the-shelf LLMs and AI services to build intelligent data processing and analysis capabilities.
• Collaborate with product teams to identify data requirements and deliver solutions supporting AI-powered features.
• Build and maintain data infrastructure facilitating seamless integrations with various databases (MySQL, PostgreSQL), platforms, and APIs.
• Create automated data quality monitoring and validation processes to ensure accuracy and reliability of health metrics.
• Develop and maintain documentation for data architecture, pipelines, and AI integration processes.
• Translate business requirements into technical data solutions leveraging AI capabilities.
• Optimize data processing workflows for performance and cost-effectiveness in cloud environments.

Requirements

• 3-5 years of experience in data engineering with strong proficiency in Google BigQuery (experience with Snowflake or Redshift is also valuable).
• Expert-level SQL skills and strong data analysis capabilities for complex querying, data transformation, and insight generation.
• Experience with modern ETL/ELT platforms such as Fivetran, Stitch, Airbyte, or similar data integration tools.
• Experience integrating with and leveraging off-the-shelf AI services and LLMs (OpenAI, Anthropic, AWS Bedrock, Google Vertex AI, etc.).
• Proficiency in Python or similar programming languages for data processing and AI service integration.
• Strong understanding of data modeling, ETL processes, and data pipeline architecture.
• Experience with API integrations and working with various data sources and formats.
• Knowledge of data governance, security, and access control best practices.
• Familiarity with cloud platforms (preferably Google Cloud Platform) and modern data stack tools.
• Experience with version control, CI/CD practices, and collaborative development workflows.
• Strong analytical and problem-solving skills with attention to data quality and accuracy.
• Excellent communication skills and ability to work effectively with cross-functional teams in a fast-paced, growing organization.
• Experience working in SaaS or technology companies.

Company Information

Bloomerang combines the best tools, resources, and people to provide a world-class experience for tens of thousands of nonprofits, allowing them to raise more money and do more good in the world. Our powerful software and stellar customer service have made us one of the highest rated fundraising/donor CRMs on the market.

In addition to creating thriving nonprofits, we’re also in the business of creating thriving employees. At Bloomerang, you’ll be a part of a mission-driven culture built on the core values of Simplify, Care, and Act. We know the key to our success is our people, and we’re proud to be home to some of the most innovative and skilled employees in the workforce today.