ZipRecruiter

Log In

1

Redshift Jobs in Washington (NOW HIRING)

E Logic

Database Developer/Administrator

Washington, DC · On-site

$100K/yr

Administer and develop for Amazon Redshift (RA3 nodes) and Amazon PostgreSQL databases within a FedRAMP High pre-production and production framework. * Build, optimize, and maintain complex ...

Samprasoft

Senior Java AWS Developer

Washington, DC · On-site

$64.75 - $82.75/hr

This role demands expertise in Java coding coupled with AWS cloud development, encompassing technologies like Spring Boot, Lambda, Kinesis, DynamoDB/Aurora, and Redshift. The ideal candidate will ...

Agelix Consulting

Databricks SME

Washington, DC · On-site

$63.25 - $84.50/hr

Design and implement secure integration patterns between Databricks and AWS services (e.g., S3, IAM, Glue, Redshift). * Perform specialized operations including Delta Lake management, Unity Catalog ...

Meta Force Technology Staffing LLC

Python Developer

Reston, VA · On-site

$52.25 - $72/hr

RDS database, Redshift, S3 * Bedrock used for use cases * Very strong database experience * R programming would be a big plus Job Requirement • Work with product owners and other development team ...

Ekcel Technologies Inc

Sr AWS Python Developer

Reston, VA · On-site

$126K - $170K/yr

Design and optimize data storage and querying in Amazon Redshift * Write performant SQL for data transformations, validation, and reporting * Ensure data quality, monitoring, error handling and ...

Meta Force Technology Staffing LLC

Data Modeler

Reston, VA · On-site

$57 - $73.75/hr

Candidates should be well-versed in both relational and dimensional modeling, with experience in AWS environments, specifically RDS and Redshift, and handling data migration projects involving ...

Sidram Technologies

AWS Data Engineer - w2

Reston, VA · On-site

$119K - $143K/yr

Design and optimize data storage and querying in Amazon Redshift * Write performant SQL for data transformations, validation, and reporting * Ensure data quality, monitoring, error handling, and ...

Sidram Technologies

AWS Data Engineer

Reston, VA · On-site

$119K - $143K/yr

Design and optimize data storage and querying in Amazon Redshift * Write performant SQL for data transformations, validation, and reporting * Ensure data quality, monitoring, error handling, and ...

next page

Showing results 1-20

People also search for

All JobsRedshift JobsRedshift Jobs in Washington

Redshift information

What jobs pay 500,000 a year in the US?

High-paying jobs that can reach or exceed $500,000 annually in the US include executive roles such as CEOs, CFOs, and other C-suite positions, as well as specialized professions like investment bankers, senior surgeons, and certain technology executives. These roles typically require extensive experience, advanced skills, and often involve leadership responsibilities or performance-based bonuses.

Is Redshift a good company to work for?

Redshift is a data warehousing service offered by Amazon Web Services, not a company employing individuals directly. If referring to a job role related to Redshift, such as a Redshift engineer, the work typically involves cloud computing, data management, and SQL skills. The work environment depends on the employer using Redshift, which can vary widely in company culture and benefits.

What are the key skills and qualifications needed to thrive in the Redshift position, and why are they important?

To thrive in a Redshift-focused role (such as an Amazon Redshift Database Administrator or Redshift Data Engineer), you need strong expertise in cloud data warehousing, SQL, ETL development, and data modeling, often backed by a degree in computer science or a related field. Proficiency with Amazon Web Services (AWS), specifically Redshift, as well as tools like Python, ETL platforms, and related AWS certifications are highly valuable. Effective communication, analytical thinking, and problem-solving skills enable you to translate business needs into scalable data solutions and collaborate with diverse teams. These skills are essential for ensuring data integrity, optimizing performance, and supporting strategic business decisions in a cloud-based data environment.

Does Redshift offer remote positions?

Redshift, as a data warehousing service, does not directly offer remote positions; however, companies that use Redshift for data analytics may have remote job opportunities depending on their policies. Data-related roles such as data engineers or analysts working with Redshift can often be performed remotely if the employer supports flexible work arrangements.

What is a Redshift job?

A Redshift job typically refers to a task or process involving Amazon Redshift, a cloud-based data warehousing service. This can include roles such as database administrators, data engineers, or analysts who work with Redshift to store, process, and analyze large datasets. Common responsibilities involve writing SQL queries, optimizing performance, managing clusters, and integrating Redshift with data pipelines.

What are some typical challenges faced by professionals working with Amazon Redshift, and how can I prepare for them?

Working with Amazon Redshift often involves optimizing large-scale data pipelines, troubleshooting performance bottlenecks, and ensuring data security in a cloud environment. It can be challenging to balance query speed with cost efficiency, especially as data volumes grow rapidly. Familiarity with Redshift best practices—such as schema design, compression techniques, and query optimization—will help you address these issues effectively. Proactively staying updated on AWS feature releases and participating in team knowledge sharing can also make problem-solving more efficient and collaborative.

What is redshift recruiting?

Redshift recruiting refers to the process of hiring professionals for roles related to Amazon Redshift, a data warehousing service. It often involves assessing skills in data management, SQL, and cloud computing, and may require familiarity with AWS tools and certifications.
What are popular job titles related to Redshift jobs in Washington? For Redshift jobs in Washington, the most frequently searched job titles are:
What job categories do people searching Redshift jobs in Washington look for? The top searched job categories for Redshift jobs in Washington are:
Redshift jobs near you

REDSHIFT Architrct with Redshift ML

Unisoft Technology Inc

Linthicum Heights, MD • On-site

Other

Posted 15 days ago

Job description

<>General Experience: The proposed candidate must have at least Fifteen (15) years of  total experience in data warehousing, with at least 3 years focused specifically on AWS Redshift.

Position Description: AWS Redshift Subject Matter Expert (SME) will be providing deep technical leadership, optimization, and strategic guidance for an organization''''''''s cloud data warehousing solutions, covering both Provisioned and Serverless deployments. This role requires a blend of hands-on technical skills, architectural oversight, and strong communication to ensure Redshift environments are scalable, cost-efficient, and highly performant.

1. Architectural & Strategic Leadership

  1. Solution Design: Architect, design, and implement scalable, secure, and cost-effective data warehousing solutions using both Redshift Provisioned and Redshift Serverless.
  2. Deployment Strategy: Determine the optimal deployment model (Provisioned vs. Serverless) for various workloads, considering factors like predictability, cost, concurrency, and required fine-grained control.
  3. Modernization: Lead efforts to modernize existing on-premise or cloud data warehouses (e.g., Teradata, Snowflake, etc.) to AWS Redshift, including developing migration strategies and execution plans.
  4. Integration: Define and implement integration patterns with the broader AWS ecosystem, including Amazon S3 (for Redshift Spectrum/Data Lake), AWS Glue, Amazon Kinesis, Amazon EMR, and machine learning services (Redshift ML).

2. Performance and Optimization

  1. Query Tuning: Expertly analyze, optimize, and refactor complex SQL queries for maximum performance and cost efficiency, utilizing features like Workload Management (WLM) in Provisioned clusters and capacity settings in Serverless.
  2. Design Optimization: Tune data warehouse performance by implementing best practices for data distribution keys, sort keys, and compression encodings for both Provisioned nodes (RA3) and Serverless data.
  3. Monitoring and Troubleshooting: Establish and manage advanced monitoring using Amazon CloudWatch and Redshift system tables to preemptively identify and resolve performance bottlenecks, resource contention, and system failures.
  4. Cost Management: Implement effective cost controls, managing node types/reserved instances for Provisioned clusters and defining Redshift Processing Units (RPUs) capacity and usage limits for Serverless environments to ensure predictable spending.

3. Data Governance and Operations

  1. Security: Enforce enterprise-level data security, including implementing encryption (at rest and in transit), managing access control via AWS IAM and database user management, and configuring VPC endpoints.
  2. High Availability & Disaster Recovery (HA/DR): Define and implement backup/restore strategies using snapshots, cross-region replication, and leverage the inherent HA features of Redshift Serverless and Multi-AZ for Provisioned.
  3. Data Modeling & ETL/ELT: Advise on and implement best-practice data models (e.g., Dimensional, Data Vault) and design efficient Extract, Transform, and Load (ETL)/Extract, Load, and Transform (ELT) pipelines.

Category

Key Skills & Experience

AWS Redshift

Deep, hands-on experience with both Provisioned (RA3 nodes) and Serverless architectures.

Data Warehousing

Expert knowledge of data warehousing concepts, ETL/ELT methodologies, and dimensional modeling.

SQL Mastery

Advanced proficiency in complex SQL, DDL, and DML, with a focus on Redshift-specific commands (e.g., COPY, UNLOAD).

Performance Tuning

Query optimization, WLM configuration, distribution styles, sort keys, and understanding query execution plans.

AWS Ecosystem

Hands-on experience with core AWS services: S3, Glue, IAM, CloudWatch, Lambda, Lake Formation, and Kinesis.

Programming

Scripting/Automation skills using Python (for ETL/API interaction) or similar languages.

Education: This position requires a Bachelor’s in Computer Science, Information Systems, or a related field or equivalent work experience. (Note: A Master’s degree is preferred.)

  1. <>General Experience: The proposed candidate must have at least Fifteen (15) years of experience in data warehousing, with at least 3 years focused specifically on AWS Redshift.
  2. Certifications: AWS Certified Data Analytics - Specialty or AWS Certified Solutions Architect - Professional is highly desirable.
  3. Communication: Exceptional ability to communicate complex technical concepts to both technical teams and executive stakeholders.
  4. Mentorship: Act as a technical mentor for Data Engineers, Administrators, and Analysts.

Apply