Sql jobs in Canada

OVERVIEW

JOB PURPOSE:

The Business Intelligence Analyst gathers, examines, interprets, evaluates, reports, and analyzes data captured across the Law Society to draw key insights and support data-driven decision making. Responds to requests for data and statistics, eliciting and documenting data related requirements, assessing data issues, and producing analyses and reports. Facilitates the completion of assigned projects and tasks by coordinating stakeholder relationships with competing priorities and expectations.

QUALIFICATIONS REQUIRED:

• Minimum of a 3 year college program (in a specialized / technical / trade discipline) in Computer Science, Mathematics, Statistics, or a related discipline.
• Minimum of 3 years’ experience in business / data analysis, preferably in a legal or regulatory environment.
• Project management, business intelligence, and reporting and information systems.
• Providing high-quality internal customer service.
• Business unit processes, workflows, and management control structures.
• Experience with Microsoft Office Suite / 365 (Word, Excel, PowerPoint, etc.).
• Advanced proficiency in SharePoint and Excel functions (e.g., pivot tables, vlookup, etc.).
• The application of technology solutions to work processes / procedures.
• Knowledge of Databases and data analysis tools (e.g., SQL Server, Microsoft Dynamics CRM, PowerAPPs, PowerAutomate, Excel PowerQuery, etc.).
• Knowledge of Business intelligence software (e.g., IBM Cognos, Power BI, etc.)
• Proficiency in SQL and Data Modelling.
• Experience with AzureDevOps would be an asset.

KEY ACCOUNTABILITIES

Client/Customer Service Planning

• Develops working relationships with business units across the organization.
• Contributes to ongoing continuous improvement activities.
• Coordinates testing for data and reporting projects in collaboration with CDAR Team members and IT; communicates identified issues and recommends and/or implements solutions.

Client/Customer Service Delivery

• Uses business intelligence software to analyze and respond to internal and external (e.g., licensees, members of the public) requests for data/statistics.
• Provides timely reviews of reports and other documents to identify data requirements, analyze issues, and recommend solutions to the Manager.
• Prepares statistical analyses and reports for the Manager, CDAR.

Performance Goals, Targets and Standards

• Assists the Manager with establishing and monitoring work completion against performance goals and standards to ensure quality, accuracy, and timeliness.
• Coordinates the planning, allocation, and prioritization of resources engaged in CDAR operations.
• Tracks end user issues with databases and IT systems to recommend and implement solutions to functional and operational issues.
• Works with staff across CDAR to coordinate major projects and initiatives.

Team Membership

• Draws key insights from data, legislation, and business processes to assist the Manager in making informed, data-driven decisions.
• Works closely with business groups across the organization 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 to improve data or reporting.
• Works closely with the Portfolio Management Office and IT to implement 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 hr@lso.ca or call 416-947-3475. We appreciate all interest and will directly contact candidates under consideration.