Financial Report Developer / Systems Administrator, Finance, Finance and Facilities Management (Hybrid, Toronto) Job in Toronto for Law Society of Ontario | Jobs.ca
0

Financial Report Developer / Systems Administrator, Finance, Finance and Facilities Management (Hybrid, Toronto)

July 22 2022
Industries Legal
Categories Actuarial, Statistics, Economy, Banking, Financial, Information Technology, IP, Patents, Trademarks, Legal, Paralegal, Management, Administration, Programming, Development, System administrator
Toronto, ON

JOB SUMMARY:


The Financial Report Developer / Systems Administrator is responsible for developing and administering the financial reporting for the Law Society, and, by assessing reporting needs based on feedback from managers and employees, develops regular and ad hoc reports using Cognos, and provides assistance in the development of reports for users within Finance. This position will support the Finance department data and reporting needs and will assist in the development and design of data structures to support financial reporting. This position will also include responsibility for system administration for various Financial Modules, which includes Infinium, XM Expense Management, and Automated Invoice Management. This position required a strong working relationship with other Finance members and with business users.


QUALIFICATIONS REQUIRED:

  • A university degree in computer sciences/ business/ accounting including relevant, ongoing education in reporting, statistical analysis, database design and management, predictive analytics, network and client server technology.
  • Relevant knowledge in general accounting is also required.
  • Completed or working towards at least one widely-recognized vendor certification (IBM, Microsoft, Oracle) in a database-related area, or other relevant technology certifications.
  • Minimum 5 years’ experience providing technology-supported financial reporting services in a centralized accounting environment.
  • Minimum 5 years experience with enterprise reporting tools such as Cognos Reporting tools, Cognos Framework Manager, Microsoft Power BI, SAP Business Objects, Oracle BI or Tableau.

  • Minimum 5 years of SQL (IBM DB2, Microsoft SQL Server, etc.), including complex queries.

  • Minimum 3 years of Enterprise Data Warehouse data models and dimensional modeling concepts.

  • Must have demonstrated experience in supporting enterprise reporting solutions, with a focus on data quality, performance, and scalability.
  • Solid understanding of general accounting functions, including GAAP / CICA guidelines, accounts payable, financial reporting and internal controls.
  • Speaks and writes in a clear, articulate manner.
  • Knowledge of current trends in reporting platforms/systems and their practical applications, as they relate to the scope of responsibilities.
  • Demonstrated ability to meet tight deadlines, follow development standards and effectively raise critical issues with potential solutions.
  • Reasons through moderately complex spoken and written information.
  • Extensive knowledge and experience with enterprise reporting tools such Cognos Reporting tools, Cognos Framework Manager, Microsoft Power BI, SAP Business Objects, Oracle BI or Tableau.

  • Broad experience in supporting enterprise reporting solutions, with a focus on usability, data quality and performance.

  • Strong experience with SQL (IBM DB2, Microsoft SQL Server, etc.), including complex queries.

  • Extensive knowledge of relational and dimensional data modelling. Knowledge of data architecture principles and best practices, including architectures supporting different data consumption requirements: operational data store, data warehouses, data marts, and analytical data stores.

  • Strong knowledge of financial database and reporting software applications; experience with Microsoft Dynamics an asset.

  • Solid understanding of: AS400, SHOWCASE, Microsoft Office (in particular Excel and Access), Adobe, JavaScript.

  • Familiarity with network applications development, systems/network management tools, security protocols, documentation standards.

Client / Customer Service Planning

  • Analyzes data models and structures and develops Cognos Framework packages and then utilizes the packages to support the design and creation of Cognos reports and dashboards that fulfill business requirements.
  • Together with the Finance Managers, assesses client department financial reporting requirements, helps define and develops client accessible reporting tools, and contributes to the development and communication of reporting standards.
  • Performs detailed data analysis, understands data structure and content and writes complex SQL queries that address business reporting needs.
  • Assists team members in the Finance department, as well as internal clients throughout the Law Society in the effective use of the Cognos reporting tool.
  • Sets and maintains security protocols (access controls, passwords) with respect to use and distribution and documentation of queries and approved reports, and monitors client financial reporting for compliance with approved standards.
  • Remains current on financial reporting tools and products, and collaborates with Information Technology colleagues and vendors to ensure optimal financial reporting capabilities.

Client / Customer Service Delivery

  • Orients employees and managers on financial reporting application functionality, data available for extraction and custom reporting capabilities.
  • Meets with employees and managers to discuss reporting needs and data requirements, programs queries for new / modified financial reports, and develops and implements security protocols and related documentation for all queries and reports in use.
  • Assists employees and managers with applications troubleshooting, and coordinates escalated problem solving with Information Technology and vendors as appropriate.
  • Completes systems back up and disaster recovery procedures, and performs day to day system maintenance, diagnosing and resolving application issues.
  • Monitors for upcoming upgrades, patches or fixes to financial applications, analyzes their impact and advises Finance and Information Technology colleagues as to the best course of action.
  • Participates in reactive/proactive risk management, ensures checks and balances across own work and in contingency planning.

Research

  • Identify, research and present current, emerging and innovative technologies and/or processes to improve the efficiency, reliability, and/or effectiveness of the Law Society’s reporting platform.

Special Projects and Initiatives

  • Contributes to the identification and implementation of technological improvements to financial data analysis and reporting, and represents the Finance department on projects potentially affecting financial reporting modules.
  • Participates in complex reporting-related projects.
  • Contributes to the development and implementation of team level procedural/process improvements.
  • Ensures that enterprise solutions are in keeping with Finance division and client department needs.

Team Membership

  • Works closely with other members of the Finance team in the identification, diagnosis, isolation and resolution of complex problems and implementation of reporting related projects.
  • Develops and shares expertise in report design and optimization, and keeps team members up to date regarding systems issues, problems and initiatives.
  • Maintains up to date knowledge of financial systems, and shares expertise with the team in order to be responsive to user documentation, troubleshooting and training requirements.
  • Provides orientation and ongoing instruction and assistance to end-users. Develops working relationships with multiple level contacts across multiple departments to exchange/report/present complex information.
  • Advise on inquiries/develop and propose complex solutions.

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.

Apply now!