Vantage Point Consulting Inc.
Data Warehouse Engineer (Amazon Redshift)
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Warehouse Engineer (Amazon Redshift) in Alpharetta, GA or Cincinnati, OH, offering a 12+ month contract at an unspecified pay rate. Requires 3-7 years of experience, strong SQL, and proficiency in AWS services.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
October 8, 2025
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Alpharetta, GA
-
🧠 - Skills detailed
#Athena #Informatica #Schema Design #AWS (Amazon Web Services) #Scripting #Talend #Snowflake #Lambda (AWS Lambda) #Cloud #Security #SQL (Structured Query Language) #Data Ingestion #Monitoring #Airflow #Databases #Complex Queries #AWS Glue #Data Warehouse #IAM (Identity and Access Management) #Amazon Redshift #Python #RDS (Amazon Relational Database Service) #Data Modeling #Data Quality #Data Engineering #"ETL (Extract #Transform #Load)" #BI (Business Intelligence) #Data Automation #Redshift #Data Security #Data Analysis #Data Architecture #Data Science #Compliance #Computer Science #S3 (Amazon Simple Storage Service) #Scala #Shell Scripting #Apache Airflow #Metadata #Data Governance #Automation
Role description
Job Title: Data Warehouse Engineer (Amazon Redshift)
Location: Alpharetta, GA || Cincinnati, OH (Hybrid 2-3 days a week)
Employment Type: 12+ Months Contract
Job Summary
We are seeking a highly skilled Data Warehouse Engineer with strong expertise in Amazon Redshift to design, develop, and maintain scalable data warehouse solutions. The ideal candidate will work closely with data analysts, data scientists, and business stakeholders to ensure efficient data availability, reliability, and performance across our analytics ecosystem.
Key Responsibilities
• Design, build, and optimize data warehouse architectures and ETL/ELT pipelines using Amazon Redshift and related AWS services (Glue, S3, Lambda, Athena, etc.).
• Develop and maintain data models, schemas, and metadata to support analytical and reporting needs.
• Implement and manage data ingestion workflows from various sources (databases, APIs, flat files, streaming data).
• Ensure data quality, consistency, and integrity across the warehouse and downstream systems.
• Optimize Redshift performance through query tuning, distribution/sort key management, and workload monitoring.
• Collaborate with data analysts and BI developers to support reporting, dashboards, and self-service analytics.
• Automate recurring data operations using Python, SQL, or AWS Glue jobs.
• Ensure data security, compliance, and governance practices are enforced within the warehouse environment.
• Participate in data architecture discussions, capacity planning, and technology evaluations for continuous improvement.
Required Qualifications
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 3–7 years of hands-on experience in data warehouse development and data engineering.
• Strong proficiency in Amazon Redshift (cluster setup, schema design, performance tuning, and maintenance).
• Advanced skills in SQL and experience writing complex queries, stored procedures, and ETL logic.
• Proficiency with ETL/ELT tools such as AWS Glue, Talend, Informatica, or Apache Airflow.
• Experience with AWS ecosystem (S3, Lambda, RDS, CloudWatch, IAM, etc.).
• Working knowledge of data modeling techniques (Star/Snowflake schemas, dimensional modeling).
• Familiarity with Python or Shell scripting for data automation.
• Strong understanding of data governance, security, and compliance principles.
Job Title: Data Warehouse Engineer (Amazon Redshift)
Location: Alpharetta, GA || Cincinnati, OH (Hybrid 2-3 days a week)
Employment Type: 12+ Months Contract
Job Summary
We are seeking a highly skilled Data Warehouse Engineer with strong expertise in Amazon Redshift to design, develop, and maintain scalable data warehouse solutions. The ideal candidate will work closely with data analysts, data scientists, and business stakeholders to ensure efficient data availability, reliability, and performance across our analytics ecosystem.
Key Responsibilities
• Design, build, and optimize data warehouse architectures and ETL/ELT pipelines using Amazon Redshift and related AWS services (Glue, S3, Lambda, Athena, etc.).
• Develop and maintain data models, schemas, and metadata to support analytical and reporting needs.
• Implement and manage data ingestion workflows from various sources (databases, APIs, flat files, streaming data).
• Ensure data quality, consistency, and integrity across the warehouse and downstream systems.
• Optimize Redshift performance through query tuning, distribution/sort key management, and workload monitoring.
• Collaborate with data analysts and BI developers to support reporting, dashboards, and self-service analytics.
• Automate recurring data operations using Python, SQL, or AWS Glue jobs.
• Ensure data security, compliance, and governance practices are enforced within the warehouse environment.
• Participate in data architecture discussions, capacity planning, and technology evaluations for continuous improvement.
Required Qualifications
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 3–7 years of hands-on experience in data warehouse development and data engineering.
• Strong proficiency in Amazon Redshift (cluster setup, schema design, performance tuning, and maintenance).
• Advanced skills in SQL and experience writing complex queries, stored procedures, and ETL logic.
• Proficiency with ETL/ELT tools such as AWS Glue, Talend, Informatica, or Apache Airflow.
• Experience with AWS ecosystem (S3, Lambda, RDS, CloudWatch, IAM, etc.).
• Working knowledge of data modeling techniques (Star/Snowflake schemas, dimensional modeling).
• Familiarity with Python or Shell scripting for data automation.
• Strong understanding of data governance, security, and compliance principles.
