Data Engineer

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

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to sponsor visas.

Your Opportunity

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 demonstrated ability to independently build and troubleshoot end‑to‑end data pipelines — from ingestion (APIs, change data capture) through transformation and BI consumption.

The ideal candidate takes ownership of data systems, proactively identifies failure points, and delivers production‑ready solutions without sustained oversight.

Your Responsibilities

ELT Pipeline Development

• Design and implement end‑to‑end ELT pipelines into Snowflake.
• Build and maintain ingestion pipelines from:
  • Third‑party APIs
  • SaaS platforms
  • Internal application databases
• Implement and maintain Change Data Capture (CDC) processes.
• Ensure incremental loading, idempotency, and data consistency.
• Diagnose and resolve ingestion failures independently.

Data Modeling & Transformation (DBT)

• Design layered DBT models (staging, intermediate, marts).
• Write high‑quality, performant SQL transformations.
• Implement incremental models and testing strategies.
• Optimize transformations for cost and performance in Snowflake.
• Ensure transformations are production‑ready and validated prior to deployment.

Data Quality & Monitoring

• Implement data validation and anomaly detection checks.
• Design monitoring around pipeline failure modes.
• Perform structured root cause analysis for data discrepancies.
• Ensure production datasets are complete, timely, and trustworthy.

Production Ownership

• Drive work from design through deployment.
• Validate outputs prior to release.
• Monitor deployed pipelines and models.
• Proactively address data gaps or inconsistencies.
• Document assumptions, transformations, and dependencies clearly.

BI & Collaboration

• Partner with analytics and business stakeholders to translate requirements into scalable data solutions.
• Support Looker semantic modeling and dashboard reliability.
• Communicate technical tradeoffs clearly and concisely.

The responsibilities listed above may not be all inclusive.

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 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.
• Experience deploying production‑ready data assets with minimal oversight.

Preferred Qualifications

• Experience with Git‑based workflows and CI/CD (e.g., GitHub Actions, dbt Cloud).
• Experience designing data monitoring frameworks.
• Experience with Looker or similar BI tools.
• Familiarity with orchestration tools.

What We’re Looking For

• Take full ownership of data systems.
• Think critically about edge cases and failure modes.
• Identify problems before stakeholders do.
• Drive initiatives to production completion.
• Communicate clearly and proactively.
• Understand that reliability is as important as functionality

Operational Details

• Job location is based at Scion headquarters in Chicago, IL
• Working hours are general daytime business hours

Your Benefits

• Health Insurance
• Dental Insurance
• Vision Insurance
• 401k Matching
• Paid Maternity Leave
• FLSA Status
• Discretionary annual EOY bonus
• Paid Time Off

The Scion Group LLC provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, religion, creed, national origin, color, gender, sex, sexual orientation, gender identity or expression, age, physical or mental disability (as long as the employee/applicant is otherwise qualified for the job with or without a reasonable accommodation), genetic information, HIV/AIDS status, marital status, uniformed service, veteran status, pregnancy or other legally protected status or category under federal or state law. The Scion Group LLC complies with applicable state and local laws governing nondiscrimination in employment in all locations in which the Company has properties. This policy applies to all terms and conditions of employment, including hiring, placement, promotion, termination, layoff, recall, transfers, leaves of absence, compensation, training and other terms and conditions of employment. The Scion Group LLC is committed to the principles of equal employment opportunities.

The base salary range for this full‑time position is base + bonus + benefits. Our salary ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job‑related skills, experience, and relevant education or training. Your recruiter can share more about the specific salary range for your preferred location during the hiring process.

Illinois Pay Range

$115,000 — $135,000 USD