Enterprise Application Analyst

Osler; Toronto; Hybrid; CAD 120,000 - 135,000; Full time

Benefits offered by this job

Hybrid work arrangement

Remote work up to 1 day per week

Job summary

Osler, Hoskin & Harcourt LLP is seeking an Enterprise Application Analyst to implement, administer, maintain, support and develop the firm’s Enterprise Systems including Aderant Expert and related tools. The role requires SQL expertise, strong accounting knowledge, and experience with reporting tools such as SSRS.

Hybrid work arrangement with a requirement to work primarily in the office; remote work up to 1 day per week is available.

Qualifications

• University degree in Accounting or Computer Science.
• Five years of experience with financial systems or enterprise applications.
• Experience in the legal or professional services industry preferred.

Responsibilities

• Assist in ongoing function of financial systems; participate in new projects and upgrades.
• Troubleshoot and diagnose problems related to application systems, performance, and functionality.
• Support full lifecycle: requirement gathering, design, programming, integration, testing.
• Perform data analysis to identify issues and bugs and resolve them.
• Create and maintain documentation and training for the firm’s financial systems.

Skills

Enterprise applications maintenance

Accounting procedures

Troubleshooting

SQL & reporting

PowerShell scripting

Communication

Project management

Education

University degree in Accounting or Computer Science

Tools

Aderant Expert

Excel

SSRS

SQL Server

T-SQL

PowerShell

Job description

Osler, Hoskin & Harcourt LLP is one of Canada’s leading business law firms. Advising many of Canada’s corporate leaders, as well as U.S. and international parties with extensive interest in Canada, our more than 1,000 firm members are based in offices in Toronto, Montréal, Ottawa, Vancouver, Calgary and New York.

Osler prides itself on attracting and maintaining some of the brightest talent in the legal arena. Our lawyers, students, management and staff have created a unique firm culture which nurtures mentoring and the exchange of ideas. Osler is a dynamic and exciting place to begin a career or carve out a new path.

Reporting to the Manager, Enterprise Applications, the Enterprise Application Analyst will be responsible for the implementation, administration, maintenance, support and development of the Firm’s Enterprise Systems including but not limited to Aderant Expert, Expert Image, Chrome River, Prebill Viewer, Intapp Intake, Intapp Terms, Intapp Time, Intapp Walls, and custom solutions requiring SQL expertise.

This job posting is for an existing vacancy.

Major Responsibilities

• Assists in the on-going function of the financial systems by participating in new projects, developing and maintaining existing systems, maintaining system security, and assisting in implementing upgrades to financial systems
• Troubleshoot and diagnose problems related to application systems, software performance & functionality
• Assists Finance & Accounting and Information Services Departments with executing all stages of enterprise application lifecycle including requirement gathering, design, programming, integration, and testing activities
• Perform data analysis to facilitate and identify applications’ issues & bugs and resolve them
• Develop documentation, training, and development of users regarding the firm’s financial systems and data
• Create, review and maintain method of procedure, build, system process and all internal administration documents for the system of their responsibility
• Provide guidance and recommendations for performance optimization of firm’s enterprise financial applications
• Administers and monitors Financial Systems (including Aderant Expert, Expert Image, Chrome River, Prebill Viewer, Intapp Intake, Intapp Terms, Intapp Time, Intapp Walls and other custom developed applications) to ensure database integrity, system health, control and efficiency
• Coordinate with Finance & Accounting and Information Services teams to analyze information technology needs and work toward recommending solutions that meet sponsor/stakeholder needs

Position Requirements

Education and Experience

The position requires a University Degree in Accounting or Computer Science. Five years of experience with financial systems or equivalent enterprise applications and databases, or an equivalent combination of education, training and experience considered. Experience in the legal industry or professional services industry is strongly preferred.

Knowledge and Skills

• Exposure to enterprise financial applications’ maintenance and support with a professional services firm is required
• Knowledge of accounting procedures, including budgeting concepts and finance and accounting principles
• Troubleshooting skills to solve system problems and ability to link components within different enterprise systems (e.g., how a transaction flows through to expense systems, and general ledger)
• Experience with Aderant Expert and other financial systems in the legal space with advanced Excel and SSRS skills, or similar business reporting tools
• Advanced knowledge and skill in database reporting and report writing tools, advanced user-level knowledge of Microsoft SQL Server and TSQL, working with multiple systems and points of integration, and experience with design and implementation of financial and other enterprise systems
• PowerShell and scripting expertise to facilitate automation, monitoring, configuration and custom solutions
• Excellent oral and written communication and interpersonal skills with technical/non-technical users for knowledge transfer, troubleshooting, and requirements gathering
• Ability to work both independently and in a team environment
• Time management and organizational skills to effectively multi-task and prioritize among many demands
• Project management experience including evaluating client requirement, time estimates, setting tasks, determining priorities, tracking progress toward completion
• Maintains current knowledge of changes in relevant technology and databases

Compensation:

The range of expected compensation for this position is $120,000 - $135,000 annually. Compensation offered will be based on a variety of factors including job-related knowledge, education, skills and experience.

We are currently working in a hybrid work arrangement, which includes a requirement to work primarily in the office and flexibility to work remotely up to 1 day per week.

Accessibility and Accommodation

We thank all applicants for their interest in Osler; however, only chosen applicants will be contacted. Osler is committed to fostering a diverse and inclusive work environment, and we welcome and encourage applications from people with disabilities and people with diverse backgrounds, identities, and cultures. Accommodations are available upon request for candidates in all phases of the selection process.

Background and Reference Checks

Please note that any offer of employment will be conditional upon background and reference checks, including a criminal record check, credit check, and employment and educational verifications.

Please note that we use artificial intelligence to screen, assess or select applicants for the position.