Manager Ii, Tangible Capital Assets

**Summary of Duties**
Reporting to the Director, Capital Assets & Projects, the Manager, Tangible Capital Assets (Systems Integration) is responsible for developing and implementing processes to integrate Tangible Capital Assets data from legacy systems into Enterprise Report Planning (ERP) software (JD Edwards), ensuring a robust asset management framework; provide accurate record of all Tangible Capital Assets; and establish processes, policies, and procedures utilized across Service Areas for controlling, planning and reporting on Tangible Capital Assets, in addition to providing financial analysis and guidance to Service Areas.

**Work Performed** Systems Accountabilities**
- Develop, implement and maintain business processes and associated systems with the support of ITS and Service Areas, to ensure accurate recording of all Tangible Capital Assets.
- In conjunction with the Information Technology Services (ITS) Division, plan and implement the system foundation, including both short and long term strategies for integrating legacy systems into current ERP (JD Edwards).
- Develop processes that allow for effective migration of Tangible Capital Assets data to ERP software.
- Develop appropriate data capturing and reporting functions.
- Support system functionality by liaising with internal and external users of the system on systems based reporting requirements of Tangible Capital Assets.
- Control, define, test and implement data integrity through formulas or other mechanisms.
- Contribute to quality system documentation for technical support and training purposes.
- Support and guide aspects of the data and data collection processes used within Tangible Capital Assets information systems and databases.
- Support and undertake asset data loading, extraction and cleansing processes.
- Design and develop reports utilizing Corporation reporting tools to meet client needs.
- Support integration of the system into overall business information management for finance and customer service interfaces.

**Tangible Capital Assets Management**
- Under the general direction of the City Treasurer, develop short and long term strategies, priorities and resources required, including work breakdown for the Tangible Capital Assets recognition project, both pre and post-implementation.
- Liaise with Directors and other leaders to develop an understanding of their needs and obtain participation and resources from multiple Service Areas and Divisions.
- Work collaboratively with staff responsible for Development Charges, Capital Budget, Asset Management, and Engineering to ensure commonality and consistency in reporting data from each area.
- Liaise with other municipal Finance and Engineering staff, Municipal Benchmarking Network Canada members, association staff, and Provincial representatives to report on progress and identify best practices which might be suitable for implementation.
- Represent the Finance and Corporate Services area at Standing Committees, administrative, intergovernmental and other meetings as required.
- Provide direction and advice to Boards and Commissions regarding Tangible Capital Assets.

**Finance Accountabilities**
- Provide analysis and guidance on the financial implications associated with the recording of Tangible Capital Assets that may be under the consideration of Administration/Council.
- Provide effective utilization of resources in the Division to support the goals of the Tangible Capital Assets recognition project as well as other financial reporting requirements.
- Research and prepare for distribution the accounting reporting and transaction recording practices for municipal governments, existing and proposed under Public Sector Accounting Board (PSAB) Standards, such as PSAB Section 3150.
- Perform other duties as assigned.

**Qualifications/Experience**
- Completion of a University degree in Computer Science, Engineering, Business and/or Finance.
- Five (5) to seven (7) years of system implementation experience.
- Two (2) to three (3) years of Capital Assets accounting experience is an asset.
- Project Management Professional Certificate or equivalent Project Planning specialized courses is an asset.

**Specialized Training & Licenses** Skills and abilities in the following areas are necessary**:

- Proficiency in the use of ERP Software (JD Edwards).
- Demonstrated experience in computer systems implementation and administration.
- Demonstrated ability to develop and communicate specifications for defining systems development, and report writing.
- Knowledge and experience developing reports for financial reporting and accountability requirements, financial management and processes in the Public Sector, including a demonstrated understanding of PSAB.
- Demonstrated competency in Tangible Capital Assets management functions and experience working with planning and accountability frameworks.
- Demonstrated expertise using modelling and forecasting tools and techniques.
- Demonstr