Apply now

First seen by our source: last month

RQ08930 - Business Intelligence Specialist - Senior

@ Rubicon Path

Toronto, Ontario

8+ years experience
Apply now
SIGNALS

Overview

Rubicon Path is hiring a senior Business Intelligence Specialist to modernize the Social Assistance reporting platform, moving the legacy Cognos system to scalable Power BI and Azure reporting products. The role covers data modelling, dashboard and report development, ETL work, agile project delivery and knowledge transfer. The posting requires on-site work three days a week.

Responsibilities:

  • Review and redesign Power BI and Cognos reporting products
  • Build dashboards, reports and data marts
  • Develop ETL and data modelling solutions in Azure and SQL Server
  • Document requirements, FDDs and DDDs
  • Conduct knowledge transfer and training sessions

Requirements summary:

  • 3+ years Power BI development with DAX
  • 8+ years ETL development experience
  • Experience with SQL Server, Oracle and Azure services
  • Familiarity with AODA and WCAG 2.0 accessibility
  • Experience in agile delivery (Scrum/Kanban)

Tools & skills

Source and dates

Source type not verified · manatal

Employer posting date
Not provided
First seen by our source
2026-10-15
Source record updated
2026-10-15

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Experience8+ years
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish

Summary and details written by AI from the posting; the employer’s posting is the authority.

Rubicon Path

FieldValue
Open jobs on Jobsy578
Job description

Description

Note: Candidate needs to be "Onsite" -3 days in a week

As part of the modernization of Social Assistance (SA) reporting platform (Legacy Cognos system), conduct a review of existing data model(s), report model(s) and redesign reporting products to be scalable and flexible to meet current program and Ministry needs for analytical and operational reporting.

The SA program area has identified several data and reporting products to support their efforts to modernize service delivery and streamline partnerships with municipalities. As the SA program area continues to develop the operational model implementation and evaluation plans, BIPD needs to establish a modernized, flexible reporting model to support reporting products and requirements. This will result in development of net new data and reporting products, including products to support Service Planning, continuous monitoring of operational indicators and outcome data through the contract cycle. At the same time BIPD needs to address the development of products in the SA reporting backlog, and the rationalization of the current 160+ operational and analytical products in the reporting catalogue.

Purpose:

  • 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 CYSSC, ITS and 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.

SkillsExperience and Skill Set Requirements

Experience:

  • 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
  • Experience building, testing and implementing complex reports, dashboards, and other objects
  • Experience prototyping to develop business requirements for future implementation
  • 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

Skills:

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, Customer Voice, etc.
  • SQL Server
  • Oracle
  • 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.
  • Knowledge of Golden Gate is an asset but not required.

Evaluation Criteria

Power BI Development (25%)

  • Demonstrated experience in Power BI software development and a number of years of practical experience (minimum 3+ years)
  • Experience in development of data marts in Power BI
  • Building data models optimized for business intelligence and analytic functions

Data Injection (25%)

  • Demonstrated experience in Extract, Transform & Load software development and a number of years of practical experience (minimum 8+ years)
  • Experience in Informatica/SISS and ETL/ELT
  • Development of pre-defined and ad hoc reports and meet coding and accessibility (WCAG 2.0) requirements

Design Documentation and Analysis Skills (25%)

  • Demonstrated experience in creating data documentation about algorithms, parameters, models using standard approaches e.g. Functional Design Documents (FDD) & Detailed Design Documents (DDD).
  • Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises, and reviews
  • Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
  • Work with the Client, Designer(s) & Developer(s) assigned to refine/confirm Business Requirements
  • Analyze and document solution complexity and interdependencies by function / track for purpose of effort and cost estimation.
  • Conduct research and prototyping of new business intelligence and analytics capabilities to support OPS business requirements
  • Analyze, Design, Build and Test databases based on business requirements
  • Analyze, Design, Build and Test Reports, Dashboards and other objects
  • Design functional test and technical deployment strategies

Database and Cloud Related (20%)

  • Demonstrated experience with T-SQL Server databases
  • Experience with Microsoft Azure services such as Power Apps, Azure Database, Azure Analysis Services, Azure Synapse, Customer Voice, etc.

Knowledge Transfer (5%)

  • The Developer must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
  • Development of documentation and materials as part of a review and knowledge transfer to other members
  • Conduct Analysis, Design, Development and execution of specific learning activities that are aligned to Informatica work packages to staff
  • Development of specific activities as part of a review, watch, do methodology and building block approach which, build on knowledge transfer and skills development from the previous stage with increasing levels of complexity, priority and responsibility and hands on experience
  • Development and facilitation of classroom based, or virtual instructor demo led sessions for Developers
  • Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed
  • Assist in the development of the pre-defined and ad hoc reports and meet the coding and accessibility (WCAG 2.0) requirements

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, Customer Voice, etc.
  • SQL Server
  • Oracle
  • 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.
  • Knowledge of Golden Gate is an asset but not required.

Similar jobs

  • Inside Sales Representative

    Toronto, ON
    RemoteFull Time

    Canada - VWR International Co.

    Required Qualifications; College diploma, university degree, or equivalent combination of education and experience; Previous experience in sales, account management, customer service, business development, or a related…

  • Outside Sales Representative (Toronto, ON)

    Toronto, ON
    HybridFull Time

    Curri

    Work in close partnership with Sales, Marketing, and Operations to deliver a world-class customer experience for prospective customers; Execute a market-based motion where you will strategically work high-value…

    Sales, Teamwork, Customer experience, Logistics, Interpersonal skills, Time management

  • Associate, People Experience & Operations

    Toronto, ON
    $62k–$92k/yrFull Time

    OMERS Administration Corporation

    The Associate, People Experience & Operations is responsible for providing timely and accurate support to employees, leaders, and HR partners across a broad range of HR inquiries,…; Assist with reporting and data…

  • Senior Principal Content Strategist, Autodesk Assistant

    Toronto, ON
    RemoteFull Time

    Autodesk

    The Experience Foundations team creates the systems, standards, and experiences that enable that mission, particularly as AI transforms how customers work across increasingly connected…; Minimum Qualifications; 10+…

    Principal Conversation Designer, Autodesk Assistant (Canada/US)

    Toronto, ON
    RemoteFull Time

    Autodesk

    The Experience Foundations team creates the systems, standards, and experiences that enable that mission, particularly as AI transforms how customers work across increasingly connected…; Shape Assistant voice, tone,…

    Principal Content Designer, Autodesk Assistant

    Toronto, ON
    $116k–$171k/yrOn-siteFull Time

    Autodesk

    The Experience Foundations team creates the systems, standards, and experiences that enable that mission, particularly as AI transforms how customers work across increasingly connected…; This role will define how help,…

  • Director, Executive Communications

    Toronto, ON
    Full Time

    Sokin

    8+ YOE8+ years across communications, content, or brand, with direct experience building an executive or founder presence that measurably grew; Experience in fintech, financial services, or another regulated category is a plus

    Leadership, Manage feedback, Direct inward dialing

  • Senior Manager, Fraud Detection & Optimization

    Toronto, ON
    Full Time

    Royal Bank of Canada: Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance.

    Stock listing: TSX:RY · NYSE:RY · Source checked: 2026-11-02

    5+ YOECandidates need 5+ years in data science, machine learning or statistics, a degree in a quantitative field, and proven leadership of analytics teams. Strong skills in SAS, R, SQL or Python and big data tools such as Hadoop, Hive or Spark are required.

    SAS, R, SQL, Python, Hadoop, Hive

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.