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

📌 Rq07952 - sr. business intelligence specialist (Toronto)
🏢 Rubicon Path
📍 Toronto