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

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

TikTok

Software Engineer Intern (Lead Ads) - 2025 Summer (BS/MS) Job at TikTok

 ...Successful candidates must be able to commit to one of the following summer internship start dates below: - Monday, May 12- Monday,...  ...Minimum Qualifications: BS/MS degree in Computer Science, Computer Engineering or other relevant majors Excellent... 

Altus Power America Management, LLC

Senior Solar Designer Job at Altus Power America Management, LLC

Senior Solar Designer (Stamford, CT): Conduct engineering site audits to collect structural, electrical, and related site information for use in the design of commercial and industrial solar photovoltaic and energy storage systems. Prepare preliminary layouts and photovoltaic... 

The UPS Store # 6151

Center Associate Job at The UPS Store # 6151

 ...(Fruitville area) : PLEASE NOTE: THIS IS A POSITION WITH "THE UPS STORE" NOT "UPS". UPS STORES ARE PRIVATELY OWNED UPS Store is providing...  ...in everything we do and we do a lot: Packing, Shipping, Freight, Personal/Business Mailbox Services, and much, much more. We... 

Continuum Medical Staffing

Anesthesiology - Physician Opportunity only Job at Continuum Medical Staffing

(Physician/MD qualifications required) Anesthesiology - Anesthesiologist Needed in East Texas! The Medical Center is seeking a BC/BE (if coming out of training) Anesthesiologist to join a single specialty group in the community. The existing practice includes seven physicians... 

MSR Cosmos

SAP SD Consultant Job at MSR Cosmos

 ...Job Title: SAP SD Consultant Job Location: Portland, OR - Onsite Job Type: Contract Pay Rate: $70-75/hr on C2C Exp: 12+ years Job Description : We are looking for an experienced and detail-oriented SAP SD (Sales and Distribution) Consultant...