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

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

New York State Civil Service

Electrical Estimator Job at New York State Civil Service

 ...NY HELP No Agency State University Construction Fund Title Electrical Estimator Occupational Category Skilled Craft, Apprenticeship, Maintenance Salary Grade 23 Bargaining Unit None listed Salary Range From $91464 to $110189 Annually... 

LVI Associates

BIM Designer Job at LVI Associates

 ...7 years of experience in building design with a strong focus on BIM Advanced proficiency in Revit; experience with Navisworks, AutoCAD, and other BIM tools is a plus Strong understanding of construction documents, detailing, and building systems Excellent communication... 

ALEX K HSU AND JUAN P LOY MDS, PA

Certified Phlebotomy Technician/Medical Assistant Job at ALEX K HSU AND JUAN P LOY MDS, PA

 ...with both clinical and administrative duties , including phlebotomy , insurance verification , prior authorizations , and HEDIS coordination . Responsibilities: Phlebotomist / Medical Assistant Experienced in blood draw and specimen collection , coding... 

Savills North America

Research Analyst Job at Savills North America

 ...results. When you join Savills, our ask for you is simple: Be extraordinary, together. About the role Savills is seeking a Research Analyst to join our research team, covering the Minneapolis market. Joining as a Research Analyst provides an opportunity for... 

icreatives

Video Production Assistant Job at icreatives

 ...Video Production Assistant - Part-Time Pembroke Pines, FL area, Temp, Hybrid + On-Site as...  ...is an opportunity to put your skills to work creating meaningful content that supports...  ...2 days in the office and 1 day WFH. 100% REMOTE work is not available. To apply, please...