> Markdown version of [/jobs/ext/1280133-data-engineer](https://www.wearedevelopers.com/jobs/ext/1280133-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - **Company:** The Scion Group - **Location:** Chicago, IL, United States - **Experience:** Experienced - **Salary:** $115,000.0 - $135,000.0 - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, Application Programming Interfaces (APIs), Software as a Service, Cloud Computing, Databases, Continuous Integration, Data Validation, Data Control, Information Engineering, Data Systems, Digital Assets, Github, Performance Tuning, SQL Databases, Strategies of Testing, Workflow Management Systems, Data Ingestion, Sql Optimization, Snowflake, Change Data Capture, Git Flow, Looker Analytics, Data Pipelines, Web Api - **Published:** July 15, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=403e54196b236e09 ## 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 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., * 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. ## Description 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., We value engineers who: * 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 ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Web APIs you might not know about](https://www.wearedevelopers.com/videos/281-web-apis-you-might-not-know-about) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Why Git Still Matters](https://www.wearedevelopers.com/videos/100288-why-git-still-matters) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)