Skip to main content
Loading
loadingbar
Loading, Please wait..!!

Sr. AWS Data Engineer (Redshift/ S3/ Databricks)

  • Sr. AWS Data Engineer (Redshift/ S3/ Databricks) job type Posted on: Oct 30, 2026
  • Sr. AWS Data Engineer (Redshift/ S3/ Databricks) experience level Resource 1, Inc.
  • Sr. AWS Data Engineer (Redshift/ S3/ Databricks) employment type Northbrook, Illinois
  • Sr. AWS Data Engineer (Redshift/ S3/ Databricks) employment type Onsite
  • Sr. AWS Data Engineer (Redshift/ S3/ Databricks) salary Full-time

Point Apply Here APPLY LATER

Curious about compensation?

Explore the historical salary trends, average pay, and estimated compensation for Sr. AWS Data Engineer (Redshift/ S3/ Databricks) roles in Illinois.

View Salary Guide →

Job Title :

Sr. AWS Data Engineer (Redshift/ S3/ Databricks)

Job Type :

Full-Time

Job Location :

Northbrook Illinois United States

Remote :

No

Jobcon Logo Job Description :

Resource 1 is in need of a Data Engineer (AWS/ SQL/ Databricks) with at least 5 years of experience for a 6-month contract-for-hire with our client in the north suburbs. Individual will need to be local and able to work onsite in Northfield, IL 3 days per week. The resource will focus on the company's AWS-based data platform, primarily developing and stabilizing ETL pipelines and dimensional models in Redshift and Databricks to enable analytics and Tableau reporting. They will investigate and resolve data breaks, design and implement data transformations, and support planning and budgeting application integrations. Responsibilities:Develop and maintain data and cloud solutions leveraging Databricks and AWS technologies.Develop/ maintain ETL pipelines to ingest and process data into Redshift data warehouse from various data sources, including Salesforce and Dynamics 365.Build, schedule, and manage data ingestion jobs using AWS Glue, Airflow, S3, and related services.Write and maintain complex SQL stored procedures and other database code for data manipulation.Design, build, and maintain data pipelines across all layers of the Medallion Architecture (Bronze, Silver and Gold).Design and implement dimensional data models and data marts for analytics and Tableau consumption.Collaborate with the Analytics & Insights team and business stakeholders to translate reporting requirements into data models and metadata to support operational reporting needs.Support planning and budgeting application interfaces and related Python-based validation scripts.Apply strong problem-solving and critical-thinking skills to troubleshoot complex technical issues and identify opportunities for improvement.Required Skills & Experience:5+ years of database development/ data engineering experience.Proficiency with AWS data services such as Redshift, S3, Glue, and Airflow scheduling.Strong SQL skills including complex queries and stored procedures.Experience with data modeling and dimensional modeling best practices.Python programming experience and ability to write and maintain notebooks or scripts.Familiarity with Databricks or ability to learn Databricks notebooks and workflows quickly.Strong data analysis and problem-solving skills.Plusses:Hands-on Databricks experience and familiarity with PySpark.Experience with Dynamics 365 (D365) tables and integrations.Technical Environment:AWS Redshift, Databricks, PySpark, Python, SQL Stored Procedures, EDW (Enterprise Data Warehouse), AWS S3, AWs Glue, Tableau, Power BI, PostgreSQL, ETL, Dynamics 365 (D365), ServiceNow and Jitterbit.

Jobcon Logo Position Details

Posted:

Oct 30, 2026

Reference Number:

10440_4473538971

Employment:

Full-time

City:

Northbrook

Job Origin:

APPCAST_CPC

Share this job:

  • linkedin

Jobcon Logo
A job sourcing event
In Dallas Fort Worth
Aug 19, 2017 9am-6pm
All job seekers welcome!

Sr. AWS Data Engineer (Redshift/ S3/ Databricks)    Apply

Click on the below icons to share this job to Linkedin, Twitter!

Resource 1 is in need of a Data Engineer (AWS/ SQL/ Databricks) with at least 5 years of experience for a 6-month contract-for-hire with our client in the north suburbs. Individual will need to be local and able to work onsite in Northfield, IL 3 days per week. The resource will focus on the company's AWS-based data platform, primarily developing and stabilizing ETL pipelines and dimensional models in Redshift and Databricks to enable analytics and Tableau reporting. They will investigate and resolve data breaks, design and implement data transformations, and support planning and budgeting application integrations. Responsibilities:Develop and maintain data and cloud solutions leveraging Databricks and AWS technologies.Develop/ maintain ETL pipelines to ingest and process data into Redshift data warehouse from various data sources, including Salesforce and Dynamics 365.Build, schedule, and manage data ingestion jobs using AWS Glue, Airflow, S3, and related services.Write and maintain complex SQL stored procedures and other database code for data manipulation.Design, build, and maintain data pipelines across all layers of the Medallion Architecture (Bronze, Silver and Gold).Design and implement dimensional data models and data marts for analytics and Tableau consumption.Collaborate with the Analytics & Insights team and business stakeholders to translate reporting requirements into data models and metadata to support operational reporting needs.Support planning and budgeting application interfaces and related Python-based validation scripts.Apply strong problem-solving and critical-thinking skills to troubleshoot complex technical issues and identify opportunities for improvement.Required Skills & Experience:5+ years of database development/ data engineering experience.Proficiency with AWS data services such as Redshift, S3, Glue, and Airflow scheduling.Strong SQL skills including complex queries and stored procedures.Experience with data modeling and dimensional modeling best practices.Python programming experience and ability to write and maintain notebooks or scripts.Familiarity with Databricks or ability to learn Databricks notebooks and workflows quickly.Strong data analysis and problem-solving skills.Plusses:Hands-on Databricks experience and familiarity with PySpark.Experience with Dynamics 365 (D365) tables and integrations.Technical Environment:AWS Redshift, Databricks, PySpark, Python, SQL Stored Procedures, EDW (Enterprise Data Warehouse), AWS S3, AWs Glue, Tableau, Power BI, PostgreSQL, ETL, Dynamics 365 (D365), ServiceNow and Jitterbit.

Loading
Please wait..!!