Senior Data Engineer (SQL, Python, Redshift, AWS)

Location: Remote

Duration: Long-term contract

We are seeking a Senior Data Engineer with strong expertise in SQL, Python, Amazon Redshift, and AWS data technologies. The ideal candidate will have experience working with large-scale datasets, complex reporting systems, data quality validation, and performance optimization.

This role will focus on building data quality frameworks, troubleshooting data issues, creating automated validation processes, and supporting critical business reporting and analytics.

Must-have skills

• 10+ years of Data Engineering / Data Analytics experience
• Expert-level SQL (complex queries, joins, CTEs, window functions, optimization)
• Strong Python for data analysis and automation
• Extensive experience with Amazon Redshift
• Experience with materialized views and query performance tuning
• Experience handling large datasets and reporting platforms
• Strong knowledge of data validation, reconciliation, and data quality processes
• AWS experience with S3 and Glue
• Experience with Tableau and/or QuickSight
• Excellent communication and stakeholder collaboration skills

Preferred skills

• AWS Athena
• AWS Lambda
• SNS/SQS
• Apache Spark
• AI tools such as GitHub Copilot, Amazon Q, Claude, Google Cloud AI, or Tableau AI
• Agile/Scrum experience

Key responsibilities

• Write and optimize complex SQL queries for reporting and analytics
• Build automated data quality checks and validation frameworks
• Monitor data pipelines and investigate data issues
• Perform root cause analysis and remediation
• Optimize Redshift performance and materialized views
• Develop Python automation scripts for data validation
• Collaborate with architects, engineers, analysts, and business teams
• Document data quality rules, lineage, and validation processes

Technical stack

• SQL
• Python
• Amazon Redshift
• AWS S3
• AWS Glue
• Athena
• Tableau
• QuickSight
• Apache Spark
• Git
• CI/CD