RQ10675 - Business Intelligence Specialist - Senior

Responsibilities:

• Lead the report conversion activities from BOEXI to Power BI reports estimated up to 100 for 2026\-27 fiscal year
  


• Lead client\-facing workshops, requirement sessions (e.g., Key Performance Indicators, success criteria, report design, and solution design reviews) to ensure clarity, alignment, and successful BI delivery
  


• Provide clients with technical and strategic options for managing business\-related data to improve quantitative analysis, operational understanding, and measurement of business objectives
  


• Develop and support customized query applications that analyze key business data and drive actionable insights
  


• Architect, design, and deliver high\-impact, user‑centric dashboards, operational reports, and analytical applications primarily in Power BI or other BI platforms (e.g., Amazon Quicksight, Tableau, etc.) while meeting Web Content Accessibility Guidelines (WCAG)
  


• Build advanced analytical functionality, including guided analysis, drill\-down/drill\-through experiences, routine scheduling, automated notifications, and “opportunity” and “key\-trend” alerts
  


• Provide 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 data integration, data cleansing, data modeling, and analytics activities in partnership with data engineering teams
  


• Create and maintain enterprise semantic models, certified datasets, and reusable reporting assets for scalable consumption
  


• Design and refine analytic data structures—including dimensional models, curated datasets, and Lakehouse/Warehouse layers—to support reporting performance and reliability
  


• Develop and maintain feedback loops and corrective processes to identify, surface, and remediate corrupt or inconsistent data
  


• Lead end‑to‑end performance optimization efforts across data models, dataset refreshes, data pipelines, queries, and visual layers
  


• Diagnose complex performance bottlenecks and implement advanced optimization techniques (aggregation strategies, partitioning, query tuning, semantic model refinement)
  


• Establish enterprise performance standards, best practices, and measurement baselines
  


• Lead major BI modernization initiatives, including the migration of legacy BI assets (e.g., SAP Business Object, Cognos, etc.) to modern cloud BI solutions such as Power BI
  


• Redesign legacy business logic into optimized, governed semantic layers using current architectures (Fabric, Azure, AWS, Databricks)
  


• Create migration frameworks, mapping templates, transformation documentation, and validation processes—including structured data parity testing
  


• Drive standardization across KPI definitions, metadata documentation, naming conventions, and BI lifecycle processes
  


• Implement monitoring, usage governance, security best practices, and documentation across BI platforms.
  

General Skills:

• Experience with major business intelligence platforms, including:
  

• Expert‑level in Power BI (advanced DAX, Direct Lake, semantic modeling, incremental refresh)
  


• SAP BusinessObjects (SAP BO) such as providing operational support to existing Crystal Reports
  

• Skilled in designing KPI scorecards, trend visualizations, operational dashboards, and drill‑down analytical applications
  


• Experience developing scheduled, ad‑hoc, and alert‑driven reports across multiple BI platforms
  


• Expert‑level SQL skills, including performance tuning and execution plan analysis
  


• Experience analyzing source system data for:
  

• Missing/null values
  


• Duplicate meanings
  


• Invalid values
  


• Data completeness and consistency issues
  

• Experience developing feedback loops and remediation processes to fix corrupt data
  


• Hands‑on experience developing:
  

• Data extraction, transformation, and load programs
  


• Daily incremental and initial loads
  


• Structured, semi‑structured, relational, and multidimensional sources
  

• Skilled in:
  

• Building schedule and dependency logic for ETL workflows
  


• Automating extraction, cleansing, transformation, and load processes
  


• Creating monitoring, logging, and error notification frameworks
  

• Experience designing robust, maintainable pipeline architectures with audit, retry, and recovery capabilities
  


• Proven ability to optimize:
  

• Semantic models
  


• Pipeline performance
  


• Dashboard rendering times
  


• Dataset refresh times
  

• Experience diagnosing cross\-system performance issues (ETL → model → report)
  


• Strong analytical and problem‑solving skills with experience resolving multi\-layered BI issues
  


• Ability to identify root causes, propose solutions, and implement corrective actions across data, ETL, and reporting layers
  


• Experience using development tools to support CI/CD processes and business process re‑engineering methodologies
  


• Experience with using cloud platforms such as:
  

• Microsoft Fabric & Azure
  

• Microsoft Fabric (Data Factory, Dataflow Gen2, Lakehouse/Delta, Spark, Warehouse)
  


• Azure Data Factory
  


• Azure SQL Database
  


• Azure Data Lake (ADLS Gen2)
  


• Power BI integration with Azure data platforms
  

• Databricks
  

• Apache Spark (PySpark/Scala)
  


• Medallion architecture (Bronze/Silver/Gold)
  


• Delta Lake optimization techniques
  


• Building Databricks jobs, workflows, and automated orchestration
  

• AWS
  




• AWS Glue, EMR (Spark/Hive), Lambda, Step Functions, Kinesis, S3
  

• Proven ability to propose cost‑effective, sustainable BI solutions while balancing total cost of ownership, performance, scalability, and maintainability
  


• Proven experience of tracking and reporting on the total cost of ownership of BI solutions and recommend options that balance cost, performance, scalability, and maintainability
  


• Ability to lead workshops, training sessions, and cross‑department collaboration
  

Desirable Skills:

• Experience with additional BI platforms:
  

• Amazon QuickSight (SPICE optimization, parameters, RLS)
  


• Tableau (LOD expressions, extract tuning, advanced interactivity)
  

• Mentorship experience within BI or analytics teams
  


• 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 identify and eliminate redundant business processes
  


• Hands‑on experience working with stakeholders to develop and document interface specifications between BI 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
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• Demonstrates advanced knowledge in BI tools (e.g., Power BI and SAP BO’s Crystal Reports), data modeling, ETL processes, data visualization, and reporting
  


• Expert‑level SQL skills, including performance tuning and execution plan analysis
  


• Experience with cloud platforms: Microsoft Fabric & Azure, Databricks, AWS
  


• Experience diagnosing cross‑system performance issues
  


• Provides clients with approach options and tools for managing business‑related data for quantitative analysis and operational impact
  


• Effectively communicates complex technical concepts to technical and non‑technical audiences
  


• Looking for someone who is independent and proactive who can be an asset to the team
  

Skill Set Requirements:

Programmer and Development Skills:                                                                                                                     

• Experience in systems design, configuration, integration and development, IT security, programming concepts, languages and related methods, techniques, practices and standards in JAVA, J2EE, JSF, HTML/DHTML, XML/XSL
  


• Hands on experience in n\-tier web\-based application development using Oracle database.
  


• Development experience using emerging technologies such as Web Services, web responsive frontend development, AODA compliant solutions.
  


• Experience in using open\-source software such as Spring, myBatis, Bootstrap, jQuery
  


• Experience using reporting tools such as Jasper.
  


• Demonstrated experience directly supporting the SDLC (agile/iterative) and implementation of business\-critical software applications and systems.
  


• Hands on experience with Oracle SQL scripts and good understanding of RDBMS
  

Analytical and Problem\-Solving Skill:

• Analytical skills to assess the feasibility of a broad range of options, make recommendations and develop customized strategies to resolve unique problems.
  


• Consultation, interpersonal and teamwork skills to discuss client requirements, lead discussions of system development options and technical process and to work effectively with colleagues and clients.
  


• A team player with a track record for meeting deadlines
  

Public Sector Experience:

• Experience with Public Sector application and information architecture, methodologies and GO–ITS standards would be an asset.
  


• Familiar with Public Sector Threat Risk Assessment (TRA) and Privacy Impact Assessment (PIA) process