AWS Data Engineer - PERM - Local to Illinois (Naperville)

Resource 1 is in need of a Sr. AWS Data Engineer for a full-time / permanent position with our client in Naperville, IL . Candidate must be local to Illinois because of future hybrid onsite in Naperville expected. 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 PostgreSQL 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 / outbound data flows, including APIs, S3 replication and secured data.
• Assist with data visualization / reporting as needed.
• Follow an Agile development methodology, with regular workshops and standup meetings, working in two-week sprints.

Qualifications :