Apply now

First seen by our source: last month

RQ07952 - Sr. Business Intelligence Specialist

@ Rubicon Path

Toronto, Ontario

10+ years experience
Apply now
SIGNALS

Overview

Rubicon Path is hiring a Senior Business Intelligence Specialist to support client business information needs with BI software solutions, custom query applications and data analysis. The role requires 10+ years of relevant experience, with work on large data sets for postsecondary education policy. Public sector experience is a nice-to-have.

Responsibilities:

  • Build and support customized query applications analyzing key business data
  • Develop drill-down analysis, scheduled reporting and key-trend alerts
  • Provide clients with tools for quantitative analysis of business progress
  • Advise ministry business partners on analytical needs and training

Requirements summary:

  • 10+ years of experience with business stakeholders and large data sets
  • R scripting and Power BI experience required
  • Experience managing high volumes of data and ETL processes
  • Public sector experience is an asset

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
Experience10+ years
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

Must Haves:

  • Demonstrates experience working and communicating directly with stakeholders
  • Managing high volumes of data
  • R Scripting
  • Power BI

Nice to Have:

  • Public Sector Experience

Responsibilities:

Supports Clients wide-ranging business information requirements, implementing and supporting business intelligence software solutions

Develops and supports customized query applications which analyze key business data

Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of opportunity and key-trend alerts.

Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.

General Skills:

Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data)

Experience with developing feedback processes to fix corrupt data in the source systems

Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)

Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts

Experience with developing monitoring and error notification processes to ensure data is updated as designed

Experience with developing automation extraction, cleansing and load scripts

Experience generating research models and reports (scheduled and ad-hoc)

Proven troubleshooting and analytical experience

Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.

Experience in the use of development tools and business re-engineering software

Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines

Desirable Skills:

Knowledge and experience in developing data analysis applications

Knowledge and understanding of Information Management principles, concepts, policies and practices

Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes

Experience with developing monitoring and error notification processes to ensure data is updated as designed

Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications

Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio.

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Supports Clients wide-ranging business information requirements, implementing and

supporting business intelligence software solutions. Develops and supports customized

query applications which analyze key business data. Also develops and supports guided

analysis and drill-down functionality, routine scheduling and notification of report generation,

and effective implementation of opportunity and key-trend alerts.

Provides Clients with approach options and tools for managing business-related data in a

manner that assists in quantitative analysis of progress and the relationship between

operational actions and their effect on business objectives.

Experience with analyzing data in source systems to identify data cleanliness issues

(e.g. missing values, duplicate meanings, and invalid data)

Experience with developing feedback processes to fix corrupt data in the source

systems

Experience with developing data extraction, transformation, and load programs (daily

and initial load) functionality on a wide-range of data repositories (relational and multidimensional

data stores)

Experience with developing, implementing and maintaining schedule/dependency

logic for Extract Transform Load (ETL) scripts

Experience with developing monitoring and error notification processes to ensure

data is updated as designed

Experience with developing automation extraction, cleansing and load scripts

Experience generating research models and reports (scheduled and ad-hoc)

Proven troubleshooting and analytical experience

Experience in process decomposition/mapping and business process re-engineering

and complex data models using UML.

Experience in the use of development tools and business re-engineering software

Experience in developing enterprise architecture deliverables (e.g. business, logical,

and physical models) based on Enterprise Application Processes and Modeling

methodology and guidelines

Desirable Skills

Knowledge and experience in developing data analysis applications

Knowledge and understanding of Information Management principles, concepts,

policies and practices

Ability to provide expert advice in developing and integrating process and information

models to enable identifying and eliminating redundant business processes.

Experience with developing monitoring and error notification processes to ensure

data is updated as designed

Hands on experience working with stakeholders to develop and document interface

specifications design between Business Intelligence solutions and external

applications

Extensive experience with conceptual, logical and physical data modelling tools like

Power Designer, and Visio.

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA)

and related regulations and standards

----------------------------------------------------------------------------------------------------------------------------------------------------

Key deliverables to be performed by the consultants include, but are not limited to the following:

  • To support, influence and impact the use of analytics and strategy for analytics across the enterprise.
  • To help develop and support the use of the Analytics, tools, and best practices across the enterprise.
  • Provide consulting services to ministry business partners regarding their information consumption and analytical needs.
  • Participate in the creation of detailed plans and accurate estimates towards development, testing, and implementation of the project or program.
  • Contribute to successful project completion by identifying risks and developing/ recommending mitigation strategies.
  • Participate in Proof of Concept or Proof of Technology projects.

Provide expertise & training to business users:

  • To help develop proposals and feasibility studies for small to medium projects. Conduct technology research, evaluate Analytics tools and produce strategy/direction papers.
  • Provide advice and guidance in the areas of advanced statistical modelling, econometrics tools and techniques.
  • Provide planning advice to the project team on the use of data and building capacity within the Ministry on performing advanced analytics and data analysis.
  • Provide direction on the statistical relevance of data to the project team

Scope: The consultants must have a minimum of 10+ years of the following skills and experience:

Skills and Experience

  • Experience working and communicating directly with business stakeholders; being able to provide guidance and advice to ensure the successful delivery of projects within the required timelines.
  • Experience in working with and analyzing large and diverse data sets, identifying relationships and themes suitable for future policy development concerning post secondary education and training.
  • Strong knowledge of design, development, and implementation experience utilizing Analytics technologies involving the use of administrative postsecondary data.
  • Knowledge of Statistics and modelling techniques such as econometrics, theory of Probability and Statistics - inference based on survey data, confidence intervals, regression models - multinomial linear, logistic, ridge, machine learning algorithms - training, model evaluation, hyper parameters search techniques.
  • Knowledge of advanced data visualization tools and techniques. Knowledge of statistics and analytical tools such as R/SAS/SPSS Expert documentation skills.
  • Knowledge of BI technologies such as R Shiny, Power BI, Tableau.
  • Strong interpersonal and communication skills (both written and oral); ability to communicate with people in a wide variety of areas and at various levels from technical specialists to senior management.
  • Must be able to work in a high functioning team environment.
  • Excellent analytical, problem-solving and decision-making skills, verbal and written communication skills, interpersonal skills and team work skills.
  • Outstanding consulting and relationship management skills, with proven ability to elicit requirements, develop/consult on options and solutions, and provide effective guidance
  • Adept at communicating to both technical and non-technical audiences
  • Experience with a range of analytical methods, techniques and tools such as, but not limited to:
  • statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, and other related disciplines at the specified experience level
  • Ability to manipulate and analyze complex, high-volume data from structured and unstructured sources
  • Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores
  • Experience designing high quality interfaces to present information in a meaningful way to end users
  • Broad understanding of data management, financial and business analysis, database architecture, and information visualization
  • Proficiency in query languages and experience constructing complex query statements Experience in one or more programming or scripting languages
  • Strong investigative and logic skills.
  • Proficiency in mathematics and statistics
  • Awareness of emerging Business Intelligence trends and directions Functional area experience as required

Knowledge Transfer

Transfer From Solution Development / Systems Testing/QA Specialist / Intermediate to Project Manager

When Knowledge Will Be Transferred:

  • Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry.

What Knowledge Will Be Transferred:

  • All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint). All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example, SharePoint site, HPQC, TFS)
  • Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.

How Knowledge Will Be Transferred:

  • Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.

SkillsExperience and Skill Set Requirements

Core Skills - 35%

  • Demonstrated experience with database design (SQL Server, Oracle)
  • Experience developing BI and analytics Roadmaps for clients (e.g. Microsoft
  • BI)
  • Working knowledge of advanced data visualization tools and techniques (statistical graphics, plots, information graphics). Some tools that would be of
  • interest are Rshiny, Google Analytics, Tableau and Power BI
  • Demonstrated experience with data preparation and scripting tools (such as OpenRefine, Python and DAX)
  • Demonstrated experience with a range of analytical methods, techniques and tools: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, business performance management, benchmarking text mining, predicative/prescriptive analysis and other related disciplines
  • Demonstrated experience with statistics and analytical tools such as R/SAS/SPSS Demonstrated experience with data warehousing and dashboards
  • Demonstrated experience with statistics and modelling techniques such as econometrics, theory of Probability and Statistics - inference based on survey data, confidence intervals, regression models - multinomial linear, logistic, ridge, machine learning algorithms - training, model evaluation, hyper parameters search techniques Demonstrated experience developing data extraction, transformation, and load functionality for large relational and multidimensional data stores

Other Technical Skills - 35%

  • 10+ years experience with Business Analysis
  • Demonstrated experience with design, development, and implementation utilizing analytics utilizing post secondary administrative data assets.
  • Demonstrated experience working with and analyzing large and diverse data sets, identifying relationships and themes.
  • Demonstrated experience with the creating of detailed plans and accurate estimates toward development, testing, and implementation of project/programs
  • Demonstrated experience reporting and documenting
  • Demonstrated experience with data management, financial and business analysis, database architecture, and information visualization
  • Demonstrated experience with statistical analysis and modelling, data mining, machine learning and algorithms

Communication - 20%

  • Experience analyzing requirements in order to determine functional and system requirements; able to take concepts and lead initiatives from end to end
  • Experience in documenting system design and producing technical specifications and architectural artefacts
  • Strong understanding of challenges and issues that arise in government projects which arise with respect to data
  • Demonstrated analytical problem solving and decision-making capabilities;
  • Experience in dealing with multiple teams representing various areas in delivering the project;
  • Excellent verbal and written communication and presentation skills;
  • Demonstrated capacity to work collaboratively with client organizations;
  • A team player with a track record for meeting strict deadlines; and
  • Knowledge of industry methodologies, best practices, and standards;

Public Sector Experience - 10%

  • Demonstrates experience working within the OPS, particularly within the Learning Ministries would be an asset
  • Demonstrates experience developing applications that comply with GO- ITS standards would be an asset
  • Strong understanding of challenges and issues that ministry may have with respect to data

BI Specialist mix of Dev and BA

7+ years

Must Haves:

· Demonstrated experience with database design (SQL Server, Oracle)

Experience developing BI and analytics Roadmaps for clients (e.g. Microsoft

BI)

· Working knowledge of advanced data visualization tools and techniques (statistical graphics, plots, information graphics). Some tools that would be of interest are Rshiny, Google Analytics, Tableau and Power BI (RShiny or RServer a MUST)

· Demonstrated experience with a range of analytical methods, techniques and tools: statistical analysis and modelling, data mining, machine learning and algorithms, natural language processing, business performance management, benchmarking text mining, predicative/prescriptive analysis and other related disciplines

· Demonstrated experience with statistics and modelling techniques such as econometrics, theory of Probability and Statistics - inference based on survey data, confidence intervals, regression models - multinomial linear, logistic, ridge, machine learning algorithms - training, model evaluation, hyper parameters search techniques

Nice to have:

  • Power BI
  • PS
  • 10+ years experience with Business Analysis

Similar jobs

  • RQ00781 - Software Developer - Full Stack - Senior

    Toronto, ON
    Contract

    Maarut

    8+ YOECandidates need 8 to 10 years of software development experience, with strong skills in React, ASP.NET Core, Azure services and Microservices. Experience in healthcare or regulated industries and knowledge of health information privacy rules are valued.

    React, ASP.NET Core, Azure APIM, Azure Service Bus, Azure Container Apps, Azure DevOps

  • Product Account Executive, Business and Industrial Markets

    Toronto, ON

    Google

    8+ YOECandidates need a bachelor's degree or equivalent practical experience and 8 years of industry experience in sales, digital advertising, business development, digital marketing or marketing. Experience with video or digital advertising and long-term client strategy is preferred.

    YouTube

    Product Account Executive, Automotive

    Toronto, ON

    Google

    8+ YOECandidates need at least 8 years of industry experience in sales, digital advertising, business development or digital marketing, plus a bachelor's degree or equivalent practical experience. Experience with video or social advertising, executive-level relationship building and analytical selling is preferred.

    YouTube

  • Java Full stack Developer

    Toronto, ON
    Full Time

    I8IS - Infiniti Software Solutions

    10+ YOECandidates need over 10 years of experience building enterprise n-tier applications, with strong skills in Java, Spring Boot, JPA or Hibernate, React or Angular, and SQL databases like PostgreSQL. They also need solid requirements gathering, problem-solving, and communication skills.

    React, Spring Boot, PostgreSQL, Azure Cosmos DB, Angular

  • Service Desk - Contract

    Toronto, ON
    Contract

    Compugen Inc

    1+ YOECandidates need 1 to 3 years in a service desk or technical support role, with Windows and Microsoft 365 knowledge and ServiceNow or ITSM experience. They must communicate clearly with non-technical users and work well in a fast-paced environment. ITIL Foundation, CompTIA A+ or Microsoft Fundamentals are an asset.

    ServiceNow, Microsoft 365, Outlook, Teams, OneDrive, Windows

    End User Support - Contract

    Toronto, ON
    Contract

    Compugen Inc

    Candidates need strong customer service and troubleshooting skills, hands-on A/V or conference room support experience, and the ability to lift up to 50 lbs. Networking experience is an asset, and the role requires onsite availability five days per week.

    A/V equipment, conference room equipment, networking equipment, monitors

    Senior Data Science Developer - Contract

    Toronto, ON
    Contract

    Compugen Inc

    Candidates need extensive AI, machine learning or software engineering experience, strong Python and SQL skills, and hands-on work with LLMs, RAG and Azure AI services. Experience with Microsoft Copilot Studio, Power Automate, Databricks and standard development tools such as Git, Jira and CI/CD is also expected.

    Python, SQL, Azure AI Foundry, Azure Machine Learning, Azure OpenAI, Microsoft Copilot Studio

  • Channel Executive

    Toronto, ON
    RemoteFull Time

    TydeCo

    4+ YOECandidates need typically 4+ years of B2B software, SaaS, partner or account-development experience. Strong written and verbal communication, CRM pipeline management, and cross-functional collaboration are required; Sage, ERP, HR/payroll, or fintech experience is preferred.

    HubSpot, Sage, CRM

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.