ZipRecruiter

Log In

1

Amazon Redshift Jobs in Connecticut (NOW HIRING)

R2 Technologies Corporation

Data Architect

Hartford, CT · On-site

$64.25 - $82.75/hr

Talend,PySpark,Amazon Redshift,ETL,ELT,Kafka,Apache Spark,Java,NoSQL,AWS EMR.,data pipeline,Apache NiFI,Kylo,Scripting,Power BI,Tableau,Qlik,data ingestion,wrangling,cleansing,Advanced SQL,SQL,Python ...

Synchrony Financial

AVP, Senior Data Engineer

Stamford, CT · On-site

$113K - $153K/yr

Responsible fordesign, development, testing oversight, and production implementationusingonprem RDBMS platforms,Ab Initio,SQL, andAWS (Amazon Redshift). * Lead the technical team to ensure ...

HomeServe

Principal Data Architect and Engineer

Norwalk, CT · On-site

$125K - $167K/yr

Design, implement, and optimize batch and real-time data processing solutions leveraging AWS Glue, Lambda, Apache Iceberg (Amazon S3 Tables), Redshift, and related cloud-native services. * Manage and ...

Net2Source (N2S)

Senior Database Manager

Stamford, CT · On-site

$53 - $73/hr

Oracle (including Autonomous Database), PostgreSQL, Amazon Redshift, Sybase, IBM DB2, Snowflake, MongoDB, MySQL, Microsoft SQL Server, and other enterprise database technologies as required.

All JobsAmazon Redshift JobsAmazon Redshift Jobs in Connecticut

Amazon Redshift information

See Connecticut salary details

$27

$54

$75

How much do amazon redshift jobs pay per hour?

As of Jul 17, 2026, the average hourly pay for amazon redshift in Connecticut is $54.27, according to ZipRecruiter salary data. Most workers in this role earn between $46.63 and $60.58 per hour, depending on experience, location, and employer.

What is the difference between Amazon Redshift vs Data Warehouse Engineer?

AspectAmazon RedshiftData Warehouse Engineer
Primary RoleCloud-based data warehousing service for analyticsDesigning, building, and maintaining data warehouses and ETL processes
Required SkillsSQL, cloud computing, data modeling, AWS servicesSQL, data modeling, ETL tools, database management
Work EnvironmentCloud platforms, AWS ecosystemOn-premises or cloud data warehouse environments
CertificationsAWS certifications, SQL knowledgeData management certifications, SQL expertise

Amazon Redshift is a cloud-based data warehousing service focused on providing scalable analytics within the AWS ecosystem. In contrast, a Data Warehouse Engineer designs and maintains data warehouses, often working with various tools and environments. While both roles require SQL and data modeling skills, Redshift specialists focus on cloud infrastructure, whereas Data Warehouse Engineers handle broader data architecture tasks across different platforms.

What AWS jobs are in high demand?

AWS-related roles such as Cloud Engineer, Solutions Architect, DevOps Engineer, and Cloud Security Specialist are in high demand. These positions often require skills in cloud infrastructure, scripting, and certifications like AWS Certified Solutions Architect or AWS Certified DevOps Engineer.

What does Amazon Redshift do?

Amazon Redshift is a data warehousing service that allows organizations to store and analyze large volumes of structured data efficiently. It enables fast query performance using columnar storage and parallel processing, making it suitable for business intelligence and analytics tasks. Data analysts and database administrators often use Redshift to support data-driven decision-making.

What skills are needed for Redshift?

Amazon Redshift professionals need strong skills in SQL, data warehousing concepts, and database management. Familiarity with cloud computing, ETL processes, and tools like AWS services is also important, along with knowledge of performance optimization and security best practices.

What are the key skills and qualifications needed to thrive as an Amazon Redshift Developer, and why are they important?

To thrive as an Amazon Redshift Developer, you need strong SQL expertise, experience with data warehousing concepts, and a background in computer science or related fields. Familiarity with AWS services (especially Redshift), ETL tools, and relevant certifications like AWS Certified Data Analytics are typically required. Problem-solving, attention to detail, and effective communication are standout soft skills in this role. These skills enable efficient data pipeline development, ensure data integrity, and support collaboration for optimized analytics solutions.

What are some common challenges faced by Amazon Redshift administrators and how can they be addressed?

Amazon Redshift administrators often encounter challenges such as optimizing query performance, managing data loads, and ensuring data security. Performance tuning requires careful management of distribution styles, sort keys, and regular vacuuming to maintain efficiency. Handling large-scale data loads can be addressed by using COPY commands and leveraging parallel processing. Collaboration with data engineers and analysts is essential to understand data usage patterns and set up appropriate monitoring and alerting. Continuous learning and staying updated with AWS enhancements can help administrators proactively resolve issues and optimize the data warehouse environment.

What is Amazon Redshift?

Amazon Redshift is a fully managed, cloud-based data warehouse service provided by Amazon Web Services (AWS). It is designed to handle large-scale data analytics and can process petabytes of structured and semi-structured data quickly and efficiently. Redshift uses SQL to query data and integrates seamlessly with various business intelligence tools, making it a popular choice for organizations looking to analyze big data. Its architecture is based on columnar storage and massively parallel processing (MPP), which enables high performance and scalability.

What companies use Amazon Redshift?

Many large organizations across various industries use Amazon Redshift for data warehousing and analytics, including companies in finance, retail, healthcare, and technology. These companies leverage Redshift's scalability and integration with AWS services to manage large datasets and support business intelligence efforts.
What are popular job titles related to Amazon Redshift jobs in Connecticut? For Amazon Redshift jobs in Connecticut, the most frequently searched job titles are:
What job categories do people searching Amazon Redshift jobs in Connecticut look for? The top searched job categories for Amazon Redshift jobs in Connecticut are:
Amazon Redshift jobs near you
Infographic showing various Amazon Redshift job openings in Connecticut as of July 2026, with employment types broken down into 88% Full Time, 10% Part Time, and 2% Contract. Highlights an 88% Physical, 3% Hybrid, and 9% Remote job distribution, with an average salary of $112,879 per year, or $54.3 per hour.
Data Architect

Data Architect

R2 Technologies Corporation

Hartford, CT • On-site

$64.25 - $82.75/hr

Full-time

Re-posted 13 days ago

Job description

Overview:
Position: Data Architect
Location: Hartford, CT (Remote right now)
Duration: 12+Months
Mandatory Skills: Talend, PySpark, Redshift
Job Description
Responsibilities:
Translating data and technology requirements into our ETL / ELT architecture.
Develop real-time and batch data ingestion and stream-analytic solutions leveraging technologies such as Kafka, Apache Spark, Java, NoSQL DBs, AWS EMR.
Develop data driven solutions utilizing current and next generation technologies to meet evolving business needs.
Develop custom cloud-based data pipeline.
Provide support for deployed data applications and analytical models by identifying data problems and guiding issue resolution with partner data engineers and source data providers.
Provide subject matter expertise in the analysis, preparation of specifications and plans for the development of data processes.
Qualifications:
Strong experience in data ingestion, gathering, wrangling and cleansing tools such as Apache NiFI, Kylo, Scripting, Power BI, Tableau and/or Qlik
Experience with data modeling, data architecture design and leveraging large-scale data ingest from complex data sources
Experience building and optimizing 'big data' data pipelines, architectures and data sets.
Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Strong knowledge of analysis tools such as Python, R, Spark or SAS, Shell scripting, R/Spark on Hadoop or Cassandra preferred.
Strong knowledge of data pipelining software e.g., Talend, Informatica
Skills:
Talend,PySpark,Amazon Redshift,ETL,ELT,Kafka,Apache Spark,Java,NoSQL,AWS EMR.,data pipeline,Apache NiFI,Kylo,Scripting,Power BI,Tableau,Qlik,data ingestion,wrangling,cleansing,Advanced SQL,SQL,Python,Hadoop,Cassandra,R/Spark,Informatica

Apply