Datawarehouse Developer & Analyst to support ETL and data pipeline work RFC 2025 026 & 027

S.i. Systems is looking for a Datawarehouse Developer & Analyst to support ETL and data pipeline work.

6 month contract to start - high chance of extension - 37.5 hours/week - Hybrid (1 day per week in New Westminster)

MUST HAVES:

• 5+ years of ETL & data warehousing projects.
• 5+ years' experience in Microsoft SSIS & SQL Server technologies (SQL Server 2012 - 2019)..
• Hands-on experience with Spark (PySpark/Python) in Azure.
• Hands-on experience with a range of Azure Services, including ADF, Azure Databricks, Delta Lake, Azure Data Lake Storage, Azure Synapse, Power BI Report and Crystal Report.
• Strong experience with data migration from on-prem to cloud (preferably Azure Data Factory).
• Strong knowledge and experience designing Data Lakes and Data Warehouses.
• Strong experience designing, building, and maintaining ETL/ELT data pipelines (preferably Azure Data
• Factory and Synapse).
• Strong knowledge of Azure data ecosystem for computing and storage.
• Some experience with Infrastructure as Code (IAC) using Terraform

NICE TO HAVES:

• Data model design
• Experience with Databricks
• Experience working in a unionized environment