Hybrid Excel & Power BI Expert for Quality & Automation

Altis Technology; Toronto; Hybrid; CAD 70,000 - 100,000; Full time

Job summary

Altis Technology in Toronto is seeking an Excel, Data Management and Power BI Specialist to support a higher education organization focused on improving the efficiency, reliability and maintainability of its financial and operational reporting.

This hands-on consulting role will optimize existing tools, strengthen data quality and automate processes to reduce manual effort and errors. Youll document solutions and share knowledge to ensure long-term maintainability.

Qualifications

• 5+ years of relevant experience in data analysis, business intelligence, reporting automation or a related field.
• Advanced Excel expertise, including complex formulas, Power Query and Power Pivot.
• Hands-on Power BI expertise, including data modelling, DAX, report design and performance optimization.
• Experience with data cleansing, standardization, validation and quality control.
• Strong analytical skills with the ability to recommend pragmatic, maintainable solutions.
• Excellent communication, documentation and knowledge-transfer skills, with the ability to work professionally in French.
• Experience with finance or management reporting, SQL, Microsoft Fabric, Azure Data Services, Dataverse, ERP data or the broader public sector is an asset.

Responsibilities

• You'll review and optimize complex Excel workbooks, formulas, calculations, controls and performance.
• You'll identify and resolve data quality issues, including inconsistencies, duplicates and missing data.
• You'll create, correct and optimize Power Query transformations to automate reporting processes and improve refresh reliability.
• You'll review Power BI models, relationships, DAX measures, report design, visualizations and performance.
• You'll recommend and implement practical improvements to reporting tools, data structures and processes.
• You'll document solutions, transformations and controls while delivering knowledge-transfer sessions to internal users.

Skills

Advanced Excel

Power BI

Power Query

DAX

SQL

Data modelling

Data cleansing

French communication

Tools

Microsoft Fabric

Azure Data Services

Dataverse

Job description

Altis Technology in Toronto is seeking an Excel, Data Management and Power BI Specialist to support a higher education organization focused on improving the efficiency, reliability and maintainability of its financial and operational reporting.

This hands-on consulting role will optimize existing tools, strengthen data quality and automate processes to reduce manual effort and errors. Youll document solutions and share knowledge to ensure long-term maintainability.