Transforms raw financial and operational data into actionable insights by designing and developing interactive dashboards and reports using Microsoft Power BI.
Enables data-driven decision-making by collaborating with Finance, IT, Business Information and Operations Management (BIOM) and other stakeholders, ensuring data accuracy, and optimizing reporting solutions for performance and scalability.
Works with data from Finance and Operations (F&O), XM Invoice and Expense Management, and other systems, and trains team members to build self-service reporting capabilities.
Designs, develops and maintains Power BI dashboards and reports.
Gathers reporting requirements and translates business requirements into technical specifications.
Creates data models and performs Extract, Transform and Load (ETL) processes.
Ensures data accuracy and security on reports and dashboards.
Provides consultation on data visualization best practices.
Prepares and delivers reports, recommendations, or alternatives for improving processes in reporting.
Advises the Finance management team on best practices for optimizing organizational reporting functions and capabilities.

Requirements

Requires completion of a 3 year college program (in a specialized / technical / trade discipline) in Accounting, Information Technology, Data Analytics, or a related discipline.
Microsoft Certified: Power BI Data Analyst Associate (preferred, working toward or will take this certification).
Requires a minimum of 5 years’ experience in reporting and data analysis, with a minimum of at least 2 years of hands-on experience with Power BI development, Power Automate and Azure Data Services.
Experience in business analysis is an asset.
Strong understanding of data modeling, ETL processes, and data visualization principles.
Extensive knowledge with data management, report design, data analysis, capturing and documenting business requirements.
Extensive knowledge in data and business analysis, report writing, technical requirements analysis, business process modeling / mapping, methodology development, and data modeling.
Knowledge of performance metrics, ROI analysis, and business process mapping.
Familiarity with basic financial statement reports and concepts.
Proficiency in Microsoft Office Suite / 365 (Word, Excel, PowerPoint, etc.)
Proficiency in Power BI Desktop, Power BI Service and Power Query.
Experience with SQL and relational databases.
Experience with Data Analysis Expressions (DAX) for advanced calculations.
Exposure to Azure Synapse or Data Lakes.
Familiarity with data warehousing concepts and BI architecture.

Benefits

health and dental benefits plan
defined contribution pension plan
robust Employee and Family Assistance Plan (EFAP)
professional learning and development opportunities
mental health and well-being prioritization
progressive employment policies

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills

Power BIETLdata modelingSQLData Analysis Expressions (DAX)data visualizationreport writingbusiness process mappingdata analysisreport design

Soft skills

collaborationconsultationcommunicationproblem-solvingorganizational skillsattention to detailtrainingdecision-makinganalytical thinkingstakeholder engagement

Certifications

Microsoft Certified: Power BI Data Analyst Associate