Apply now

First seen by our source: last month

RQ09097 - Business Intelligence Specialist - Senior

@ Rubicon Path

Toronto, Ontario

Apply now
SIGNALS

Overview

Rubicon Path is hiring a Senior Business Intelligence Specialist for a hybrid role, working onsite at 222 Jarvis St three days per week with up to two remote days. The work covers leading the conversion of up to 900 BOEXI reports to Power BI for fiscal 2025-26, building data integration and analytics solutions, and running client workshops. The posting asks for strong Microsoft Azure and Power BI experience.

Responsibilities:

  • Lead BOEXI to Power BI report conversion, up to 900 reports for 2025-26
  • Build BI solutions, customized query applications and scheduled reporting
  • Conduct client workshops and requirements-gathering sessions
  • Perform data integration, cleansing and modelling, and fix source data issues

Requirements summary:

  • Senior experience with Power BI, DAX and data visualization tools
  • Experience with Azure Data Factory, Azure SQL Database and Azure Data Lake
  • Experience with ETL development and data warehouse and data mart modelling
  • Strong data analysis and troubleshooting skills

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

Hybrid Work Environment: The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week.

Responsibilities:

  • Lead the report conversion activities from BOEXI to Power BI reports estimated up to 900 for 2025-26 fiscal year
  • 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
  • Conduct workshops and requirements-gathering sessions with clients on BI & Data Analytics Initiative
  • Conduct data integration, data cleansing, data modeling and analytics
  • Develop feedback processes to fix corrupt data in the source systems

SkillsExperience and Skill Set Requirements

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 (structured and semi-structured files, 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 designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned 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
  • Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
  • Experience with data modeling and design principles for data marts and data warehouses

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

Evaluation Criteria

Technical Proficiency - 40%

  • Demonstrates advanced knowledge and expertise in various BI tools and technologies, such as data modeling, ETL processes, data visualization, and reporting.
  • Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI

Data Analysis Skills - 30%

  • Exhibits strong data analysis capabilities, including data mining, data interpretation, and the ability to derive meaningful insights to support decision-making.

Business Acumen - 20%

  • Understands the organization's goals, processes, and industry context, and can translate business requirements into effective BI solutions that drive strategic outcomes.

Communication Skills - 10%

  • Effectively communicates complex technical concepts to both technical and non-technical stakeholders, and can collaborate with cross-functional teams to gather requirements and deliver BI solutions.

Must Haves:

  • Experience in using Power BI and other data visualization tools to create reports and dashboards, perform data exploration, and manage datasets.
  • Expertise in designing interactive and visually appealing reports and dashboards using Power BI Desktop, including selecting appropriate visualizations and arranging elements for clarity.
  • Experience in performing DAX formulas and functions for performing calculations, aggregations, and custom calculations in Power BI
  • Understanding of good UI design in delivering rich user experience by creating custom visuals and themes in Power BI to enhance report aesthetics and functionality.

Similar jobs

  • Director Data Engineering

    Cambridge, ON +1

    Gore Mutual Insurance: Effective January 1, 2026, Gore has joined Beneva—the country’s largest mutual insurance company—as part of its Property & Casualty operations in…

    This is a visible leadership role for someone who combines strong technical depth with business understanding, people leadership and the ability to turn data and technology investments…; A degree in Computer Science,…

    Data engineering, Databricks, Microsoft Azure, Google Analytics, CI/CD, Process improvement

  • Project Manager

    Toronto, ON
    $80–$105/hrContract

    Agilus Work Solutions: Experts in Specialized Talent for Nearly 50 years. Canada's largest, full service, privately-owned recruiting firm.

    10+ YOECandidates need 10+ years of project management experience, ideally in a financial institution, with strong communication, negotiation and vendor management skills. PMP certification and a bachelor's degree are preferred, and proficiency with MS Project, Planview, JIRA and Office Suite is expected.

    MS Project, Planview, JIRA

    PowerApps / Power BI Developer

    Toronto, ON
    $80/hrContract

    Agilus Work Solutions: Experts in Specialized Talent for Nearly 50 years. Canada's largest, full service, privately-owned recruiting firm.

    5+ YOECandidates need 5+ years of application development, with hands-on Microsoft Power Apps experience, Power Automate workflow experience, and skill integrating Power Apps, SharePoint, SQL and Power BI. Strong communication and SQL skills are also required.

    Microsoft Power Apps, Power Automate, Power BI, SharePoint, SQL

    AI Product Owner

    Toronto, ON
    $100–$140/hrContract

    Agilus Work Solutions: Experts in Specialized Talent for Nearly 50 years. Canada's largest, full service, privately-owned recruiting firm.

    Candidates need experience as a Product Owner or in a similar role delivering digital products with engineering teams, strong backlog and Agile skills, and practical knowledge of generative AI or AI agents. Experience with AI or automation products or financial services is an asset.

    Product Owner - Delivery

    Toronto, ON
    $80–$120/hrContract

    Agilus Work Solutions: Experts in Specialized Talent for Nearly 50 years. Canada's largest, full service, privately-owned recruiting firm.

    Agilus Work Solutions needs candidates with direct product delivery experience as a Product Owner or in a similar role. Candidates should understand active trader workflows on online brokerage or trading platforms and have worked with technology teams from requirements through release.

    Workflow

  • Global Compensation Partner

    Toronto, ON
    HybridFull Time

    Semperis: Semperis is headquartered in Hoboken, New Jersey, and operates internationally, with its research and development team distributed throughout the…

    4+ YOECandidates need 4+ years of compensation experience across job matching, leveling and market pricing in several countries, strong Excel and Workday skills, and a bachelor's degree or equivalent practical experience.

    Workday HCM, Workday Advanced Compensation, Excel, Microsoft 365, Ashby, Carta

  • General Manager - Woodbine

    Toronto, ON

    M&S Careers

    Candidates need hands-on general management experience, ideally in leisure, hospitality or retail, and managing a budget of at least $1m. They need coaching skills, a passion for people, and a Smart Serve or equivalent responsible-service certificate plus a Food Handlers Certificate.

  • Compensation Business Partner

    Toronto, ON
    RemoteFull Time

    Cohere: Cohere is the leading security-first enterprise AI company.

    6+ YOECandidates need 6+ years of compensation experience, including AI/ML talent, and experience in North America, the UK, and Europe. They must have strong equity compensation knowledge, analytical skills, international pay regulation expertise, and experience with Pave or similar platforms.

    Pave

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.