Excel, Data Management and Power BI Consultant

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

Location: Toronto, ON (Hybrid, attendance on-site as required)
Language: French required for professional communication; bilingual French and English is an asset
Duration: 36 month contract, with possibility of extension
Background Check Requirement: Confidentiality, information security and system access requirements will be confirmed before the engagement begins

About the Opportunity
Were looking for 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 is a hands-on consulting opportunity where youll optimize existing tools, strengthen data quality and automate processes to reduce manual effort and the risk of errors.

Youll collaborate with internal users to understand current reporting processes and implement practical improvements across Excel, Power Query and Power BI. Just as importantly, youll document your solutions and share your knowledge so the team can confidently maintain them going forward.

Whats In It for You
Youll have the opportunity to make a visible impact by improving reporting processes that teams rely on every day. Youll work across Excel, data management and Power BI while bringing forward practical ideas, improving existing solutions and helping internal users become more self-sufficient.

Your Responsibilities

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

Skills and 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.

We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals.All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.