Redesign enterprise data models and reporting products onsite three days weekly, using dimensional modelling, SQL, and analytical reporting expertise.

As a senior Business Intelligence Specialist, you will modernize the Social Assistance reporting platform and rationalize existing products. The work spans data architecture, infrastructure, dimensional modelling, dashboards, and operational reporting. You will support Ministry needs through requirements analysis, prototyping, testing, documentation, and implementation.

Key Responsibilities:

- Design flexible data and report models for Ministry requirements
- Develop analytical and operational reporting products
- Conduct requirements reviews, fit-gap analysis, and prototyping




- Create functional and detailed design documentation
- Define testing and technical deployment strategies

Requirements:

- Experience mapping multidimensional models into business insights
- Experience building complex reports, dashboards, and analytical objects
- Experience with T-SQL Server databases and Azure services
- Experience with SSAS, SSRS, SSIS, Informatica, or ETL
- Experience working within Scrum or Kanban environments

Bring senior data modelling, reporting design, and SQL expertise to versatile Social Assistance analytics products.

📌 Senior Data Modelling Reporting Specialist (Toronto)
🏢 Rubicon Path
📍 Toronto