RedShift Data Engineer

Location: Alpharetta, GA || Cincinnati, OH (Hybrid 2-3 days a week) Duration: Full Time Job Summary: Lead the design, implementation, and administration of Redshift data warehouses, including cluster setup, schema design, and table management. Architect and optimize ETL/ELT pipelines using Talend for batch processing and HVR for real-time replication and CDC. Develop, maintain, and optimize BI dashboards and reporting using Spotfire. Write, review, and optimize complex SQL queries for analytics, reporting, and ETL transformations. Monitor and enhance Redshift performance: query tuning, distribution/sort key optimization, concurrency scaling, and workload management. Integrate Redshift with AWS services: S3, Glue, Lambda, Redshift Spectrum, and IAM roles. Implement DevOps practices: CI/CD pipelines for ETL workflows, automated deployments, version control, and testing. Ensure data security, backup, recovery, and compliance for Redshift environments. Collaborate with enterprise architects, business stakeholders, and analytics teams to define best practices, data architecture, and roadmap. Mentor and guide junior and mid-level engineers, promoting best practices in data engineering, cloud architecture, and DevOps. Contribute to strategic initiatives, including platform optimization, cost efficiency, and migration projects. Primary Skills 1 Required: Advanced - Professional with high knowledge, significant ability and hands‑on experience. Can provide supervision to others in AWS Redshift Primary Skill 2 Required: Experienced & Practioner with Basic knowledge with demonstrated hands‑on experience. Requires no / minimal supervision in AWS Glue, Talend, HVR and S3 Secondary Skill 1 Required: Experienced & Practioner with Basic knowledge with demonstrated hands‑on experience. Requires no / minimal supervision in Spotfire Secondary Skill 2 Required: Experienced & Practioner with Basic knowledge with demonstrated hands‑on experience. Requires no / minimal supervision in AWS and Devops CI/CD Qualification: Minimum Educational Qualification required : Engineer - B.E / B.Tech / MCA Mandatory Certification required : Azure Database Administrator Associate Engineer - B.E / B.Tech / MCA Required :Engineer - B.E / B.Tech / MCA Seniority level Mid-Senior level Employment type Full-time Job function Information Technology Industries Staffing and Recruiting #J-18808-Ljbffr