Senior Data Warehouse Analyst (ETL Developer) to design, develop, deploy, and test end-to-end data pipelines and data models - RFC-2024-030

S.i. System's client is looking for an Senior Data Warehouse Analyst (ETL Developer) to design, develop, deploy, and test end-to-end data pipelines and data models

This is a 8-month contract to start with chances of extension. This is a hybrid model, looking for candidates open to coming to the office once a week at their New Westminster office.

MUST HAVES:

• 10+ years’ experience with Business Intelligence/Data Analytics
• 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.
• Hands-on experience with authoring Power BI reports, exposure to Power BI Cloud.
• Experience designing, building, and maintaining ETL/ELT data pipelines, (preferably Azure Data Factory).
• Demonstrated ability to interact professionally with a diverse group of executives, managers, supervisors, subject matter experts and end users.
• Skilled at facilitating and managing consultation processes with a wide range of stakeholder groups.
• Proven experience with gathering and analyzing functional and technical requirements and information from key business areas and stakeholder groups.
• Excellent interpersonal skills combined with highly developed communication skills, both verbal and written

Nice to Have:

• Hands-on experience with Spark (PySpark/Python) in Azure.
• Experience with data migration from on-prem to cloud (preferably Azure Data Factory).
• Strong knowledge and experience designing Data Lakes and Data Warehouses.
• Hands-on knowledge of Azure SQL Data Warehouse architecture and best practices.
• Extensive knowledge of Dimensional Modelling and Kimball EDW principles Understanding of Azure
• Managed Instance.
• Experience working with Data Lakes and Data Marts.
• Ability to work with large volumes of data from multiple sources.
• Microsoft SQL Server SSIS/SSRS/ETL.
• Experience in Azure IaaS, PaaS and Database migration.
• Experience working with external vendors.
• Experience working in a unionized environment.