remote
AWS Redshift Data Architect - CitiusTech
Software Engineer
Senior data architect focused on AWS Redshift, driving performance tuning, spectrum integration, and data migration while managing governance and stakeholder communication.
About the role
Key Responsibilities
- Design, implement, and optimize AWS Redshift data warehouses, including RA3 nodes and concurrency scaling.
- Lead schema conversion and data migration projects using SCT and other migration tools.
- Develop and maintain SQL performance tuning, workload management, and query optimization strategies.
- Integrate Redshift with S3, DataZone, IAM, CloudWatch, and CloudTrail for secure, compliant data pipelines.
- Collaborate with BI teams to deliver Tableau dashboards and ensure data quality.
- Establish data governance, cataloging, and metadata management practices across the organization.
Requirements
- Minimum 3 years of hands‑on experience with AWS Redshift and its internals.
- Proficiency in SQL, ETL tools (DataStage, Alteryx), and BI tools (Tableau).
- Strong understanding of AWS services such as S3, IAM, CloudWatch, and CloudTrail.
- Experience with data governance, cataloging, and metadata management.
- Excellent communication and stakeholder management skills.