Job Title: Data Engineer with Snowflake
Location: Chicago, IL (Onsite)
Contract
Job Description:
We are seeking an experienced Data Engineer with strong Snowflake expertise to join our growing data engineering team. The ideal candidate will have hands-on experience in designing, developing, and optimizing data pipelines and warehousing solutions on Snowflake.
Responsibilities:
Design, develop, and maintain scalable ETL/ELT pipelines using Snowflake and modern data integration tools (e.g., Matillion, DBT, Airflow).
Work with cross-functional teams to understand business requirements and translate them into robust data solutions.
Implement data modeling, data quality, and data governance best practices.
Optimize Snowflake performance, including query tuning, clustering, and warehouse sizing.
Collaborate with data scientists, analysts, and other stakeholders to ensure reliable data delivery.
Integrate data from multiple sources (structured and unstructured) into the Snowflake platform.
Support and automate data ingestion processes using Python, SQL, or AWS Glue.
Monitor and troubleshoot data workflows to ensure data accuracy and availability.
Required Skills:
10+ years of experience as a Data Engineer.
7+ years of hands-on experience with Snowflake (data warehousing, performance tuning, and security).
Strong SQL and Python skills.
Experience with ETL/ELT tools such as Matillion, Informatica, DBT, or Talend.
Proficiency in AWS (S3, Lambda, Glue, Redshift, etc.) or Azure cloud data services.
Experience with data modeling (Kimball/Inmon) and building star/snowflake schemas.
Familiarity with CI/CD pipelines, Git, and Agile methodologies.