Redshift Developer

pro17analytics

5-7 Years

Not Disclosed

India

Early Applicant

Posted 2 months ago

Be among the first 10 applicants

Job Description

Company Description

Pro17Analytics is an IT solution company that caters to a global clientele by offering deep IT consulting expertise and IT best practices. With a customer-centric focus, we provide high-end consulting services backed by a talented team of IT consultants. Our successful project executions span across various industries.

Job Title: Redshift Developer

Experience: 5+ Years

Location: [Specify Location / Remote]

Job Type: [Full-Time / Contract / Hybrid]

Job Summary:

We are seeking a skilled and experienced Redshift Developer with at least 5 years of hands-on experience in Amazon Redshift and a strong command of SQL. The ideal candidate will be responsible for designing, developing, and optimizing data solutions using Redshift, ensuring high performance and reliability. This role involves collaborating with data engineers, analysts, and business teams to deliver scalable data solutions.

Key Responsibilities:

Design, develop, and maintain data models, ETL pipelines, and data marts in Amazon Redshift.
Write complex and optimized SQL queries for data extraction, transformation, and loading.
Monitor and improve Redshift performance, including distribution styles, sort keys, and query tuning.
Implement data validation and data quality checks to ensure accuracy and consistency.
Collaborate with data engineers and analysts to gather requirements and deliver effective solutions.
Ensure data security, governance, and compliance in Redshift.
Troubleshoot and resolve performance issues and bugs in data pipelines.
Document data flows, models, and ETL processes.

Required Skills & Qualifications:

5+ years of hands-on experience with Amazon Redshift.
Strong expertise in SQL, including writing complex joins, window functions, and query optimization.
Experience with Redshift-specific performance tuning techniques (e.g., distribution/sort keys).
Proficiency in designing and developing ETL workflows using tools like AWS Glue, Python, or other ETL tools.
Understanding of data warehousing concepts, dimensional modeling, and OLAP.
Familiarity with cloud ecosystems (especially AWS) and services such as S3, Lambda, and Glue.
Excellent analytical and problem-solving skills.
Good communication and documentation skills.

Preferred Qualifications: