Data Engineer at Thesciongroupllc

Thesciongroupllc

Chicago, Illinois, United States·19h ago

Mid LevelFull-timeRustAWSCI/CDGit

Salary Range

$102,000 - $138,000 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

We are seeking a hands-on Data Engineer to design, build, and maintain reliable ELT pipelines and production-grade analytics models in Snowflake. This role requires strong SQL expertise, deep DBT experience, and the ability to independently build and troubleshoot end-to-end data pipelines.

Key Responsibilities

→Design and implement end-to-end ELT pipelines into Snowflake
→Build and maintain ingestion pipelines from third-party APIs, SaaS platforms, and internal application databases
→Implement and maintain Change Data Capture (CDC) processes
→Design layered DBT models (staging, intermediate, marts)
→Write high-quality, performant SQL transformations
→Implement data validation and anomaly detection checks
→Drive work from design through deployment
→Partner with analytics and business stakeholders to translate requirements into scalable data solutions

Requirements

✓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 a production environment
✓Experience working with Snowflake or similar cloud data warehouse
✓Experience building and maintaining ELT pipelines
✓Experience implementing Change Data Capture (CDC)
✓Experience integrating and ingesting data from external APIs
✓Demonstrated ability to independently diagnose and resolve pipeline and data quality issues