🚀 Senior Data Engineer (Amazon Redshift) | 90-Day contract (extension possible)
Location: Remote (LATAM)
Employment Type: Full-time
Contract Type: Contractor Agreement
Compensation: Paid in USD
Language Requirement: Advanced English (written and spoken), English (native)
About the Opportunity
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.
What You'll Do
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.
Required Qualifications
- 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.
Nice to Have
- 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.
Tech Stack
- Amazon Redshift
- AWS
- PostgreSQL / Aurora PostgreSQL
- Python
- SQL
- ETL / ELT
- Data Quality
- Data Validation
- Data Reconciliation
- Data Warehousing
- Data Observability
Why Join This Opportunity?
- 💻 100% Remote across LATAM
- 🌎 Work with an innovative U.S. technology company
- 💵 Competitive compensation in USD
- 📈 Full-time contractor engagement
- ☁️ Work with modern AWS cloud technologies
- 🚀 Opportunity to contribute to large-scale, mission-critical data platforms
We're Looking For Someone Who
✔ 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
