Data Engineer

  • Full-time

Company Description

At Shaker, we believe people can do impactful things. Especially our people. In this role, you’ll help us transform companies by connecting them to the right solutions for their most complex talent needs. Focused on helping organizations enhance their recruitment and retention results, you’ll collaborate with co-workers, partners, and clients to make it happen. Within our tight-knit community, you’ll see the future you create and enjoy the team support to learn, grow, and thrive. What could be more powerful than that? Connect to the Power of People, with Shaker. 

Job Description

Shaker’s Analytics team turns media, job board, applicant tracking, and client data into information our clients use to hire better and spend smarter. The Data Engineer owns the ingestion, transformation, and architecture behind that work across ad platforms, job boards, ATS data, and web analytics.

We use Fivetran for automated ingestion, dbt for transformation, Snowflake as our central warehouse, and AWS for custom pipelines. You will build and maintain the pipelines, models, and data quality checks that feed our Tableau dashboards, including Track-to-Hire reporting, and you will be the primary owner of our media data sets and their collection.

Data engineering is a growing discipline at Shaker, and this role is an opportunity to play a formative part in establishing best-in-class practices and procedures for how we build, document, and run our data platform.

RESPONSIBILITIES

Data ingestion and pipelines

  • Configure, manage, and monitor pipelines that ingest media platform data (Google Ads, Meta etc.), job board data, and third-party SaaS sources into Snowflake.
  • Collect and maintain the core data sets used across client reporting, ensuring completeness and accuracy.
  • Ingest data from ATS integrations and ensure those pipelines run on schedule.
  • Design and maintain custom AWS pipelines that land and process API-restricted, unstructured, or file-based data.

Data modeling and transformation

  • Build, test, and maintain modular dbt models that turn raw data into business-ready views of  campaign performance, cost metrics and candidate flow reporting.
  • Document data sources, definitions, pipelines, and runbooks so the team can work independently.

Data quality and monitoring

  • Establish data quality checks using dbt tests and monitoring and resolve pipeline failures and data discrepancies quickly.
  • Automate manual data processes and build scalable workflows that reduce time spent on repetitive tasks.
  • Own virtual warehouse sizing, query performance, cost control, and role-based access controls.

Stakeholder collaboration

  • Partner with agency teams to translate data needs into reliable data solutions.
  • Support and maintain the data sources behind the dashboards used by clients and internal teams.

Qualifications

 

  • Experience:
    • 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 (e.g., Google Ads, Meta, GA4, job boards) and familiarity with using media data to report on performance and delivery.
  • Technical Skills:
    • 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 (S3, Lambda, etc.)
    • 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.
  • Personal Traits:
    • Strong attention to detail and commitment to data accuracy.
    • Self-starter who can own problems end to end and communicate status clearly.
    • Able to explain technical issues to non-technical colleagues in simple, actionable terms.
    • Values respect, inclusion, and teamwork.
    • Comfortable working independently across multiple priorities in a fast-paced environment.

Good to have Skills:

  • 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.

Additional Information

Rewards and Career Advantages

Within a culture defined by energy, fun, and talent, our team enjoys competitive pay, health and financial benefits, and the opportunity to work among innovative, friendly colleagues.   

About Us 

Shaker Recruitment Marketing is the leading full-service talent marketing agency redefining how organizations attract, hire, and retain talent. With 75 years of expertise in branding, talent attraction, media, MarTech, and analytics, Shaker delivers strategies that lead with insight, fueled by creativity, and grounded in a legacy of trust and innovation.  

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply