Senior Data Engineer (VM)

Blue Coding specializes in hiring developers and building teams for cutting-edge companies in the United States and Canada. They are seeking a Senior Data Engineer to design and optimize cloud data pipelines, migrate from SQL Server to Redshift, and collaborate with BI teams to turn raw data into insights.

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

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