Sr. Data Engineer

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.

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!

The Role

As a Sr. Data Engineer at Bloomerang, you'll build the data foundation that powers the next decade of the Bloomerang Giving Platform-the BI dashboards, in-product reports, ML models, and AI agents-Penny, our AI fundraising partner, among them. Reporting to the Director of AI Product Engineering, you'll join an established team expanding the Unified Data Foundation (UDF): a Databricks lakehouse that brings together CRM, Fundraising, and Volunteer data into a single, well-modeled source of truth-one foundation, many consumers.

This is a hands-on, builder role. Data is the moat; intelligence is the castle. You'll design the pipelines, harden the models, and make the data observable enough that 24,000+ nonprofits can trust what they see. You'll partner daily with our data architects, AI and ML engineers, and platform engineering peers, and you'll bring AI-native habits into how you write, test, and reason about data systems.

What You Will Do

• Design and ship production pipelines on Databricks, using a medallion architecture (bronze → silver → gold / landing → curated → presentation) grounded in Data Vault 2.0 modeling patterns.

• Build and harden the curated and presentation layers -the unified domain model and the product- and reporting-facing views that drive donor lifetime value, retention, lapse risk, and campaign ROI.

• Resolve identity across products. Build and harden the matching that ties a single supporter together across CRM, Fundraising, and Volunteer-so donor lifetime value, retention, and lapse risk are computed on one trustworthy record, not three partial ones.

• Move us toward near-real-time data. Partner with our architects on Change Data Capture (Debezium on Kafka/MSK) so customers see donor activity sooner and analysts, Penny and other AI agents act on fresher signals.

• Integrate trusted external partners through clean, secure, observable pipelines.

• Make data observable. Extend our existing tracing and AI lifecycle tooling (Honeycomb, MLflow, Langfuse) into ETL, so we catch tenant-level failures before customers do.

• Partner with AI and product engineers to make sure the right data is in the right shape at the right time for Penny and the products that depend on her.

• Use AI tools (Claude Code, Cursor, or similar) daily for pipeline development, schema design, code review, and problem-solving. We expect this to fundamentally change how you build, not just speed up what you'd build anyway.

• Raise the bar on engineering standards -testing, idempotency, documentation, security, and the boring rigor that keeps data trustworthy at scale. We treat data pipelines as software - code review, SemVer, CI/CD via Databricks Asset Bundles - and we hold data engineering to the same standards as our application teams.

What You Need to Succeed

Technical Depth

• Modern data platform experience: 5+ years building production data pipelines on a modern lakehouse or warehouse. Databricks w/ Unity Catalog strongly preferred; we'll consider Snowflake, BigQuery, or equivalent if your relevant data engineering skills travel.

• Identity resolution: experience matching and merging records across systems-entity resolution, dedupe/merge, or master-data "golden record" work-especially where there's no shared key to join on.

• Strong SQL and strong Python (or Scala). Comfort with PySpark is a plus.

• Data modeling fluency: working knowledge of dimensional and/or Data Vault 2.0 patterns. You can defend a schema decision and explain the trade-offs.

• Production sensibility: real experience operating pipelines in production-monitoring, alerting, and robust error handling.

• Streaming and CDC exposure: you don't have to have led that build, but you should know what's hard about moving from batch to near-real-time.

AI-Native Mindset

• Hands-on AI tool usage: you already use Claude Code, Cursor, or similar AI development environments as a daily part of how you build. You can speak to where they accelerate your work and where they don't.

• Curiosity about the frontier: you're energized by the pace of AI-driven change in how software-and data-gets built, and you bring that energy into your team.

Ownership & Partnership

• Quality-first instincts: you don't just write pipelines, you own outcomes. You build observability and testing within from day one.

• Cross-functional partnership: a track record of working well with data scientists, ML engineers, or applied-AI teams. We have a Penny to feed.

• Security and data residency awareness: our customers trust us with their donors' data. You take that seriously.

Nice to Haves But Not Required

• Transformation framework experience generally (dbt, PySpark, etc.).
• AWS (S3, IAM, networking).
• Experience with observability tools like Honeycomb, OpenTelemetry, or MLflow.
• Multi-tenant SaaS data experience.
• Background in nonprofit, fundraising, or CRM data.

Benefits

Health + Wellness

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.

Time Off

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. More is more!

401k

You'll receive a 401k match to help invest in your future.

Equipment

Everything you need to be successful, shipped right to your door. You got this. We got you.

Compensation

The salary range for this position is $108,400 - $180,700. You may also be eligible for a discretionary bonus. Actual compensation within the range will be dependent on your skills, experience, qualifications, and location, as well as applicable employment laws

Location

This is a permanent, full-time, fully remote position (within the U.S. and select Canadian Provinces only). Employees living in Indianapolis, IN are welcome to work from our company headquarters. We do not offer Visa sponsorship or relocation assistance at this time.

Accommodations

Applicants who require accommodations may contact [email protected] to request an accommodation in completing an application.

Bloomerang is an Equal Opportunity Employer. Individuals seeking employment at Bloomerang are considered without regard to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation.