🚀 Senior Data Engineer (Amazon Redshift) | 90-Day contract (extension possible)

This is an exciting opportunity for an experienced Data Engineer with strong expertise in Amazon Redshift, SQL, and AWS to help improve the reliability, quality, and performance of large-scale data platforms supporting critical public sector systems.

If you enjoy solving complex production data challenges, optimizing cloud data warehouses, and building scalable data quality solutions, we'd love to hear from you.

As a Senior Data Engineer, you will:

• →Design, optimize, and maintain Amazon Redshift data warehouses and reporting environments.
• →Build and optimize ETL/ELT pipelines using AWS services and Python.
• →Develop scalable SQL solutions for reporting, analytics, and operational data processing.
• →Improve data quality, validation, reconciliation, and integrity across multiple systems.
• →Investigate and resolve complex production data issues.
• →Optimize Redshift performance, storage, and query execution.
• →Build automated data quality controls and monitoring solutions.
• →Improve data synchronization and integration reliability.
• →Collaborate with Software Engineers, QA, Product, and Client Services teams.
• →Participate in architecture discussions and technical design reviews.
• →Support cloud-native data engineering best practices and continuous improvement initiatives.

• 8+ years of experience as a Data Engineer, Database Engineer, or Data Architect.
• Strong hands-on experience with Amazon Redshift (architecture, administration, optimization, and performance tuning).
• Advanced SQL expertise.
• Experience with PostgreSQL or Amazon Aurora PostgreSQL.
• Strong Python programming skills.
• Experience building ETL/ELT pipelines.
• Experience with AWS cloud services.
• Experience troubleshooting production data issues.
• Experience designing data validation, reconciliation, and data quality solutions.
• Strong analytical and problem-solving skills.
• Excellent communication skills in English.

• Experience with dbt, Great Expectations, Soda, or similar data quality frameworks.
• Experience implementing data observability and monitoring solutions.
• CI/CD experience (Azure DevOps or similar).
• Experience working in highly regulated environments.
• Government or public sector technology experience.

• Amazon Redshift  
• AWS
• PostgreSQL / Aurora PostgreSQL
• Python
• SQL
• ETL / ELT
• Data Quality
• Data Validation  
• Data Reconciliation
• Data Warehousing
• Data Observability

✔ Has deep expertise in Amazon Redshift (this is the primary technology for the role)

✔ Enjoys solving complex production data challenges

✔ Is passionate about data quality and reliability

✔ Can communicate effectively with international teams in English

✔ Thrives in cloud-native environments