Senior Synapse Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Develop Synapse pipelines, SQL transformations, datasets, and linked services.

• Convert Alteryx logic into Synapse SQL, PySpark, or Data Flows.

• Enhance the performance of dedicated SQL pools through partitioning, indexing, and caching.

• Establish CI/CD pipelines utilizing Azure DevOps or GitHub.

• Set up and manage data security, RLS, access roles, and auditing processes.

• Improve ADLS Gen2 folder structures, file formats, and the use of Delta/Parquet.

• Work alongside the Data Modeller to ensure the precise implementation of models.

• Monitor Synapse environments, assessing performance, costs, and autoscaling.

• Resolve issues throughout the ingestion, transformation, and orchestration phases.

• Offer architectural insights and best practices for the platform.

⛳️ Requirements

• Over 8 years of experience in data engineering, with at least 3 years focused on Azure Synapse.

• Proficient in T‑SQL, ETL/ELT pipeline development, and workload optimization.

• Familiarity with migrating Alteryx, SSIS, Databricks, or similar ETL systems.

• Understanding of Delta Lake, Parquet, partitioning, and schema evolution.

• Experience with CI/CD processes in Azure DevOps, Git, and environment promotion.

🏝️ Benefits

• Competitive salary and performance-based bonuses.

• Comprehensive health and wellness benefits.

• Opportunities for professional development and continuous learning.

• Flexible work hours and remote work options.

• Engaging and inclusive company culture.