Data Engineer

Summary

Join Bloomerang as a Data Engineer and build and maintain the data infrastructure powering AI-driven insights across our nonprofit software platform. You will design and build scalable data pipelines, develop comprehensive data models, and integrate with off-the-shelf LLMs and AI services. Collaborate with product teams to identify data requirements and deliver AI-powered features. Maintain data infrastructure, create automated data quality processes, and develop documentation. Translate business requirements into technical data solutions and optimize data processing workflows. This role requires strong proficiency in Google BigQuery and SQL, experience with ETL/ELT platforms, and AI service integration.

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

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 across the organization to identify data requirements and deliver solutions that support AI-powered features
• Build and maintain data infrastructure that facilitates 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
• Work with stakeholders to translate business requirements into technical data solutions that leverage AI capabilities
• Optimize data processing workflows for performance and cost-effectiveness in cloud environments

Preferred Qualifications

Experience working in SaaS or technology companies, preferably with exposure to AI/ML initiatives

Benefits

• You’ll have access to generous health, vision, and dental insurance options as well as HealthiestYou, a healthcare service that offers convenient, confidential access to quality doctors 24/7, anytime, anywhere
• You’ll get a competitive PTO package that includes 20 PTO days, 3 flex days, 4 optional volunteer Days, 12 paid holidays, as well as paid parental leave
• You’ll receive a 401k match to help invest in your future
• Everything you need to be successful, shipped right to your door
• The salary range for this position is: $92,000 - $138,000. You may also be eligible for a discretionary bonus