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.
20 hours ago