Power BI Developer, Finance, Finance and Facilities Management

At Law Society of Ontario we believe in the importance of a collaborative and supportive work environment that provides high quality and professional service to the public, lawyers and paralegals, and other stakeholders. 

We are always on the lookout for exceptional individuals who are ready to make a meaningful impact, innovate and grow with us.  Our offering:

• We value each member of our team and invest in your professional learning and development.
• We provide access to the resources needed to support professional growth , mental health and well-being is a priority.
• Our competitive compensation package includes a defined contribution pension plan, health and dental benefits plan and a robust Employee and Family Assistance Plan (EFAP).
• Our progressive employment policies, high levels of employee engagement and the impressive architecture and beautiful grounds of the historic Osgoode Hall, there are many reasons to work at the Law Society. 

We hope you will consider joining the Law Society 

JOB PURPOSE

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.  

QUALIFICATIONS

• 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.

Microsoft Power BI Solution Development

• Designs, develops and maintains Power BI dashboards and reports.
• Work closely with the finance team and other stakeholders to gather reporting requirements.
• 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.
• Provides input on reporting needs and data structures.
• Coordinates routine reporting activities and responses to standard statistical information requests.
• Performs in-depth tests, including end-user reviews, for modified and new processes, and other post-implementation support.
• Coordinates the implementation of reporting structures in response to technical changes and change management initiatives.
• Provides training to finance team members on Microsoft BI to allow them to develop skills to create their own reports.

Performance Optimization and Maintenance

• Works closely with Finance, IT, BIOM and other departments, and external consultants to identify, diagnose, isolate, and resolve issues related to data organization, management, and reporting.
• Maintains current knowledge of emerging products, trends, and tools via technical journals, internet sources, conferences and courses, and networking with other professionals.
• Maintains awareness of organizational objectives related to current and future reporting needs of business users.
• 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.

Special Projects / Initiatives

• Researches, reviews, and analyzes the effectiveness of existing report procedures and develops strategies to enhance or further leverage these processes.
• Leads and contributes as a key facilitator by chairing meetings, identifying business needs, and promoting the effective use of data and reporting solutions to business process and performance objectives.
• Provides technical support on finance projects (e.g. key team member in the implementation of a budget and forecasting module).

Documentation Management and Governance

• Develops end-user procedures to facilitate best practices, use of reporting tools and data analysis techniques.
• Develops and shares expertise on internal business systems and maintains regular communication with team members regarding reporting, projects, and initiatives.
• Documents BI processes, data sources, and methodologies.
• Ensures compliance with data governance and security standards.
• Participates in audits and other reviews.

The Law Society has introduced a Distributed Workforce Model to leverage flexibility and agility, and to maximize employee productivity and engagement. Work arrangements will be determined by role and departmental requirements. The working arrangement for this position has been classified as hybrid, where the employee will regularly flex their work location between home and office. The specific application of this will be communicated to applicants contacted during the recruitment process.

The Law Society of Ontario is an equal opportunity employer that is committed to diversity and inclusion. We welcome applications from persons representing the diversity of our community. We are committed to creating an accessible, barrier-free and inclusive workplace and are committed to continuing compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Please make any requirement you may have for accommodation during the recruitment process known when contacted.

If you are unable to apply to this position due to the requirement for an accommodation of any kind, please email us at or call We appreciate all interest and will directly contact candidates under consideration.

The Law Society of Ontario does not use Artificial Intelligence (AI) tools to screen, assess, or select applicants during the hiring process at present.