Lead Snowflake Data Engineer (Certified) - Chicago, IL (Hybrid – 2 Days Onsite per Week) - & USC

Hybrid in Chicago, IL, US • Posted 2 hours ago • Updated 2 hours ago
Contract W2
12 Months
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Data Engineering
  • Data Warehousing
  • Snowflake data platform
  • SnowPro Core Certification
  • Data Build Tool
  • SQL
  • ELT/ETL pipelines
  • data modeling
  • AWS
  • Microsoft Azure
  • Git
  • CI/CD
  • DevOps

Summary

We are seeking a Lead Snowflake Data Engineer (Certified) in Chicago, IL (Hybrid – 2 Days Onsite per Week).

 

Job Title: Lead Snowflake Data Engineer (Certified)
Location: Chicago, IL (Hybrid – 2 Days Onsite per Week)

Work Model: Hybrid – 2 Days Onsite per Week

Job Type: Long-Term Contract
Experience: 12+ Years


Required Certification: SnowPro Core Certification or Equivalent

 

Note: Candidates must have strong hands-on Snowflake and dbt expertise, relevant certification credentials, and the ability to work in a hybrid environment in Chicago, IL.

 

Job Overview

We are seeking an experienced and highly skilled Lead Snowflake Data Engineer to join our data engineering team supporting Macy's. The ideal candidate will have extensive hands-on experience in designing, developing, and optimizing enterprise-scale data solutions using Snowflake, dbt, SQL, and modern cloud data platforms.

The candidate will play a key role in building scalable, reliable, and high-performance data pipelines and modern data warehouse solutions. Experience working with retail or eCommerce data domains is highly desirable, particularly in areas such as customer analytics, product catalog, orders, inventory management, pricing, sales, and digital customer engagement.

This role requires strong technical leadership, excellent problem-solving abilities, and the ability to collaborate with cross-functional teams in an Agile delivery environment.

 

Key Responsibilities

1. Snowflake Data Engineering

  • Design, develop, and maintain scalable data pipelines and enterprise data warehouse solutions using Snowflake.
  • Build and optimize Snowflake data models, databases, schemas, tables, views, and stored procedures.
  • Implement efficient data ingestion and transformation strategies using Snowflake capabilities.
  • Work with Snowflake architecture, including virtual warehouses, micro-partitions, clustering, time travel, and query optimization.
  • Monitor Snowflake workloads and optimize query performance, resource utilization, and overall platform efficiency.
  • Implement best practices for data security, access controls, governance, and data sharing.

 

2. dbt & Data Transformation

  • Develop and maintain robust ELT pipelines using dbt.
  • Build modular, reusable, and maintainable dbt models.
  • Implement dbt testing, documentation, snapshots, incremental models, and data quality validations.
  • Design and implement dimensional data models, including Star and Snowflake schemas.
  • Optimize complex SQL transformations for large-scale analytical workloads.
  • Manage dependencies and orchestration across data transformation workflows.

 

3. Cloud Data Platform Integration

  • Develop and maintain cloud-based data engineering solutions using AWS or Microsoft Azure.
  • Integrate Snowflake with cloud storage, data sources, and enterprise applications.
  • Work with cloud-native services to support data ingestion, processing, storage, and orchestration.
  • Implement secure and reliable data movement between cloud platforms and Snowflake.

 

4. Retail & eCommerce Data Engineering

  • Develop data solutions supporting retail and eCommerce business operations.
  • Work with complex datasets covering:
    • Customer profiles and customer behavior.
    • Orders, transactions, and sales.
    • Product catalog and merchandising.
    • Inventory and supply chain management.
    • Pricing, promotions, and discounts.
    • Website clickstream and digital customer engagement.
  • Translate business requirements into scalable data engineering solutions.
  • Ensure data accuracy, consistency, and availability for reporting, analytics, and business intelligence.

 

5. CI/CD, DevOps & Automation

  • Implement CI/CD pipelines for Snowflake and dbt development and deployment.
  • Utilize Git-based version control and collaborative development practices.
  • Automate testing, validation, and deployment processes.
  • Follow DevOps best practices to ensure reliable releases and environment management.
  • Collaborate with DevOps and platform engineering teams to improve deployment efficiency.

 

6. Technical Leadership & Collaboration

  • Provide technical guidance and support to data engineering teams.
  • Participate in architecture discussions, technical design reviews, and code reviews.
  • Troubleshoot complex data pipeline and production issues.
  • Collaborate with business analysts, architects, data scientists, and other engineering teams.
  • Participate in Agile ceremonies, sprint planning, and delivery activities.

 

Required Technical Skills

  • 12+ years of overall experience in Data Engineering, Data Warehousing, or related technologies.
  • Strong hands-on experience with Snowflake data platform.
  • Active SnowPro Core Certification or equivalent Snowflake certification/credentials.
  • Extensive experience with dbt (Data Build Tool).
  • Advanced SQL development and optimization skills.
  • Strong experience building ELT/ETL pipelines.
  • Expertise in dimensional data modeling and modern data warehousing.
  • Experience with AWS or Microsoft Azure cloud platforms.
  • Hands-on experience with Git, CI/CD, DevOps, and automated deployment pipelines.
  • Strong knowledge of data quality, data governance, and performance optimization.
  • Excellent communication and problem-solving skills.

 

Preferred / Good-to-Have Skills

  • Experience in retail, eCommerce, or large-scale consumer-facing enterprise environments.
  • Familiarity with Google Cloud Platform.
  • Experience with Snowflake Streams, Tasks, Dynamic Tables, and Snowpipe.
  • Experience with orchestration tools such as Apache Airflow or Azure Data Factory.
  • Exposure to Python for data engineering and automation.
  • Experience integrating Snowflake with BI and analytics platforms.
  • Previous experience supporting enterprise-scale data platforms.

 

Education & Certification

  • Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related discipline preferred.
  • SnowPro Core Certification is mandatory, or equivalent Snowflake certification/credentials as accepted by the client.

 

 

Sarum LLC
68-60 Austin Street, Suite 403,
Forest Hills, NY 11375
Phone#

Email :

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91116024
  • Position Id: 9145376
  • Posted 2 hours ago
Contact the job poster
Dilya Zakirova

Dilya Zakirova

Recruiter. @ Sarum LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.