Data Engineer Snowflake and Databricks -Chicago, IL -Hybrid

FinTrust Connect; Chicago (IL); Hybrid; USD 117,096 - 227,304; Full time

Job summary

A financial services technology firm in Chicago is seeking a Data Engineer to design and optimize pipelines and models using Snowflake and Databricks. This role requires 5 to 8 years of data engineering experience, particularly with Azure, as well as a strong understanding of ELT processes. The position offers flexibility to work hybrid or remote across the US, with compensation ranging from $85 to $165 per hour depending on experience.

Qualifications

• 5 to 8 years in data engineering with Azure or multi-cloud experience required.
• Experience with Databricks PySpark and Delta.
• Familiarity with Snowflake performance optimization and RBAC.

Responsibilities

• Design and optimize data pipelines and models on Databricks and Snowflake.
• Build secure and reliable ELT processes for regulated workloads.
• Partner with platform teams to improve cost and reliability.

Skills

Data engineering

Databricks

Snowflake

Azure Data Factory

PySpark

SQL Server integration

Job description

Overview

Data Engineer Snowflake and Databricks -Chicago, IL -Hybrid

About the job

FinTrust Connect Chicago IL Hybrid

Share Your Resume and Build Your Future!

Join our Talent Community for Chicago. Winning posts here stress Azure aligned stacks with Databricks plus Snowflake and Azure Data Factory and Synapse or SQL Server integration, and clear impact on risk and finance analytics.

Responsibilities

• As a Data Engineer you will design and optimize pipelines and models on Databricks and Snowflake for regulated workloads, with strong documentation and evidence for audit.
• Build secure and reliable ELT, manage secrets, and enforce roles
• Deliver curated marts for CECL and risk and finance and product use cases
• Add quality checks and lineage and drift monitors
• Partner with platform teams on cost and reliability improvements

Qualifications

• 5 to 8 years in data engineering with Azure or multi cloud
• Databricks PySpark and Delta and jobs and repos
• Snowflake performance and RBAC and streams and tasks
• Azure Data Factory or Airflow, plus dbt for modeling
• SQL Server or Synapse integration experience is a plus

Outcomes we track

• SLA adherence 95% across critical tables
• Cost per TB processed improved 20% in 90 days
• Audit evidence packs complete 100% and on time

Compensation and terms

• Consultant pay $85 to $165 per hour
• Contract Hybrid Chicago IL or Remote US W2 or 1099

Keywords

• Snowflake
• Databricks
• Azure Data Factory
• Synapse
• SQL Server
• PySpark
• Delta Lake
• Unity Catalog
• dbt
• Airflow
• Lineage
• Data Quality
• Cost Optimization
• Financial Services
• Chicago