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

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.

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 hr@lso.ca or call 416-947-3475. We appreciate all interest and will directly contact candidates under consideration.