Realign LLC - Data Engineer with Snowflake 2

Cloud Developer is needed in Chicago, United States.

Client: Realign LLC

Location: Chicago, IL

Contract: 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.

Additional Information

Job Type: Contract

Job Category: IT

Location: Chicago, IL (Onsite)