Job Description
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 healthHelp design and implement our orchestration platform (tooling TBD as a team)Build scheduling, dependency management, and failure recovery into our data workflowsCreate visibility into pipeline status for the broader team and businessMaintain and optimize our BigQuery data warehouseSupport DBT model development and deployment workflowsImplement CI/CD for data infrastructure changesSupport SOC 2 compliance requirements for data systemsImplement security controls and access management in BigQueryDocument data flows and maintain data catalogs
What We're Looking For:
3+ years data engineering experience building extraction pipelinesStrong 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 (DockerAbility to communicate clearly with technical and non-technical stakeholdersExperience with DBTFivetran or similar managed ingestion toolsBackground in compliance/governance work (SOC 2, data privacy)Experience cleaning up legacy data systems
Our Stack:
Warehouse: BigQueryTransformation: DBT, DBT CloudIngestion: Fivetran, DatastreamInfrastructure: Google Cloud (Pub/Sub, Cloud Storage, CloudSQL), DatabricksBI/Analytics: Omni, AmplitudeReverse ETL: HightouchMonitoring: Datadog
Bonus Points:
You're a parent, coach, or participant in recreational sportsYou've used TeamSnap (sign up for a free trial to see what we're about)