RQ07952 - Sr. Business Intelligence SpecialistMust Haves:Demonstrates experience working and communicating directly with stakeholdersManaging high volumes of dataR ScriptingPower BINice to Have:Public Sector ExperienceResponsibilities:Support client wide‑range business information requirements, implementing and supporting business intelligence software solutionsDevelop and support customized query applications that analyze key business dataDevelop and support guided analysis and drill‑down functionality, schedule report generation, and implement opportunity and key‑trend alertsProvide 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 objectivesGeneral 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 systemsExperience developing data extraction, transformation, and load (ETL) programs for daily and initial loads across relational and multi‑dimensional data storesExperience developing, implementing, and maintaining schedule/dependency logic for ETL scriptsExperience developing monitoring and error‑notification processes to ensure data is updated as designedExperience developing automation extraction, cleansing, and load scriptsExperience generating research models and reports (scheduled and ad‑hoc)Proven troubleshooting and analytical experienceExperience in process decomposition/mapping and business process re‑engineering, and complex data models using UMLExperience using development tools and business re‑engineering softwareExperience developing enterprise architecture deliverables (business, logical, and physical models)



based on Enterprise Application Processes and Modeling methodology and guidelinesKnowledge and experience developing data analysis applicationsKnowledge and understanding of Information Management principles, concepts, policies and practicesAbility to advise on developing and integrating process and information models to eliminate redundant business processesHands‑on experience documenting interface specifications between BI solutions and external applicationsExtensive experience with conceptual, logical, and physical data‑modeling tools such as Power Designer and VisioKnowledge of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standardsKey Deliverables:Support, influence, and impact the use of analytics and strategy across the enterpriseHelp develop and support analytics tools and best practices across the enterpriseProvide consulting services to ministry business partners regarding their information consumption and analytical needsParticipate in creating detailed plans and accurate estimates for development, testing, and implementation of projects or programsContribute to successful project completion by identifying risks and recommending mitigation strategiesParticipate in Proof of Concept or Proof of Technology projectsExpertise & 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 papersProvide advice and guidance in advanced statistical modeling, econometrics tools,



and techniquesProvide 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 teamsScope: 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 timeExperience working with and analyzing large, diverse data sets; identifying relationships and themes for policy developmentStrong knowledge of designing, developing, and implementing analytics solutions using administrative dataKnowledge 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)Robust interpersonal, written, and oral communication skills across all levelsExcellent analytical, problem‑solving, and decision‑making skills, and a team‑working attitudeOutstanding consulting and relationship‑management skills, ability to elicit requirements and provide effective guidanceExperience with analytical methods and tools (data mining, machine learning, NLP, etc.)Ability to manipulate and analyze complex, high‑volume data from structured and unstructured sourcesExperience designing high‑quality interfaces to present information meaningfully to end usersBroad understanding of data management, financial and business analysis, database architecture, and information visualizationProficiency in query languages and constructing complex query statements; experience in programming or scripting languagesStrong investigative and logical skills, proficiency in mathematics and statisticsAwareness of emerging BI trends and directionsKnowledge

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