Job Description Summary

This position is responsible for building, managing, and supporting our fleet of AWS Redshift data warehouse environments. This role designs, implements, and optimizes data architectures and cluster topologies that enable and support a variety data warehousing, analytics, and reporting workloads.

Job Description

Roles and Responsibilities: 

In this role you will: 

• Leverage expertise in Amazon Redshift to design, deploy, and maintain our fleet of clusters, tuning the environments to optimize query performance, effectively manage resources, and implement best practices for data storage, retrieval, and processing. 

•  Manage data access policies and practices for our AWS Redshift Fleet, ensuring compliance with regulations like CMMC, DFARS, ITAR, NIST 800-171). 

•  Monitor and optimize the performance of the data platform, including tuning Redshift queries, implementing best practices for data partitioning, compression, and caching, and utilizing tools like Amazon Redshift Advisor. 

•  Document data architectures, data flows, standards, and best practices to ensure consistency and facilitate knowledge sharing across teams. 

•  Configure monitoring and logging systems to track platform performance, troubleshoot issues, and respond to incidents promptly. 

•  Anticipate, track and advise management on risks and opportunities pertaining to trade-offs between performance and cost 

•  Stay abreast of the latest technologies, architecture trends, and management best practices pertaining to analytical data storage. 
• Assist with monitoring, tracking and forecasting of cloud costs across the Data Warehouse  

 

Minimum Qualifications: 

• Bachelor's Degree in Computer Science or “STEM” Majors (Science, Technology, Engineering and Math) with a minimum of 6 years of experience in cloud & database storage technologies such as AWS RedShift
• Minimum 4 years experience with database technology and minimum 3 years of experience on AWS or equivalent cloud technologies

Eligibility Requirement:

• Legal authorization to work in the U.S. is required. We will not sponsor individuals for employment visas, now or in the future, for this job.

 

 

Desired Characteristics: 

Technical Expertise:  

• Direct experience with provisioning, managing AWS Redshift or other cloud-native data warehouse-like solutions 

•  Experience with MPP data architecture and performance optimizations 

•  Experience / Familiarity with other AWS data services such as S3, Glue, Athena, Lambda, and DynamoDB 

•  Experience with Infrastructure as Code (IaC) tools like CloudFormation or Terraform 

•  Experience with designing and implementing security policies in AWS (IAM, resource policies, roles) 

•  Familiarity with the operation and support of workloads from data visualization platforms 

•  AWS certifications (e.g., AWS Certified Data Analytics, AWS Certified Solutions Architect). 

•  Familiarity with ITIL service management practices, including Incident Management, Change management, Problem management, availability management 

 

 Business Acumen:  

• Adept at navigating the