RQ07952 - Sr. Business Intelligence Specialist

Rubicon Path; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A well-known consulting firm in Toronto is seeking a Senior Business Intelligence Specialist. The role involves developing BI solutions and supporting clients' data management needs. The ideal candidate will have 10+ years of experience, proficiency in R scripting and Power BI, as well as strong analytical and communication skills. This is an opportunity to impact analytics and strategy across the organization.

Qualifications

• Must have 10+ years of experience in Business Analysis.
• Demonstrated experience working with large datasets and analytics solutions.
• Strong understanding of statistical techniques and machine learning.

Responsibilities

• Support client-wide business information requirements with BI solutions.
• Develop and support applications that analyze key business data.
• Provide clients with tools for managing business-related data.

Skills

R Scripting

Power BI

Data analysis

Communication with stakeholders

Statistical modeling

Data management

Tools

SQL Server

Oracle

Tableau

Python

OpenRefine

DAX

Job description

RQ07952 - Sr. Business Intelligence Specialist

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:

• Support client wide‑range business information requirements, implementing and supporting business intelligence software solutions
• Develop and support customized query applications that analyze key business data
• Develop and support guided analysis and drill‑down functionality, schedule report generation, and implement opportunity and key‑trend alerts
• Provide clients with approach options and tools for managing business‑related data to support quantitative analysis of progress and the relationship between operational actions and business objectives

General Skills:

• Experience analyzing data in source systems to identify data cleanliness issues (e.g., missing values, duplicate values, and invalid data)
• Experience developing feedback processes to correct corrupt data in source systems
• Experience developing data extraction, transformation, and load (ETL) programs for daily and initial loads across relational and multi‑dimensional data stores
• Experience developing, implementing, and maintaining schedule/dependency logic for ETL scripts
• Experience developing monitoring and error‑notification processes to ensure data is updated as designed
• Experience 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 using development tools and business re‑engineering software
• Experience developing enterprise architecture deliverables (business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines
• Knowledge and experience developing data analysis applications
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Ability to advise on developing and integrating process and information models to eliminate redundant business processes
• Hands‑on experience documenting interface specifications between BI solutions and external applications
• Extensive experience with conceptual, logical, and physical data‑modeling tools such as Power Designer and Visio
• Knowledge of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Key Deliverables:

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

Expertise & Training for Business Users:

• 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 advanced statistical modeling, econometrics tools, and techniques
• Provide planning advice on data use and capacity building for advanced analytics and data analysis within the ministryProvide guidance on the statistical relevance of data to project teams

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

• Experience communicating with business stakeholders and providing guidance to ensure successful project delivery on time
• Experience working with and analyzing large, diverse data sets; identifying relationships and themes for policy development
• Strong knowledge of designing, developing, and implementing analytics solutions using administrative data
• Knowledge of statistical and modeling techniques (econometrics, probability, inference, regression, machine learning, etc.)
• Knowledge of advanced data visualization tools and statistics and analytical tools (R/SAS/SPSS; R Shiny, Power BI, Tableau)
• Strong interpersonal, written, and oral communication skills across all levels
• Excellent analytical, problem‑solving, and decision‑making skills, and a team‑working attitude
• Outstanding consulting and relationship‑management skills, ability to elicit requirements and provide effective guidance
• Experience with analytical methods and tools (data mining, machine learning, NLP, etc.)
• Ability to manipulate and analyze complex, high‑volume data from structured and unstructured sources
• Experience designing high‑quality interfaces to present information meaningfully to end users
• Broad understanding of data management, financial and business analysis, database architecture, and information visualization
• Proficiency in query languages and constructing complex query statements; experience in programming or scripting languages
• Strong investigative and logical skills, proficiency in mathematics and statistics
• Awareness of emerging BI trends and directions

Knowledge Transfer:

\

• Knowledge transfer must be completed one week prior to the end of the project
• All deliverables, design, support, release, and training documents must be checked into version control repositories (e.g., SharePoint, HPQC, TFS)
• Project managers and ministry staff must be regularly informed in writing of document locations and receive at least one walkthrough of all documentation during the final knowledge‑transfer activities
• Knowledge will be transferred through 1‑on‑1 sessions, emails, document updates, and reviews

Core Skills – 35%:

• Database design (SQL Server, Oracle)
• Developing BI and analytics roadmaps for clients (e.g., Microsoft BI)
• Advanced data visualization tools (R Shiny, Google Analytics, Tableau, Power BI)
• Data preparation and scripting (OpenRefine, Python, DAX)
• Statistical analysis, data mining, machine learning, NLP, and predictive/prescriptive analytics
• Data warehousing and dashboards
• Econometrics and statistical inference techniques
• Large‑scale data extraction, transformation, and load for relational and multi‑dimensional stores

Other Technical Skills – 35%:

• 10+ years experience with Business Analysis
• Experience with post‑secondary administrative data assets
• Experience managing large, diverse data sets and identifying relationships
• Experience creating detailed plans and estimates for development, testing, and implementation of projects/programs
• Experience reporting and documenting
• Experience with data management, financial and business analysis, database architecture, and information visualization
• Experience with statistical analysis, data mining, machine learning, and algorithms

Communication – 20%:

• Analyzing requirements to determine functional and system requirements; leading initiatives from end to end
• Documenting system design and producing technical specifications and architectural artifacts
• Understanding challenges in government projects related to data
• Analytical problem‑solving and decision‑making capabilities
• Managing multiple teams across various areas during delivery
• Excellent verbal, written, and presentation skills
• Collaboration with client organizations; meeting strict deadlines
• Knowledge of industry methodologies, best practices, and standards

Public Sector Experience – 10%:

• Experience working within OPS, especially in Learning Ministries
• Experience developing applications that comply with GO‑ITS standards
• Understanding ministry data challenges and issues

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 data visualization tools and techniques (statistical graphics, plots, information graphics). Interest in R Shiny, Google Analytics, Tableau, Power BI (R Shiny or R Server a MUST)
• Experience with a range of analytical methods and tools (statistical modeling, data mining, machine learning, NLP, business performance management, benchmarking, text mining, prescriptive analysis)
• Proficiency with statistics and modeling techniques (econometrics, inference, confidence intervals, regression, machine learning, hyper‑parameter search)
• Nice to have: Power BI, PS, 10+ years Business Analysis experience