What are the responsibilities and job description for the Data Engineer (AWS/ Redshift/ S3) - CFH - Northbrook, IL position at Resource 1?
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 , 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 :
Technical Skills :
AWS Redshift, EDW (Enterprise Data Warehouse), AWS S3, SQL, Tableau, Power BI, PostgreSQL, ETL Development, Queries, Stored Procedures, ServiceNow, Oracle and Jitterbit.
