Login | Register

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
Apply

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. 
Responsibilities:
  • 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