Financial Systems Specialist

The Law Office Management Association (TLOMA); Toronto; On-site; CAD 100,000 - 120,000; Full time

Job summary

Blake, Cassels & Graydon LLP (Blakes) in Toronto seeks a Financial Systems Specialist to join the Information Technology team. You will create, implement and maintain financial information systems, supporting users and ensuring stability, security and performance of the firm’s environment.

The role emphasizes SQL development, system upgrades and collaboration with IT security. Four years of experience with financial systems and familiarity with Aderant/Elite, Chrome River and Power BI are assets.

Qualifications

• Bachelor's degree in computer science or related field required.
• Minimum of four years of experience with financial/accounting information systems and technical support.
• Experience with Aderant or Elite, Chrome River, Intapp Time is an asset; dashboard/reporting with SQL and Power Apps is beneficial.

Responsibilities

• Research, develop and implement new technology solutions to meet business objectives.
• Develop and maintain complex SQL queries, stored procedures, views and functions.
• Perform SQL Server administration and system maintenance.
• Provide technical end-user support across the firm.
• Assist with system upgrades and patches from vendors.
• Troubleshoot issues and coordinate with IT and external vendors.
• Work with IT security to ensure servers comply with security protocols.

Skills

SQL scripting

Python

Power Automate

Power BI

SSIS/SSRS

Disaster recovery

Team collaboration

Attention to detail

Education

Bachelor's degree in computer science or related field

Tools

Aderant/Elite accounting software

Chrome River

Intapp Time

Job description

Blake, Cassels & Graydon LLP (Blakes), one of Canada's largest and most successful law firms, is currently looking for a Financial Systems Specialist to join the Information Technology (IT) department in Toronto.

Reporting to the Manager, Financial Systems, the Financial Systems Specialist will be responsible for creating and implementing systems solutions, maintaining the functionality and integrations of existing information systems, and supporting users of the Firm's financial systems and certain management information systems. The role researches, develops and deploys technology solutions to meet business needs, provides technical support and troubleshooting, and helps ensure the stability, security and performance of the Firm's financial systems environment.

Primary Responsibilities Include

• Researching, developing and implementing new or improved technology solutions to meet business objectives, considering the impact and implications on other systems
• Developing and maintaining complex SQL queries, stored procedures, views and functions
• Performing SQL Server administration and system maintenance
• Providing technical support to the end-user community
• Assisting with the implementation and testing of system upgrades and software patches from vendors
• Diagnosing, troubleshooting and resolving technical issues to ensure appropriate solutions are implemented in a timely manner, including engagement of various IT teams and external vendors
• Working collaboratively with the IT security team, ensuring that all development and production servers are regularly updated and in compliance with the Firm's security protocols
• Assisting with regular systems audits, user-access reviews and data cleanups

Qualifications

Education/Experience:

• Bachelor's degree in computer science or related field is required
• Minimum of four years of experience working with financial/accounting information systems, designing technical solutions and providing overall technical support, with proven experience in process-improvement and automation-related projects
• Experience working with Aderant or Elite accounting software, Chrome River, Intapp Time would be an asset
• Experience in developing custom dashboard and reporting solutions involving SQL and Power Apps, including Power BI and Power Automate, would be an asset
• Experience in cloud-related solutions using Microsoft Azure Data Services and Boomi would be an asset

Skills/Abilities

• Strong verbal and written communication skills
• Excellent problem-solving, analytical and critical thinking skills
• Working knowledge of SQL scripts, Python, VB, Power Automate, Power BI, SSIS and SSRS
• Strong understanding of system disaster recovery concepts
• Ability to work collaboratively with Finance, Information Technology and other business services departments throughout the Firm
• Detail-oriented, with the ability to complete work under pressure and with minimal supervision
• Familiarity with data consolidation and integration technology and strategies is an asset
• Ability to exercise judgment in analyzing business requirements, identifying system-related issues and determining appropriate solutions

Compensation

The anticipated annual salary for the Financial Systems Specialist position is $100,000 - $120,000. Salary levels will be determined commensurate with internal equity, market equity and experience.

Other Relevant Application Information

Blakes welcomes applications from all qualified applicants. The Firm is committed to maintaining an inclusive work environment composed of people with diverse perspectives, backgrounds, identities and cultures. The Firm provides accommodation for applicants with disabilities and in respect of other protected grounds during the recruitment process in accordance with applicable laws. Please contact us to request accommodation.

While our experienced team will select and interview successful candidates, Blakes may use Artificial Intelligence (AI) to assist with shortlisting, screening and evaluating applications.

Who We Are

At Blakes, we care about our people. We are committed to providing exceptional experiences for our clients and employees. As a winner of Canada's Top 100 Employers, Canada's Best Diversity Employers and Greater Toronto's Top Employers awards, we understand the importance of fostering an inclusive workplace environment that brings out the best in each person. Our success as a firm starts with hiring top talent, retaining our people and helping them thrive.