Senior Business Intelligence Analyst, Business Innovation and Operations Management (Hybrid, To[...]

Law Society of Ontario; Toronto; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

The Law Society of Ontario seeks a Data Analyst to perform complex data analysis and reporting to support decision-making. The ideal candidate will have at least 5 years of relevant experience and a strong background in various data tools, including SQL and Power BI. This hybrid role involves collaborating with different business groups to meet analytical and reporting needs while keeping up with industry trends.

Benefits

Equal opportunity employer, diversity and inclusion

Flexible working arrangements

Support for accessibility and accommodations

Qualifications

• Minimum 5 years of experience in data analysis and project management.
• Proficiency in SQL and data modeling is essential.
• Experience in a legal or regulatory environment is preferred.

Responsibilities

• Designs and implements BI and reporting solutions.
• Analyzes complex data to meet reporting needs.
• Liaises with business groups to provide data insights.

Skills

Data analysis

Business analysis

Analytical skills

Problem-solving

Communication

Presentation skills

Education

3 year college program in Computer Science, Mathematics, Statistics

Tools

SharePoint

Excel

SQL

Power BI

Python

R

Job description

OVERVIEW

JOB PURPOSE

Performs complex data, statistical, and business analysis to elicit and document data related requirements, design reporting solutions, draw key insights for data-driven decision-making, and meet reporting requirements for internal and external stakeholders.

QUALIFICATIONS

• Requires completion of a 3 year college program (in a specialized / technical / trade discipline) in Computer Science, Mathematics, Statistics, or a related discipline.
• Requires a minimum of 5 years of data analysis, business analysis, and project management, preferably in a legal or regulatory environment.
• Professional knowledge
  • Data analysis, business analysis, and analytics.
• Technical skills
  • Advanced proficiency in SharePoint and Excel functions (e.g., pivot tables, VBA macros is preferred.)
  • Proficiency in SQL and data modelling
  • Microsoft 365 ecosystem (e.g., Dynamics CRM, Power Platform (e.g., PowerBI, PowerApps,PowerAutomate, Excel PowerQuery), etc.).
  • Designing and creating ad hoc, automated, and interactive reports and dashboards.
  • The application of technical solutions to work processes and procedures.
  • Relational database models (e.g., DB2, SQL Server, Dataverse, Azure Synapse, etc.) and applications (e.g., DBeaver, SSMS, Azure Data Studio, etc.)
  • Data glossaries, dictionaries, and entity relationship diagrams.
  • Programing languages proficient in data analysis such as Python, R, DAX, M, etc.
  • Experience with Azure DevOps would be an asset.
• Competencies
  • Analytical and problem-solving skills
  • Project coordination, prioritization, and time management skills
  • Business acumen and data-driven decision-making
  • Interpersonal, oral, and written communication, and presentation skills
  • Organizational and multitasking skills with attention to detail

KEY ACCOUNTABILITIES

Client / Customer Service Delivery

• Liaises with business groups across the organization to respond to requests for data and statistics, elicit and document data requirements, complete data analyses and design reports.
• Facilitates the identification, diagnosis, isolation, and resolution of complex data and reporting problems in collaboration with the Manager.
• Applies analytical and problem-solving skills to analyze and draw key insights from data to meet reporting needs, respond to requests for data / statistics, and make recommendations to the Manager.
• Provides regular reporting and status updates (such as monthly and quarterly reporting) to the Manager and other business groups.
• Develops and implements BI and reporting solutions such as CRM dashboards and reports on a variety of BI tools (e.g., Excel, Cognos, Python, PowerBI, SSRS, etc.).

Research

• Remains abreast of new trends and tools in the industry via technical journals, Internet sources, conferences and courses, and networking with other professionals.
• Ensures awareness at all times of organization objectives and legislation affecting the Law Society, with respect to current and projected plans for new policies and projects, and the provision of data and reporting functionality across the organization.

Special Projects & Initiatives

• Completes projects and tasks as assigned which may include technology projects related to the implementation of new data requirements or reporting solutions.
• Builds relationships with staff and managers based on personal expertise and best practices with respect to data, analytics, and reporting.
• Provides regular reports to the Manager regarding the status of assigned projects and initiatives.

Team Membership

• Draws key insights from data, legislation, and business process to assist the Manager in making informed decisions and to facilitate data-driven decision-making across the organization.
• Works closely with business groups to respond to requests for data and statistics, document and validate reporting requirements, analyze data, and design reports.
• Shares expertise regarding applications, data, and analytics, and provides recommendations related to data or reporting.
• Works alongside technology project teams related to the implementation of new data requirements or reporting solutions, works closely with the PMO and IT to implement those solutions and validate functionality.

WORKING ARRANGEMENT

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.

OUR COMMITMENT

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 [e-mail] or call 416-947-3475. We appreciate all interest and will directly contact candidates under consideration.