Lead Data Engineer – Snowflake

About the job Grey Parrot Systems is hiring a Lead Data Engineer to own data platform architecture, set engineering standards, and lead a team building production-grade data pipelines for enterprise client engagements. About Grey Parrot Systems Grey Parrot Systems is a women-owned, BEP-certified IT services firm headquartered in Naperville, IL. We deliver AI-first, governance-driven digital transformation — and we're growing. Must-Have Skills 8+ years of data engineering experience — proven technical leadership or lead engineer experience Expert-level Snowflake — architecture, schema design, query optimization, cost governance, and access controls Expert-level dbt — modeling, transformations, testing, documentation, incremental models, and deployment governance Strong Dagster — asset-based pipelines, scheduling, sensors, and alerting Strong Python — production-grade ETL/ELT automation and pipeline development Expert-level SQL — complex queries, window functions, CTEs, and performance optimization Deep data modeling — Medallion Architecture, star schema, and dimensional modeling Experience defining data engineering standards — coding practices, naming conventions, and documentation Ability to mentor and guide junior and mid-level data engineers Must be local to Naperville, IL — on-site / hybrid availability required What You'll Do Own data engineering architecture and delivery — setting technical direction and governing standards Design and build production-grade ELT pipelines — Python, Dagster, dbt, and Snowflake Govern dbt data models across Bronze / Silver / Gold layers — transformations, tests, and documentation Architect and optimize Snowflake environments — schema design, clustering, materialized views, and cost governance Define and enforce data engineering standards across the team Lead data platform observability — monitoring, alerting, lineage, and incident resolution Mentor junior and mid-level data engineers — raising the technical bar Use Claude and AI tools to accelerate SQL generation, dbt modeling, and pipeline documentation Tech Stack Snowflake · dbt · Dagster · Python · SQL · Medallion Architecture · Fivetran / Airbyte / dlt · Git · CI/CD · Azure / AWS / GCP · Microsoft 365 Nice to Have dbt Cloud, Airflow, or MotherDuck / DuckDB experience Snowflake SnowPro or dbt certification AI-powered data engineering and LLM-integrated pipeline experience What Sets You Apart You built the modern data stack — not just contributed to someone else's You set the dbt standards your team follows and enforce them in code review You mentor engineers who become better because of working with you You use Claude daily to accelerate data engineering work — and teach others to do the same Details Location: Naperville, IL — Local candidates only On-Site / Hybrid required Experience: 8+ years Type: Full-Time Start: Immediate Stay Connected 👉 https://www.linkedin.com/company/gparrot/