Data Architect AWS REDSHIFT
Remote • Posted 30+ days ago • Updated 30+ days agoContract W2
Contract Independent
Contract Corp To Corp
No Travel Required
Remote
Depends on Experience
Arsoo technologies LLC
Fitment
Dice Job Match Score™
🧠 Analyzing your skills...
Job Details
Skills
- AWS
- Redshift
- Data Architect
Summary
Job Title: AWS Redshift Data Architect
Location: Remote
Type: Contract
Duration: Long Term
Role Overview
As a Redshift Data Architect, you will be the primary designer and strategist for our cloud data warehousing environment. You will lead the transition from traditional data structures to high-performance, petabyte-scale architectures. Your goal is to ensure our data infrastructure is optimized for performance, security, and cost while empowering our BI and Data Science teams with seamless access to high-quality data.
Key Responsibilities
- Architectural Design: Lead the design and implementation of end-to-end data architectures using Amazon Redshift (Provisioned and Serverless).
- Performance Tuning: Optimize query performance through expert-level management of distribution styles, sort keys, and workload management (WLM).
- Data Modeling: Develop robust data models (Star Schema, Snowflake, Data Vault) tailored for OLAP workloads.
- ETL/ELT Oversight: Design scalable data ingestion pipelines using AWS Glue, Amazon Kinesis, and Amazon S3.
- Modern Features: Implement advanced Redshift features such as Data Sharing, Spectrum, and Aurora Zero-ETL integration.
- Cost Management: Monitor and optimize AWS spend by right-sizing clusters and leveraging Reserved Instances or Serverless scaling.
- Governance & Security: Ensure data encryption (at rest and in transit), IAM role integration, and compliance with data privacy regulations (GDPR, CCPA).
Required Qualifications
- Experience: 8+ years in Data Architecture, with at least 4+ years focused specifically on AWS Redshift.
- Core Skills: Mastery of SQL, Python, and AWS CLI.
- AWS Ecosystem: Hands-on experience with S3, Lambda, IAM, CloudWatch, and AWS Glue.
- Database Theory: Deep understanding of columnar storage, MPP (Massively Parallel Processing) architecture, and concurrency scaling.
- Education: Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
Preferred Skills
- AWS Certified Data Engineer – Associate or AWS Certified Solutions Architect – Professional.
- Experience with Infrastructure as Code (Terraform or AWS CloudFormation).
- Experience migrating on-premise warehouses (e.g., Teradata, Netezza, Oracle) to AWS Redshift.
- Knowledge of BI tools like Tableau, QuickSight, or Power BI.
Technical Environment
- Storage: Amazon S3 (Data Lake)
- Compute: Amazon Redshift, AWS Lambda
- Orchestration: Apache Airflow or AWS Step Functions
- Security: AWS Lake Formation, KMS, IAM
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: 91132344
- Position Id: 8849548
- Posted 30+ days ago
Company Info
About Arsoo technologies LLC
Technical Experience
We are well-versed in a variety of technologies, operating systems, networks, and databases. We work with just about any technology that a business would encounter. We use this expertise to help customers of all different sizes.
BOOK ONLINE
High ROI
Do you spend most of your IT budget on maintaining your current system? Many companies find that constant maintenance eats into their budget for new technology. By outsourcing your IT management to us, you can focus on what you do best--running your business.
SEE SERVICES
Satisfaction Guaranteed
The world of technology can be fast-paced and scary. That's why our goal is to provide an experience that is tailored to your company's needs. No matter the budget, we pride ourselves on providing professional IT services. We guarantee you will be satisfied with our work.
We are well-versed in a variety of technologies, operating systems, networks, and databases. We work with just about any technology that a business would encounter. We use this expertise to help customers of all different sizes.
BOOK ONLINE
High ROI
Do you spend most of your IT budget on maintaining your current system? Many companies find that constant maintenance eats into their budget for new technology. By outsourcing your IT management to us, you can focus on what you do best--running your business.
SEE SERVICES
Satisfaction Guaranteed
The world of technology can be fast-paced and scary. That's why our goal is to provide an experience that is tailored to your company's needs. No matter the budget, we pride ourselves on providing professional IT services. We guarantee you will be satisfied with our work.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs