Redshift Architect Senior Manager
2 days ago
United States
SoftPath Technologies LLC
Full-time
Free with email or Google
Save this job and keep your search organized
Create a free account to save jobs, create alerts and return to this listing from your dashboard.
Free with email or Google
By continuing, you agree to our Terms & Privacy Policy.
Redshift Architect Senior Manager L2 (C2)
Remote role
Fulltime position
Design, develop, and maintain enterprise-scale data warehouse solutions using Amazon Redshift. Create and manage logical, conceptual, and physical data models for analytical and reporting platforms. Develop complex SQL queries, stored procedures, views, and ETL/ELT transformations for large-scale datasets. Perform Redshift performance tuning and optimization including: Query performance tuning. Distribution key and sort key optimization Workload Management (WLM) configuration Vacuum, Analyze, Compression encoding strategies Spectrum optimization Materialized views implementation Design and implement scalable data ingestion and transformation pipelines using AWS services. Work closely with business stakeholders, architects, analysts, and development teams to understand data requirements and translate them into technical solutions.
Technical Skills:
- Need 10+ years of experience in Data Warehousing and Data Engineering.
- 5+ years of hands-on experience with Amazon Redshift.
- Strong expertise in Data Modeling: Dimensional Modeling (Star Schema and Snowflake Schema)
- Data Vault Modeling: Normalized and Denormalized Data Models
- Advanced proficiency in SQL and query optimization.
-
Strong experience in Redshift performance tuning and optimization.