Data Engineer

Shaker Recruitment Marketing•Oak Park, IL

About The Position

Shaker’s Analytics team turns media, job board, applicant tracking, and client data into information clients use to hire better and spend smarter. The Data Engineer owns the ingestion, transformation, and architecture behind this work across advertising platforms, job boards, ATS data, and web analytics. The team uses Fivetran for automated ingestion, dbt for transformation, Snowflake as its central warehouse, and AWS for custom pipelines. This role builds and maintains the pipelines, models, and data quality checks that feed Tableau dashboards, including Track-to-Hire reporting, and serves as the primary owner of media data sets and their collection. Data engineering is a growing discipline at Shaker. The role offers an opportunity to help establish practices and procedures for building, documenting, and operating the data platform.

Requirements

  • At least 3 years of hands-on data engineering experience building production-grade data platforms and ELT/ETL pipelines.
  • Hands-on experience running a cloud data warehouse in production, preferably Snowflake.
  • Experience with marketing or advertising data sources such as Google Ads, Meta, GA4, or job boards, and familiarity with using media data to report on performance and delivery.
  • Advanced SQL skills, including complex joins, CTEs, transformations, and query performance optimization.
  • Experience building and maintaining modular data models in dbt, including tests, lineage, and documentation.
  • Experience setting up, troubleshooting, and managing Fivetran or similar ingestion connectors.
  • Experience with core AWS data services such as S3 and Lambda.
  • Proficiency in Python for API data extraction, scripting, and pipeline automation.
  • Experience with structured and semi-structured data, including JSON and APIs.
  • Familiarity with Git and version control.
  • Strong attention to detail and commitment to data accuracy.
  • Ability to own problems end to end and communicate status clearly.
  • Ability to explain technical issues to non-technical colleagues in simple, actionable terms.
  • Values respect, inclusion, and teamwork.
  • Comfort working independently across multiple priorities in a fast-paced environment.

Nice To Haves

  • Experience with ATS or recruitment marketing data, including job board and applicant data.
  • Experience with automated testing and deployment of data pipeline code.
  • Familiarity with Tableau or other BI tools.

Responsibilities

  • Configure, manage, and monitor pipelines that ingest media platform data, job board data, and third-party SaaS sources into Snowflake.
  • Collect and maintain core data sets used across client reporting, ensuring completeness and accuracy.
  • Ingest data from ATS integrations and ensure pipelines run on schedule.
  • Design and maintain custom AWS pipelines for API-restricted, unstructured, or file-based data.
  • Build, test, and maintain modular dbt models that transform raw data into business-ready views of campaign performance, cost metrics, and candidate flow.
  • Document data sources, definitions, pipelines, and runbooks.
  • Establish data quality checks using dbt tests and monitoring, and quickly resolve pipeline failures and data discrepancies.
  • Automate manual data processes and build scalable workflows that reduce repetitive work.
  • Own virtual warehouse sizing, query performance, cost control, and role-based access controls.
  • Partner with agency teams to translate data needs into reliable data solutions.
  • Support and maintain data sources behind dashboards used by clients and internal teams.

Benefits

  • Competitive pay
  • Health and financial benefits
  • Opportunity to work among innovative, friendly colleagues
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service