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

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

Terumo Medical Corporation

Professional and Clinical Trainer Job at Terumo Medical Corporation

 ...Job Summary: In this fast paced and critical role, Professional and Clinical Trainer will deliver training associates within Terumo Interventional Systems (TIS). This role is responsible for the delivery and facilitation of product and clinical training curriculums... 

GolfJobs

Director of Golf Job at GolfJobs

Share this job:Director ofGolf18 February 2025Category: Director of Golf JobsCountry: USAState: New YorkApply for this job.Click the button below to apply for this job.Apply NowAlready have an account? Log in firstDirector of GolfGolf Course... 

Addison Group

Marketing Specialist Job at Addison Group

 ...Position Title: Marketing Specialist Remote/Onsite: Fully onsite, 5 days per week in Columbia, TN Requested Start Date: ASAP Pay Rate...  ...of a team. ~ Experience with social media platforms, email marketing, and basic graphic design tools is a plus.... 

Columbia University

Security Officer | Columbia University Job at Columbia University

 ...Job Type: Support Staff - Union Bargaining Unit: TWU - Security Regular/Temporary: Regular Hours Per Week: 40 Salary Range...  ...specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible... 

CEDIA

Meetings & Events Planner Job at CEDIA

Job Description Job Title: Meetings & Events Planner Department: Operations Reports to: Director of Meetings & Events FLSA Status: Exempt Location: Remote - Must be located in the Indianapolis Area ABOUT CEDIA CEDIA is the association for smart...