Sr BI Developer to support the development of an on-premise Data Warehouse

Our public sector client is seeking a Sr BI Developer to support the development of an on-premise Data Warehouse using SQL Server Integration Services, SQL Database, and Power BI

Initially a 12-months contract to start. Hybrid working model in Lower Mainland for local candidates 2 days/week onsite. 36.25 hrs/week.

Must Have

• Experience with on premise Data Warehouse reusable framework design and implementation

• Experience with data modeling

• Experience with building data pipelines and ETL processes

• Extensive development experience with technologies including: SSIS, SQL Server, REST API, OLAP

cubes, BI Analytic tools

• Extensive analytic development experience with PowerBI and preferably Microsoft Power Platform

• Advanced Power BI Service configurations such as Power BI DataFlow and DataMart

• Experience in PowerBI report development, reports automation with data source refresh

configurations

• Good understanding of Azure cloud design considerations for data storage and processing

• Experience with analyzing data source systems to identify data transformation needs

• Thorough knowledge of software development methods, practices and procedures

• Ability to prepare technical design and write technical specifications

Responsibilities:

• Translating business requirements into technical specifications

• Designing and developing the Data Analytics (Data ingestion, data warehouse, data lake ODS, pipeline,

error handling, Azure cloud data gateway, MS Fabric, Power BI security, Power BI workspace) reusable

framework

• Designing Data Models based on technical specifications

• Exploring in-depth PowerBI features for advanced analytics which require more customization like

DataFlow & DataMart

• Designing and building End to End Data pipeline and ETL packages including:

o Staging Areas and Date Warehouse Layouts with SQL Server

o Data pipeline with SSIS

o ETL Processes with SSIS / SSDT

o Error Handling

o Dashboards and reports with PowerBI Desktop

o Troubleshoot day to day data warehouse issues