Data Engineer – Snowflake, dbt, Dagster & Python

Grey Parrot Systems is hiring an experienced Data Engineer with strong hands-on expertise in Snowflake, dbt, Dagster, SQL, and Python to design, build, and maintain scalable, production-grade data pipelines and modern data platform solutions for our enterprise client engagements.About Grey Parrot SystemsGrey Parrot Systems is a women-owned, BEP-certified IT services firm headquartered in Naperville, IL. We partner with mid-market enterprises to deliver AI-first, governance-driven digital transformation. Our team of seasoned CIO/CTO practitioners works side-by-side with clients across retail, logistics, manufacturing, and healthcare — and we're growing.About the RoleThis is a senior hands-on data engineering role for an engineer who has built and maintained production-grade data pipelines and modern data platforms — Snowflake as the cloud data warehouse, dbt for transformation and modeling, Dagster for orchestration, and Python and SQL as the core engineering tools. You are equally comfortable designing a Snowflake data model, writing a complex dbt transformation, debugging a Dagster pipeline, and optimizing a slow SQL query. You think in data quality, observability, and governance — not just pipelines. If you have 5+ years of data engineering experience with this modern stack — we want to hear from you.Must-Have Skills5+ years of data engineering experienceStrong hands-on Snowflake expertise — data warehouse architecture, schema design, query optimization, clustering, roles, and access controlsStrong dbt expertise — data modeling, transformations, testing, documentation, incremental models, snapshots, and deploymentHands-on Dagster experience — pipeline orchestration, asset-based pipelines, scheduling, sensors, and partitioningStrong Python proficiency — data engineering scripts, ETL/ELT automation, and data pipeline developmentExpert-level SQL — complex queries, window functions, CTEs, and performance optimizationExperience building and maintaining scalable ELT pipelines across enterprise data environmentsStrong understanding of data modeling concepts — star schema, Medallion Architecture (Bronze / Silver / Gold), and dimensional modelingExperience with data quality frameworks — testing, validation, and monitoring across dbt and pipeline layersStrong written and oral communication skills — comfortable working with data analysts, product owners, and business stakeholdersWhat You'll DoDesign, build, and maintain production-grade ELT pipelines using Python, Dagster, dbt, and SnowflakeDevelop and govern dbt data models — transformations, incremental models, snapshots, tests, and documentation across Bronze / Silver / Gold layersBuild and maintain Dagster orchestration pipelines — asset-based workflows, scheduling, partitioning, sensors, and alertingArchitect and optimize Snowflake environments — schema design, clustering keys, materialized views, data sharing, roles, and access control governanceWrite and optimize complex SQL queries across Snowflake for performance, accuracy, and maintainabilityDevelop Python scripts and utilities for data ingestion, transformation, validation, and pipeline automationImplement data quality frameworks — dbt tests, schema validation, anomaly detection, and pipeline monitoringCollaborate with analytics engineers, data analysts, and business stakeholders to deliver reliable, well-documented data productsSupport data platform observability — pipeline monitoring, alerting, lineage tracking, and incident resolutionContribute to data engineering standards, best practices, and reusable pipeline patterns across GPARROT engagementsLeverage AI tools to accelerate data engineering workflows — AI-assisted SQL generation, pipeline debugging, and documentationTech StackSnowflake · dbt (Core / Cloud) · Dagster · Python · SQL · Medallion Architecture (Bronze / Silver / Gold) · Git / GitHub · CI/CD Pipelines · Azure / AWS / GCP · Data Quality Frameworks · Jira · Confluence · Microsoft 365Nice to HaveExperience with dbt Cloud — environment management, jobs, and CI/CD integrationFamiliarity with additional orchestration tools — Airflow or PrefectExperience with data ingestion tools — Fivetran, Airbyte, dlt, or custom Python ingestionFamiliarity with data lakehouse architectures — Delta Lake or Apache IcebergExperience with MotherDuck / DuckDB for analytical workloadsSnowflake SnowPro Core certification or dbt Certified DeveloperExperience in retail, healthcare, logistics, or financial services data environmentsFamiliarity with AI-powered data engineering tools and LLM-integrated data pipelinesDetailsLocation: Naperville / Chicago, IL — On-SiteExperience: 4 to 6 YearsType: Full-TimeStart: ImmediateGrey Parrot Systems is an Equal Opportunity Employer. As a women-owned, BEP and WBENC-certified firm, diversity and inclusion are core to who we are. We consider all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, or any other legally protected characteristic. We strongly encourage applications from candidates of all backgrounds, identities, and experiences — including those from underrepresented groups in technology. Reasonable accommodations are available upon request.Stay ConnectedFor more job openings, company updates, and AI industry insights, follow Grey Parrot Systems on LinkedIn.👉 https://www.linkedin.com/company/gparrot/We are always looking for talented, driven professionals to join our growing team. Whether this role is the right fit today or not, connect with us and be the first to hear about new opportunities as we expand across Chicago, Detroit, and the Midwest.