TeamSnap is looking for a Data Engineer to own our data extraction and orchestration infrastructure. You'll work alongside our Staff Data Engineer to build reliable, maintainable pipelines that power analytics and business operations across the company.
This is a hands-on implementation role. You’ll implement new data infrastructure to replace legacy systems, architect solutions with the team, and build the orchestration layer that keeps data flowing reliably. If you enjoy making messy data problems clean and building infrastructure that others can trust, this is the role.
What You'll Do:
Build and maintain data extraction pipelines from various sources into BigQuery
Refactor and modernize existing extraction systems
Implement monitoring and alerting for pipeline health
Help design and implement our orchestration platform (tooling TBD as a team)
Build scheduling, dependency management, and failure recovery into our data workflows
Create visibility into pipeline status for the broader team and business
Maintain and optimize our BigQuery data warehouse
Support DBT model development and deployment workflows
Implement CI/CD for data infrastructure changes
Support SOC 2 compliance requirements for data systems
Implement security controls and access management in BigQuery
Document data flows and maintain data catalogs
What We're Looking For:
3+ years data engineering experience building extraction pipelines
Strong SQL skills and experience with modern data warehouses (BigQuery, Snowflake, or Redshift)
Experience with data orchestration tools (Airflow, Dagster, Prefect, or similar)
Google Cloud experience (BigQuery, Cloud SQL, Pub/Sub, Cloud Storage) (AWS / Azure is ok too)
CI/CD and containerization experience (Docker
Ability to communicate clearly with technical and non-technical stakeholders
Experience with DBT
Fivetran or similar managed ingestion tools
Background in compliance/governance work (SOC 2, data privacy)
Experience cleaning up legacy data systems
Our Stack:
Warehouse: BigQuery
Transformation: DBT, DBT Cloud
Ingestion: Fivetran, Datastream
Infrastructure: Google Cloud (Pub/Sub, Cloud Storage, CloudSQL), Databricks
BI/Analytics: Omni, Amplitude
Reverse ETL: Hightouch
Monitoring: Datadog
Bonus Points:
You're a parent, coach, or participant in recreational sports
You've used TeamSnap (sign up for a free trial to see what we're about)