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

📌 Sr. Business Intelligence Specialist (Toronto)
🏢 Rubicon Path
📍 Toronto