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 usercentric 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 structuresincluding dimensional models curated datasets and Lakehouse/Warehouse layersto support reporting performance and reliability
  
• Develop and maintain feedback loops and corrective processes to identify surface and remediate corrupt or inconsistent data
  
• Lead endtoend 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 processesincluding 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:
  

• Expertlevel 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 drilldown analytical applications
  
• Experience developing scheduled adhoc and alertdriven reports across multiple BI platforms
  
• Expertlevel 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
  
• Handson experience developing:
  

• Data extraction transformation and load programs
  
• Daily incremental and initial loads
  
• Structured semistructured 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 problemsolving 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 reengineering 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 costeffective 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 crossdepartment 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
  
• Handson 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 BOs Crystal Reports) data modeling ETL processes data visualization and reporting
  
• Expertlevel SQL skills including performance tuning and execution plan analysis
  
• Experience with cloud platforms: Microsoft Fabric & Azure Databricks AWS
  
• Experience diagnosing crosssystem performance issues
  
• Provides clients with approach options and tools for managing businessrelated data for quantitative analysis and operational impact
  
• Effectively communicates complex technical concepts to technical and nontechnical 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 GOITS standards would be an asset.
  
• Familiar with Public Sector Threat Risk Assessment (TRA) and Privacy Impact Assessment (PIA) process