Job Description

Resource 1 is in need of a Sr. Redshift EDW Developer 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 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, etc.).
• Prior experience using ServiceNow for building, configuring, and testing new releases.
• Understanding of database optimization techniques (e.g., indexing and query optimization).

Medical insurance and a 401(k) plan is offered to all eligible W2 employees during the contract phase.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

• Dice Id: rone
• Position Id: 8542203

Job Tags

Similar Jobs