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