[Remote] Senior Data Engineer (SQL, Python, Redshift, AWS)
Note: The job is a remote job and is open to candidates in USA. GlobalPoint is seeking a Senior Data Engineer with expertise in SQL, Python, Amazon Redshift, and AWS data technologies. The role focuses on building data quality frameworks, troubleshooting data issues, automating validation processes, optimizing data systems, and supporting critical business reporting and analytics.
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
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
- 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
Benefits
- Remote work arrangement
- Long-term contract
Company Overview
Company H1B Sponsorship