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 giving platform and stellar support enable tens of thousands of nonprofits to raise, recruit, and retain donors, fueling maximum impact and raising the bar on what’s possible for the nonprofit sector. The Role As a Sr. Data Engineer at Bloomerang, you will build the data foundation that powers the next decade of the Bloomerang Giving Platform—BI dashboards, in‑product reports, ML models, and AI agents, including our AI fundraising partner, Penny. Reporting to the Director of AI Product Engineering, you will 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. What You Will Do Design and ship production pipelines on Databricks , using a medallion architecture (bronze → silver → gold / landing → curated → presentation) grounded in Data Vault2.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 metrics are computed on one trustworthy record. Move us toward near‑real‑time data —partner with 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 existing tracing and AI lifecycle tooling (Honeycomb, MLflow, Langfuse) into ETL, catching tenant‑level failures before customers do. Partner with AI and product engineers to ensure the right data is in the right shape at the right time for Penny and the dependent products. Use AI tools (ClaudeCode, Cursor, or similar) daily for pipeline development, schema design, code review, and problem‑solving, propelling not just speed but how you build. Raise the bar on engineering standards —testing, idempotency, documentation, security, and rigorous diligence that keeps data trustworthy at scale. We treat data pipelines as software, mandating code review, SemVer, CI/CD via Databricks Asset Bundles, and the same standards as our application teams. What You Need to Succeed Technical Depth Modern data platform experience —5+ years building production pipelines on a modern lakehouse or warehouse. Databricks+Unity Catalog required; Snowflake, BigQuery, or equivalent acceptable if skills transfer. Identity resolution —experience matching and merging records across systems (entity resolution, dedupe/merge, or golden record work). Strong SQL and strong Python (or Scala) —comfort with PySpark is a plus. Data modeling fluency —knowledge of dimensional and/or DataVault2.0 patterns, able to justify schema decisions and trade‑offs. Production sensibility —real experience operating pipelines in production, including monitoring, alerting, and robust error handling. Streaming and CDC exposure —must not have led the build but must understand the challenges of moving from batch to near‑real‑time. AI‑Native Mindset Hands‑on AI tool usage —daily use of ClaudeCode, Cursor, or similar environments, speaking to where they accelerate or not. Curiosity about the frontier —energized by the pace of AI‑driven change in data engineering. Ownership & Partnership Quality‑first instincts —own outcomes with built‑in observability and testing from day one. Cross‑functional partnership —track record of working well with data scientists, ML engineers, or applied‑AI teams. Security and data residency awareness —respect mandatory mandates surrounding donor data compliance. Nice to Haves But Not Required Transformation framework experience (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 Access to generous health, vision, and dental insurance, plus HealthiestYou, a self‑serve healthcare service with confidential access to qualified doctors 24/7. Time Off Competitive PTO package: 20 PTO days, 3 flex days, 4 optional volunteer days, 12 paid holidays, plus parental leave. 401k 21% 401(k) match. Equipment All needed hardware shipped to your door. Compensation Salary range: $108,400 – $180,700. Must- mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand mand #J-18808-Ljbffr Bloomerang