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 Systems

Grey 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 Role

This 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 Skills

• 5+ years of data engineering experience
• Strong hands-on Snowflake expertise — data warehouse architecture, schema design, query optimization, clustering, roles, and access controls
• Strong dbt expertise — data modeling, transformations, testing, documentation, incremental models, snapshots, and deployment
• Hands-on Dagster experience — pipeline orchestration, asset-based pipelines, scheduling, sensors, and partitioning
• Strong Python proficiency — data engineering scripts, ETL/ELT automation, and data pipeline development
• Expert-level SQL — complex queries, window functions, CTEs, and performance optimization
• Experience building and maintaining scalable ELT pipelines across enterprise data environments
• Strong understanding of data modeling concepts — star schema, Medallion Architecture (Bronze / Silver / Gold), and dimensional modeling
• Experience with data quality frameworks — testing, validation, and monitoring across dbt and pipeline layers
• Strong written and oral communication skills — comfortable working with data analysts, product owners, and business stakeholders
• Omni (omni.co) experience — AI analytics platform:Building and maintaining semantic data models in Omni connected to Snowflake
• Developing Omni workbooks, dashboards, and AI-powered analytics experiences for business stakeholders
• Governing Omni topic structures, field definitions, and access controls across analytics layers
• Leveraging Omni's AI-assisted querying and natural language analytics capabilities to accelerate business insights

What You'll Do

• Design, build, and maintain production-grade ELT pipelines using Python, Dagster, dbt, and Snowflake
• Develop and govern dbt data models — transformations, incremental models, snapshots, tests, and documentation across Bronze / Silver / Gold layers
• Build and maintain Dagster orchestration pipelines — asset-based workflows, scheduling, partitioning, sensors, and alerting
• Architect and optimize Snowflake environments — schema design, clustering keys, materialized views, data sharing, roles, and access control governance
• Write and optimize complex SQL queries across Snowflake for performance, accuracy, and maintainability
• Develop Python scripts and utilities for data ingestion, transformation, validation, and pipeline automation
• Implement data quality frameworks — dbt tests, schema validation, anomaly detection, and pipeline monitoring
• Collaborate with analytics engineers, data analysts, and business stakeholders to deliver reliable, well-documented data products
• Support data platform observability — pipeline monitoring, alerting, lineage tracking, and incident resolution
• Contribute to data engineering standards, best practices, and reusable pipeline patterns across GPARROT engagements
• Leverage AI tools to accelerate data engineering workflows — AI-assisted SQL generation, pipeline debugging, and documentation

Tech Stack

Snowflake · 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 365

Nice to Have

• Experience with dbt Cloud — environment management, jobs, and CI/CD integration
• Familiarity with additional orchestration tools — Airflow or Prefect
• Experience with data ingestion tools — Fivetran, Airbyte, dlt, or custom Python ingestion
• Familiarity with data lakehouse architectures — Delta Lake or Apache Iceberg
• Experience with MotherDuck / DuckDB for analytical workloads
• Snowflake SnowPro Core certification or dbt Certified Developer
• Experience in retail, healthcare, logistics, or financial services data environments
• Familiarity with AI-powered data engineering tools and LLM-integrated data pipelines

Details

• Location: Remote - India
• Experience: 6+
• Type: Full-Time
• Start: Immediate

Grey 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 Connected

For 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.