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

Planet Technology

Workday Trainer Job at Planet Technology

Planet Technology is hiring a Workday Trainer . Our client is a Healthcare provider in Los Angeles, California . They recently went live with Workday. They are looking to add a Workday Trainer to their team. The role is intended to be contract-to-hire with a perm...

Entegee

Software Engineer Job at Entegee

 ...Peabody, MA (Local candidates only please)6+ month contract The ideal candidate has a background in modern software and network architectures with embedded systems in a Linux environment. Strong problem-solving skills and the ability to work in a dynamic work environment... 

Tillys

Assistant Buyer - Women's Job at Tillys

 ...RESPONSIBILITIES: Support Buyer on all day-to-day functions of the department. Generates, maintains, and follows through on all Purchase Orders. Some examples include vendor delivery, tickets, samples, and warehouse issues etc. Ensure that communication (written/... 

Response Inc.

Full Time Direct Marketing Associate Job at Response Inc.

 ...creative, innovative, and solution-oriented individual to join our Marketing and Sales Department. We are one of the fastest-growing and...  ...results in Marketing, Sales, and Brand Awareness. Our Full Time Direct Marketing Associate opportunity is perfect for someone entry-... 

Norman Regional Health System

Registered Nurse (RN) I - Surgery Circulator - Heart Team Job at Norman Regional Health System

 ...the largest hybrid operating room in the state of Oklahoma. Our nurses demonstrate professionalism, teamwork, autonomy, and critical...  ...each area. Upon completion of orientation, nurses will be able to circulate cardiothoracic and vascular cases as well as a wide variety of...