AWS Redshift Admin

About Us

As an AWS Redshift Admin at Kenility, you’ll join a tight-knit family of creative developers, engineers, and designers, who strive to develop and deliver the highest quality products into the market.

About The Client

Our client is the world's largest utility company, specializing in wind and solar energy generation across America. They have made significant strides in promoting sustainable power solutions, harnessing the potential of wind and solar resources to produce clean and renewable electricity.

Technical Requirements

Expertise in administering, optimizing performance, and ensuring the smooth operation of large-scale RedShift environments, with data volumes exceeding 1PB
Demonstrated proficiency in utilizing the AWS technology stack, including S3, Redshift, Glue, Athena, or similar solutions. Familiarity with these technologies is highly desirable
Strong SQL and Unix skills with a proven track record of working with modern ETL/ELT frameworks
In-depth knowledge and experience in applying data warehouse best practices, such as conforming dimensions, slowly changing dimensions, star and snowflake schema
Skilled in developing data pipelines using industry-standard tools like Git and Jira
Proficient in programming and possessing data integration experience, particularly in Python (or other relevant scripting languages).
Experience handling and processing unstructured data formats like JSON, Parquet, and others
Proficiency in scripting languages (such as Python, R) and data visualization experience