Senior Business Intelligence Developer to work with the I.T. team to develop an on-premise Data Warehouse with SQL Server Integration Services, SQL Database and PowerBI
Job Type: Contract
Positions to fill: 1
Start Date: Aug 15, 2022
Job End Date: Dec 23, 2022
Pay Rate: Hourly: Negotiable
Job ID: 122195
Location: Calgary, Edmonton, Vancouver, Victoria
Senior Business Intelligence Developer to work with the I.T. team to develop an on-premise Data Warehouse with SQL Server Integration Services, SQL Database and PowerBI
Must haves:
- Experience with on premise Data Warehouse design and implementation
- Good understanding of cloud design considerations for data storage and processing.
- 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.
- Thorough knowledge of software development methods, practices and procedures.
Ability to prepare technical design and write technical specifications.
- Translating business requirements into technical specifications
- Designing Data Models based on technical specifications
- Designing and building End to End Data pipeline and ETL packages including:
- Staging Areas and Date Warehouse Layouts with SQL Server
- Data pipeline with SSIS
- ETL Processes with SSIS / SSDT
- Error Handling
- Dashboards and reports with PowerBI