Redshift Architect Senior Manager

Remote • Posted 6 hours ago • Updated 6 hours ago
Full Time
Remote
$180,000 - $190,000/yr
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Amazon Redshift
  • Amazon Web Services
  • Analytical Skill
  • Data Compression
  • Data Engineering
  • Data Link Layer
  • Data Modeling
  • Data Warehouse
  • Dimensional Modeling
  • Distribution
  • ELT
  • Extract
  • Transform
  • Load
  • Management
  • Modeling
  • Optimization
  • Performance Tuning
  • Query Optimization
  • Reporting
  • SQL
  • Snow Flake Schema
  • Spectrum
  • Star Schema
  • Stored Procedures
  • WLM

Summary

Job title:- Redshift Architect Senior Manager L2

Location: 100% Remote

FTE role
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.

Self - Rating Template must be filled out and sent during profile submission

Skills

Self-Rating(1-5)

Amazon Redshift

Data Modeling

SQL

__________________________________________________________

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10114281
  • Position Id: 9106249
  • Posted 6 hours ago
Contact the job poster
JK

Jatin Kumar

Recruiter @ Alltech Consulting Services, Inc.
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Remote

•

Today

Easy Apply

Full-time, Third Party

Depends on Experience

Remote or Memphis, Tennessee

•

Today

Full-time

USD 97,725.00 - 162,875.00 per year

Remote or Arlington, Virginia

•

Today

Full-time

USD 98,500.00 - 206,800.00 per year

Remote or Virginia

•

Today

Full-time

USD 129,813.00 - 149,500.00 per year

Search all similar jobs