Sr. AWS Data Engineer

  • Naperville, IL
  • Posted 48 days ago | Updated 5 days ago

Overview

Hybrid
$120,000 - $130,000
Full Time
No Travel Required

Skills

Amazon S3
Amazon Web Services
AWS
Business Intelligence
Data Engineering
Data Modeling
Data Visualization
Microsoft BI
Microsoft SSIS
Microsoft SQL Server
PySpark
Data-flow Diagrams
Data Warehouse
Performance Tuning
PostgreSQL
Glue
Redshift
Athena
Spectrum
Python
C#
T-SQL
SSRS
SSAS
SSIS
GIT

Job Details

Resource 1 is in need of a Sr. AWS Data Engineer for a full-time/ permanent position with our client in Naperville, IL. This position will start off on a remote basis but will eventually transition to a hybrid schedule, working onsite in Naperville 2-3 days/week. Our client is an employee-owned company with excellent benefits, growth opportunities and profit-sharing bonus.

This position is focused on building modern data pipelines, integrations and back-end data solutions. Selected individual will work within cross-functional Agile teams, collaborating with product owners, business analysts and other engineers to design and deliver data solutions that power business insights and AI products.

Responsibilities:

  • Design and develop scalable data pipelines for ingestion, transformation and integration using AWS services.
  • Pull data from Postgres and SQL Server to migrate to AWS.
  • Create and modify jobs in AWS and modify logic in SQL Server.
  • Create SQL queries, stored procedures and functions in PostgreSQL and RedShift.
  • Provide input on data modeling and schema design as needed.
  • Manage infrastructure through infrastructure-as-code templates (Serverless Framework), supporting new data products and services in AWS.
  • Support inbound and outbound data flows, including APIs, S3 replication and secure data sharing.
  • Assist with data visualization/ reporting as needed.
  • Follow an Agile development methodology, with regular workshops and standup meetings, working in two-week sprints.
  • Manage user stories and development tasks in Jira.

Qualifications:  

  • 5+ years of data engineering experience.
  • Experience with AWS and its associated array of offerings (Glue, Redshift, Athena, S3, Lambda, Spectrum).
  • Strong experience with SQL, Python and PySpark.
  • A background in supply chain, logistics or distribution would be a plus.
  • Experience with Power BI is a plus.

 

Benefits include medical/dental/vision insurance, FSA/HSA, life insurance, 401(k), PTO/paid sick time/paid holidays, STD/LTD, ESOP

 

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.