Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Find Jobs
Find Jobs Near You – Available Work in Your Location
Find & Apply For Data Engineer Jobs in Wheeling, Illinois
Browse jobs from a variety of sources below, sorted with the most recently published, nearest to the top. Click the title to view more information and apply online.
Skip to job details
Now viewing: Sr. AWS Data Engineer (Redshift/ S3/ Databricks)
R1
Resource 1, Inc.
Sr. AWS Data Engineer (Redshift/ S3/ Databricks)
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
80
out of 100
Average of individual scores
Job Description
Sr. AWS Data Engineer (Redshift/ S3/ Databricks) at Resource 1, Inc. Sr. AWS Data Engineer (Redshift/ S3/ Databricks) at Resource 1, Inc. in Wheeling, Illinois Posted in 4 days ago.
Type:
full-time 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.