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

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

Tech Army, LLC

Public Health Analyst (Data Analytics) Job at Tech Army, LLC

 ...this agreement must possess the following minimum qualifications and experience: 1.1. 1 year experience working with department's Data Modernization Workforce Development Team; 1.2. 3-5 years' experience performing enterprise-wide assessments regarding data... 

Opportunities Industrialization Centers

Clinical Medical Assistant Job at Opportunities Industrialization Centers

 ...JOB TITLE : Clinical Medical Assistant (CMA) DEPARTMENT : Integrated Health Services FLSA : Full-Time; Hourly/Non-Exempt DURATION : OPEN Until Filled HIRING RANGE : $16.00/hour to $20.00 per hour POSITION PURPOSE The Clinical Medical Assistant (... 

Colorado High School Charter

HIGH SCHOOL SPECIAL EDUCATION COORDINATOR Job at Colorado High School Charter

 ...Special Education Coordinator Colorado High School Charter is seeking a Special Education Coordinator. The Special Education Coordinator at Colorado High School Charter GES is responsible for overseeing the implementation of special education services for students with... 

Hook & Reel Cajun Seafood Restaurant & Bar

Restaurant Regional Manager Job at Hook & Reel Cajun Seafood Restaurant & Bar

 ...Regional Manager (MI) Job Type: Full-time | Pay: $100,000.00 - $110,000.00 YR | Location : Michigan, Multiple Locations About the Role: Hook & Reel is seeking a proactive and experienced Regional Manager to oversee and optimize the operations of multiple... 

Management Recruiters of Arkansas

Process Engineer Job at Management Recruiters of Arkansas

 ...PROCESS ENGINEER - Plastic Injection Molding Benton, AR Our client is a very well-established Global Manufacturing Company and their Central Arkansas plant is growing. In this role, youll interact with colleagues around the globe and have international exposure....