Senior AWS Redshift Data Engineer - Remote

Overview

We are looking for a seasoned Data Engineer to join our Engineering organization and take ownership of the systems that power our data-driven decisions. You will architect and maintain high-performance data pipelines and databases across platforms like MSSQL, Redshift, and Snowflake, ensuring data is reliable, accessible, and optimized for scale.

In Short

• Design and maintain scalable, efficient, and well-partitioned schemas in MSSQL, Redshift, and Snowflake.
• Architect and optimize complex queries, stored procedures, indexing strategies, and partitioning for large datasets.
• Build, monitor, and maintain data pipelines that ensure timely and accurate delivery of data to internal and external consumers.
• Own and enforce data refresh SLAs, ensuring availability, consistency, and reliability across production and reporting environments.
• Collaborate with software engineers, analysts, and DevOps teams to ensure data models and queries align with product and reporting requirements.
• Proactively identify and remediate performance bottlenecks, slow queries, and data inconsistencies.
• Implement and manage database change workflows using schema migration/versioning tools.
• Define and promote best practices for data access, security, compliance, and observability.

Requirements

• 7+ years of experience in database engineering or backend systems development.
• Deep expertise with MySQL, Amazon Redshift, and Snowflake, including schema design and performance optimization.
• Design, build, and maintain scalable data pipelines and ETL processes tailored to client needs.
• Proven track record maintaining data freshness SLAs and data quality across production pipelines.
• Hands-on experience with T-SQL, LinkSQL, query optimization, and indexing strategies.
• Experience with relational data modeling and schema versioning in support of software development.
• Familiarity with source control systems (e.g., Git/Bitbucket) and CI/CD integration.
• Strong problem-solving skills are desirable.

Benefits

• Work with a fast-growing global data engineering team.
• Opportunity to learn and grow in advanced cloud and analytics technologies.
• Competitive salary and performance-based incentives.
• A collaborative and innovation-driven work environment.