Data Engineer | ELT Pipelines in Snowflake & DBT

Thesciongroupllc; Chicago (IL); On-site; USD 115,000 - 135,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

401k Matching

Paid Maternity Leave

FLSA Status

Discretionary annual EOY bonus

Paid Time Off

Job summary

The Scion Group LLC in Chicago, IL is seeking a hands-on Data Engineer to design, build, and maintain reliable ELT pipelines and production-grade analytics models in Snowflake. The ideal candidate has strong SQL expertise, deep DBT experience, and the ability to independently build and troubleshoot end-to-end data pipelines—from ingestion (APIs, CDC) through transformation and BI consumption.

This role emphasizes data quality, monitoring, and collaboration with analytics teams, supporting Looker

Qualifications

• 3–6 years of experience in data engineering or analytics engineering.
• Advanced SQL proficiency (window functions, performance tuning, complex joins).
• Hands-on experience building DBT models in production environments.
• Experience with Snowflake or similar cloud data warehouses.
• Experience building and maintaining ELT pipelines.
• Experience implementing CDC.
• Experience ingesting data from external APIs.
• Ability to diagnose and resolve pipeline and data quality issues independently.
• Experience deploying production-ready data assets with minimal oversight.

Responsibilities

• Design and implement end-to-end ELT pipelines into Snowflake.
• Build and maintain ingestion pipelines from third-party APIs, SaaS platforms, and internal databases.
• Implement and maintain Change Data Capture (CDC) processes.
• Ensure incremental loading, idempotency, and data consistency.
• Diagnose and resolve ingestion failures independently.
• Design layered DBT models (staging, intermediate, marts).
• Write high-quality, performant SQL transformations and test strategies.
• Optimize transformations for cost and performance in Snowflake.
• Ensure production data assets are complete, timely, and trustworthy.
• Drive work from design through deployment and monitor pipelines and models.
• Collaborate with analytics and business stakeholders to translate requirements for scalable data solutions.
• Support Looker semantic modeling and dashboard reliability.

Skills

SQL

DBT

Snowflake

ELT pipelines

CDC

APIs

Tools

Looker

Job description

The Scion Group LLC in Chicago, IL is seeking a hands-on Data Engineer to design, build, and maintain reliable ELT pipelines and production-grade analytics models in Snowflake. The ideal candidate has strong SQL expertise, deep DBT experience, and the ability to independently build and troubleshoot end-to-end data pipelines—from ingestion (APIs, CDC) through transformation and BI consumption.

This role emphasizes data quality, monitoring, and collaboration with analytics teams, supporting Looker