| Sr. AWS | Redshift Data Engineer || Need Local candidate Illinois || F2F interview || at Remote, Remote, USA |
| Email: [email protected] |
|
From: shivani sharma, adventatech [email protected] Reply to: [email protected] Job Description - Title: Sr. AWS / Redshift Data Engineer Date Posted: 02/11/2025 Job Type: Contract for Hire Job Job Location: Northfield Illinois Any visa Need Local only , 1 day a week to onsite Job Description: is in need of a Sr. AWS Redshift Data Engineer with at least 5 years of experience for a 6-month contract-for-hire with our client in the north suburbs. Individual will need to be local and able to work onsite at the Northfield location 1 day per week. The ideal candidate will have experience developing and optimizing Amazon Redshift-based Enterprise Data Warehouse (EDW) solutions. 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 business intelligence/ data visualization tools (Power BI, Tableau, AWS QuickSight, etc.). Prior experience using ServiceNow for building, configuring, and testing new releases. Understanding of database optimization techniques (e.g., indexing and query optimization). Keywords: business intelligence sthree Sr. AWS | Redshift Data Engineer || Need Local candidate Illinois || F2F interview || [email protected] |
| [email protected] View All |
| 09:57 PM 13-Feb-25 |