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

UXE4eWUxN1pzVGpHaEg4YzVHNC95MVArUFE9PQ==
  • 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

IDR, Inc.

Entry Level Recruiter/Account Manager Job at IDR, Inc.

 ...All of our Sales Managers, Directors, and Executives started as entry level recruiters and have worked their way up. We offer a clear...  ...tenure. From day one, we give our employees the tools and resources to jump start their career. This includes mentorship programs,... 

Level Up Events

Customer Service Associate Job at Level Up Events

 ..., were hiring Customer Service Associates to support our expanding client portfolio. Our goal? To deliver exceptional customer experiences and foster brand loyalty through innovative events, product launches, and personalized engagement. Your Responsibilities:... 

Revel Architecture & Design

Receptionist Job at Revel Architecture & Design

 ...Track and order basic office supplies (paper, pens, toner, etc.) Ensure meeting rooms are stocked and presentable Support shipping and receiving of computers, hardware, and equipment Assist with light administrative and operational tasks AV and Facilities... 

Cadence

Principal C++ Software Engineer - Protium Debug/Runtime Software Modules (R48578/jg) Job at Cadence

 ...At Cadence, we hire and develop engineers and innovators who want to make an impact on the world of technology. Cadence is the industry leader of Verification software and hardware, our emulation and prototyping systems provide comprehensive IP/SoC design verification,... 

Integris Assurance Company

Underwriting Assistant Job at Integris Assurance Company

 ...values you ! Integris Group is a medical professional liability insurance carrier. We put our talents to work protecting dedicated...  ...environment, we invite you to explore the following position. Job Title: Underwriting Assistant (Full Time) Job Description The...