Senior Reporting Analyst

January 2, 2018 | Markham

Miller Thomson LLP is one of Canada’s fastest growing national business law firms, with approximately 500 lawyers working in offices located in Vancouver, Calgary, Edmonton, Regina, Saskatoon, London, Waterloo, Guelph, Toronto, Markham, Vaughan and Montréal. Our consistent ability to provide practical, creative and cost-effective advice, combined with an unyielding service commitment to our clients and a strong dedication to our lawyers, staff and the communities in which we practice, gives us a unique position in the Canadian legal industry.

We are seeking a Senior Reporting Analyst to join our Finance team, who will work cross-functionally with our IT department. This individual will provide developmental and technical support of our financial system nationally and liaison with key members of the Information Technology department on accounting related projects.  The incumbent will be responsible for the development and maintenance of financial reports, dashboards, metrics, workflows and notifications; manage and maintain ethical walls and sanction lists; administrate financial database and backend systems, develop and/or set-up processes to assist with the insertion and extraction of key financial data and working with partners, department leads and 3rd party vendors to develop additional reports, tools and processes as required.

In this role, your tasks will include (but will not be limited to):

  • Develop and maintain monthly, quarterly and year-end closing reports, create additional billing metrics/performance reporting, provide analysis in support of business initiatives, resource allocation and various KPIs;
  • Work collaboratively with practice group and department leads to capture new reporting requirements for operational reports, metrics, and dashboards, and create new reporting, correct data elements and implement best practices for data formatting, charting and automation;
  • Perform ad-hoc reporting and analysis as required;
  • Work collaboratively with practice group and department leads to capture new reporting requirements for operational reports, metrics, and dashboards, and create new reporting, correct data elements and implement best practices for data formatting, charting and automation;
  • Perform daily system administrative tasks such as confirming successful execution of SQL Jobs, conflicts indexing, event and bill services;
  • Provide 2nd level support relating to Aderant Expert, troubleshoot and correct or liaison with the IT Department or Aderant as required;
  • Performs other related duties as required.

 Qualifications:

  • University degree in Finance, Accounting or Computer Science, coupled with a minimum of four years’ related work experience preferably in a professional services environment. An equivalent combination of education, training and experience is acceptable;
  • Thorough understanding of Aderant Expert and general accounting principles;
  • Proficiency with Microsoft Excel, SQL Server Reporting Services or equivalent spreadsheet and reporting tools;
  • Strong developmental skills in VBA, VB.Net, TSQL, SSRS, SSIS, Microsoft Query;
  • Strong Microsoft SQL Server technical and administrative skills;
  • Strong interpersonal, verbal and written communication skills;
  • Accuracy, attention to detail, strong analytical and problem solving skills;
  • Effective time management and organization skills with the ability to multi-task, work independently, within tight deadlines and after-hours;
  • Self-motivated with ability to perform with minimal direction.

If you are interested in this position, please forward your resume, quoting the above job title, to:

Attn: Specialist, Talent and Recruitment
Miller Thomson LLP
Scotia Plaza
40 King Street West, Suite 5800
P.O. Box 1011
Toronto, ON M5H 3S1
Fax: 416-595-8695
E-mail: recruitment@millerthomson.com

While we thank all applicants for their interest, due to the high volume of applications that we receive, we are unable to respond to queries individually and only those selected for an interview will be contacted. No phone calls or agencies please.

Miller Thomson will provide accommodations on request throughout the recruitment, selection and assessment process for applicants with disabilities. If you require accommodations, please inform our Talent Management department of the nature of accommodations that you may require, to ensure your equal participation.