Senior Data Engineer

Summary

Join Blue Coding, a fully remote company with a global team of over 100 engineers, and work as a Senior Data Engineer for a leading technology services company. You will be responsible for designing and implementing a modern data warehouse on Amazon Redshift, AWS Glue, and S3, migrating from SQL Server to Redshift, and implementing scalable ETL with AWS Glue. This role requires strong SQL and Python skills, experience building ETL pipelines, and knowledge of data modeling. You will work closely with BI and business teams to turn raw data into reliable insights and contribute to the long-term vision for the data platform.

Requirements

• Bachelor's degree in Computer Science or a related field, or equivalent work experience
• 5+ of related work experience in data engineering, data architecture or a similar role
• Strong SQL & Python skills (PySpark is a plus)
• Experience building ETL pipelines (preferably in AWS Glue, Airflow, or similar)
• Knowledge of data modeling (e.g., star schema, slowly changing dimensions)
• Ability to lead technical decisions without heavy oversight (small team environment)
• Budget-conscious mindset—experience optimizing cloud costs (Redshift, Glue)
• Excellent problem-solving and analytical skills
• Strong organizational skills and attention to detail
• Effective time management skills

Responsibilities

• Design & implement a modern data warehouse using Amazon Redshift, ensuring scalability and performance
• Develop and maintain ETL pipelines using AWS Glue (Python/PySpark), moving data from SQL Server (RDS) and other sources
• Structure our S3 data lake for efficient storage, partitioning, and integration with Redshift
• Define data models (star schema, dimensional modeling) to support reporting and analytics
• Establish data governance—documentation, quality checks, and monitoring for pipelines
• Collaborate with BI teams to ensure the warehouse meets reporting needs (CRM, dashboards)
• Optimize costs by tuning Redshift clusters, managing Glue job efficiency, and automating workflows
• Troubleshoot data infrastructure issues and optimize performance across systems
• Contribute to the long-term vision for the data platform, including new tools, workflows, and process automation
• Maintain documentation of data systems, flows, and integration strategies
• Support project planning and estimation in coordination with business and technical teams

Benefits

• Salary in USD
• Long-term
• Flexible schedule (within US Time zones)
• 100% Remote