Own and extend ELT pipelines connecting five business systems into BigQuery via Heroku Connect, Fivetran, and custom ingestion
Design and maintain dbt models following star schema patterns (staging → intermediate → marts), including incremental strategies and testing
Solve cross-system identity resolution across three CRMs with different identifier schemes
Build and maintain data quality frameworks: automated testing, schema drift detection, and pipeline observability
Define and implement reverse ETL workflows to push warehouse-derived segments back into Salesforce and Ontraport for marketing and operations teams
Build and maintain Looker dashboards to surface key metrics; provide ad hoc analysis for strategic decisions
Collaborate with engineering to ensure reliable data replication from production systems
Evaluate orchestration tooling and scale the platform as the team grows

Requirements

4+ years of experience –or- a degree in Computer Science, Data Science, or similar and 3 years of experience
Strong proficiency in SQL
Experience with dbt - you've built and maintained dimensional models, not just written queries
Experience wiring together multiple SaaS systems into a warehouse (bonus if you've dealt with Salesforce and/or legacy CRM data)
Comfort with Python for scripting, automation, and custom ingestion
Familiarity with BigQuery or similar cloud warehouses
Pragmatic approach to data quality - you build tests and monitoring, not just dashboards
Ability to work autonomously and make decisions with incomplete information - you'll often be the only person who knows the data layer end to end
Strong understanding of data modeling concepts (dimensional modeling, normalization, schema design) in a Kimball style data warehouse
Experience working in cloud environments (AWS, GCP, or Azure)

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdbtPythondata modelingdimensional modelingschema designincremental strategiesautomated testingschema drift detectionreverse ETL

Soft Skills

autonomydecision makingproblem solvingcollaborationpragmatic approach

Certifications

degree in Computer Sciencedegree in Data Science