View all jobs

Sr. Business Intelligence Specialist - 03968

Toronto, ON


  • To integrate, translate and oversee design of business-driven issues and priorities into enterprise-level business intelligence and data analytics solutions, using leading-edge data development approaches, with expertise/knowledge in data modelling, data architecture and infrastructure, data development (including dimensional modelling) as well as reporting (e.g. dashboard) development.
  • To project-manage (e.g. design, deliver and implement) complex I&IT projects and various agile, business solutions required to meet cross-ministry business intelligence and data analytics activities and priority projects, including leading and supporting enterprise-wide projects that may involve work with other ministries, jurisdictions and the broader public sector.
  • To work within the ministry's business analytics data warehouse environment, and support efforts to enhance and maintain infrastructure and applications, and providing technical expertise to the development and implementation of various I&IT solutions, while working with  enterprise partners.
  • To lead data development and maintenance activities that support strategic initiatives and priority projects across the ministry, including the preparation of ad-hoc statistical information and developing research/analytical data for reporting and analytics, while ensuring appropriate data quality, integrity, privacy and security.


  • Experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
  • Experience in other Microsoft BI stack e.g. SSAS, SSRS, SSIS
  • Experience with scripting and programming
  • Experience working with MS SQL Server on premise and within Azure Environment
  • Experience with data-specific tasks including database management, SQL querying, data modelling, online analytical processing
  • Experience with designing and mapping multi-dimensional data models, report models into business insights
  • Ability to assist in the requirements gathering, analysis and subsequent developments
  • Ability to conduct unit tests and assist in test preparations to ensure data integrity
  • Work closely with Project Manager, UX/UI Designers, Quality Assurance Analysts and other Developers
  • Experience working within an Agile software development life cycle, e.g. Scrum/Kanban
  • Understanding of accessibility compliance requirements e.g. AODA, WCAG 2.0


Must Have:

  • 3+ years using Power BI software development, including using DAX queries and functions
  • Microsoft Azure services such as Power Apps, Power Automate, Azure Database, Azure Analysis Services, Azure Synapse, etc.
  • SQL Server
  • Working knowledge of DataBricks
  • Ability to translate wireframes, low-fidelity and high-fidelity prototypes and business requirements into technical tasks towards functional reporting products or dashboards
  • Ability to present technical requirements to the business
  • Familiarity with accessibility compliance, usability testing e.g. AODA, WCAG 2.0

Nice to Have:

  • Some knowledge of user interface design and user interaction design is an asset but not required.


Share This Job

Powered by