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 versatile 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 settings

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

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