This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

We are looking for a highly technical, detail-oriented Data Engineer to serve as the technical engine and quality-control specialist for our data operations. Reporting directly to the Director of Data (who also serves as the Lead Architect), you will execute the end-to-end development of our ETL/ELT pipelines under their strategic direction.

• Execute the full data lifecycle—Extract, Transform, Load—utilizing industry-standard tools like Fivetran to automate ingestion.
• Help manage and scale complex data workflows using tools like Apache Airflow, ensuring task dependencies are met and pipelines run with 100% reliability.
• Perform rigorous data cleansing and transformation within the SQL layer to turn raw, messy data into "Gold-standard" KPI-ready logic.
• Function as the primary monitor for the data environment. Execute automated monitoring protocols to identify schema drift or data anomalies before they reach a stakeholder.
• Assist the Director of Data in the maintenance and optimization of cloud data warehouses, specifically BigQuery, ensuring performance and cost-efficiency.
• Partner with Marketing and Content teams to normalize data from complex stacks, including GA4, PostHog, Facebook Ads, Reddit, and others, and custom website tracking.

Qualifications

• SQL Mastery: You are a "black belt" in SQL. You write complex joins, window functions, and CTEs that are both performant and easily maintainable.
• Pipeline Expertise: Proven experience building and managing data pipelines at scale using Fivetran or similar automated ingestion tools.
• Orchestration Power User: Experience with Apache Airflow (or similar tools like Prefect/Dagster) for managing complex pipeline dependencies and scheduling.
• Warehouse & Lake Experience: Strong technical proficiency in BigQuery and Redshift, including an understanding of partitioning, clustering, and cost-optimization.
• The "Data Instinct": You have a natural "whiz" for spotting when data is incorrect. You see the anomalies that indicate a tracking break, a sync error, or an API failure instantly.

Requirements

• Modern Marketing Stack Knowledge: A deep understanding of the nuances of GA4 and /or PostHog, web tracking schemas, and media pixel implementation.
• Content Management Data: Experience sourcing and modeling data from Content Management Systems (CMS) to track content performance and attribution.
• Marketing Analytics: Familiarity with how Marketing teams utilize data for campaign optimization and customer journey mapping.

Company Description

We are a faith-based nonprofit organization devoted to helping people grow through meaningful service, community, and care. Our team combines professional excellence with a shared mission to make a lasting impact.