AWS Data Engineer - CFH - Northbrook, IL Job at Resource 1, Inc., Northbrook, IL

S3JXM0N4MEVQRkF2cm8weHptWG9KSDV2aHc9PQ==
  • Resource 1, Inc.
  • Northbrook, IL

Job Description

NO THIRD PARTIES . This is almost entirely remote. Individual will only need to work onsite at the Northbrook location 1 day per week. The selected individual will work closely with cross-functional teams, including data engineers, analysts, and business stakeholders, to ensure the successful implementation of data models, ETL pipelines and data processing.

Responsibilities:

  • Design/ implement scalable data models and architecture using Redshift.
  • Work with business and data teams to translate requirements into data models.
  • Develop and optimize SQL queries and stored procedures.
  • Develop/ maintain ETL pipelines to ingest and process data into Redshift data warehouse from various data sources , including Salesforce.com, Dynamics 365, etc.
  • Ensure smooth data integration from multiple sources, including cloud-based and on-prem.
  • Monitor performance of Redshift environment and optimize queries, tables, indexes, etc.
  • Utilize Redshift best practices to optimize query performance.
  • Ensure data integrity, quality, and consistency across the EDW (Enterprise Data Warehouse).
  • Document data models, ETL processes, and Redshift configurations.
  • Troubleshoot issues related to data extraction, transformation and loading processes.

Required Skills:

  • 5+ years of experience in designing, developing, and optimizing data solutions using Amazon Redshift .
  • Strong experience with SQL , including complex queries, stored procedures, and functions.
  • Knowledge of data modeling best practices (logical, star schema, snowflake schema).
  • Proficiency in Amazon Web Services (AWS) ecosystem, especially Redshift.
  • Experience with AWS S3 and other AWS services for data storage and processing.
  • Experience with Tableau or other comparable tool like Power BI or AWS QuickSight.
  • Prior experience using ServiceNow for building, configuring and testing new releases.
  • Understanding of database optimization techniques (e.g., indexing and query optimization).

Technical Skills:

AWS Redshift, EDW (Enterprise Data Warehouse), AWS S3, SQL, Tableau, Power BI, PostgreSQL, ETL Development, Queries, Stored Procedures, ServiceNow, Oracle and Jitterbit.

Job Tags

1 day per week,

Similar Jobs

Disability Solutions

2026 Summer Intern - Global Product Strategy Job at Disability Solutions

 ...The Position 2026 Summer Intern - Global Product Strategy Department Summary Global Product Strategy (GPS) provides strategic...  ...located in South San Francisco, on-site. The Opportunity The MBA internship position is offered in the strategic insights team,... 

Amazon Web Services (AWS)

GenAI Solutions Architect for Startup Growth (San Francisco) Job at Amazon Web Services (AWS)

 ...A leading cloud services provider is seeking a GenAI Solutions Architect to work with early-stage startups in San Francisco. This role...  ...10 years in IT development and significant experience in cloud computing and software development. Competitive compensation and a... 

TransForce Inc.

CDL A Route Delivery Driver - $26.27/hr Job at TransForce Inc.

 ...Job Info Job Location: Ashland, VA Route Type: Local Type of Assignment: Flex Hours Per Shift: 8 Hours Hours Per Week...  ...Additional Information TransForce is seeking full-time CDL A drivers in Ashland, VA. This job is offering $26.27 per hour.... 

ITR Group

Cloud Architect (Minneapolis) Job at ITR Group

 ...Opportunity available for a Azure Cloud Architect to drive an ongoing enterprise initiative to migrate environmentincluding databases...  ...and Infrastructure-as-Code. ~ Understanding of cloud computing fundamentals and enterprise cloud migration best practices. ~... 

United Parcel Service

Personal Vehicle Delivery Driver Job at United Parcel Service

Deliver from the comfort of your own vehicle! As a seasonal support driver (SSD), youll deliver packages to communities and businesses from your personal vehicle. This is a friendly, physically active role, so youll need to enjoy fast-paced work, being outdoors, and safely...