Transit Financial Analyst
Requisition ID: 15457
Department: Finance and Corporate Services Dept.
Service: Corporate Finance Service
Branch: Transportation Client Branch
Employment Type: 1 Full-time Temporary - Up to 1 year
Work Hours: 35.00 hours per week
Affiliation: ATU 1760
Salary Information: $62,167.56 - $88,182.64 annually (2023 rates of pay)
Location: Transit Service, 1500 St.Laurent
City: Ottawa, ON
Job Category: Finance & Accounting
Application Close: 30/12/2024
JOB SUMMARY
The Financial Services Branch is responsible for the overall delivery of financial services to City departments, Boards, Commissions and Agencies, ensuring that the financial support requirements and financial processing are delivered in a timely, meaningful manner. Services include budget development and monitoring, financial analysis, project management support, financial reporting both internal and external, financial compliance, financial advice and accounting requirements. The Account Management units develop strategic business partnerships and deliver “one-stop-shop” financial support to their client departments to meet operational requirements of the assigned lines of business.
You are responsible to provide timely and accurate financial information for transit services. You work with FSU Coordinators, unit staff, City IT, Corporate Finance, other employees within Transit and the City, as well as liaise with the Presto Finance Committee, Presto Incident Committee and Presto Service Desk to coordinate activities. Duties include: validating customer’s balance using the Electronic Fare Management System (EFMS), analysis of financial transactions, reconciliation of balance sheet accounts, processing of adjusting journal entries, generation of financial reports, and involvement in system implementations or enhancement.
EDUCATION AND EXPERIENCE
Completion of 3 year post-secondary education with an emphasis in Accounting and/or Finance.
Minimum of 5 years of progressively responsible experience in financial management including financial analyses, accounting, extracting/manipulating data within the Datamart systems and working with BI tools. Advanced Microsoft Excel and strong analytical skills.
Experience in the implementation and testing of financial systems is desirable.
KNOWLEDGE
- Acquired knowledge of the City financial policies and procedures
- Posses knowledge of relevant SAP modules and an understanding of the maintenance management systems, and client software, including Presto system, Para EFMS and their interfaces with SAP
- Knowledge of financial controls and process
- Sound knowledge of Branch/Division mandate, systems, programs, policies, procedures and guidelines
- General knowledge of Business and basis accounting practices including general ledger, billing, Accounts Payable and Receivable procedures
- Understanding of City GL Account code structure
- Knowledge of advanced Skills in MS Office including Excel 10 and Power Pivot
- Understanding of corporate SAP Systems and other databases to manage information that is accessible and used by the Division.
- Understanding of problem-solving, analytical and customer service techniques/City practices
- Knowledge of applicable health and safety legislation, including the rights and duties of workers
COMPETENCIES, SKILLS AND ABILITIES
- Able to work independently, with minimum supervision, and collaboratively with all staff as part of a team
- Advanced analytical and problem solving skills to reconcile data and resolve information discrepancies
- Able to understand/appreciate the technical complexities of the work in order to provide the necessary financial management support
- Possess organizational skills and flexibility to plan, organize and prioritize own work and to deal effectively with multiple demands, conflicting priorities, pressures and deadlines
- Possess advanced computer literacy in MS Office Suite in a Windows environment, including use of intranet/internet
- Able to use Corporate SAP systems and other databases and work with advanced computer applications
- Possess customer service sensitivity and the ability to listen, probe, and tactfully respond
- Communicate effectively, both orally and in writing
- Possess strong analytical skills, especially in Microsoft
- Analytical and attentive to detail
- Possess sound judgment, tact and diplomacy
- Able to demonstrate sound judgment
- Possess initiative and self-motivation
- Flexible and adaptable
- Possess a work record of good attendance and job performance
WHAT YOU NEED TO KNOW
- Language Requirement: English oral, reading, writing
- Police Record Check: The successful candidate will be required to complete a Criminal Records and Judicial Matters Check with the Police Services detachment in their jurisdiction to the City of Ottawa’s satisfaction.; Police record checks completed by a third-party company will not be accepted.
- Experience and formal training combined with demonstrated performance and ability may substitute for stipulated academic requirements.
- Please save a copy of the job poster. Once the closing date has passed, it will no longer be available.
We wish to thank all applicants for their interest and effort in applying for this position. Only candidates selected for interviews will be contacted.
The City of Ottawa promotes the principles of diversity and inclusion and adheres to the tenets of the Canadian Human Rights Act and the Ontario Human Rights Code. We encourage applications from members of Indigenous, Black and other racialized communities, persons with disabilities, women and non-binary persons, persons of all ethnic origins, religions, sexual orientations, classes, gender identities and expressions.
Candidates are encouraged to self-identify as a member of one or more designated employment equity groups in the self-identification questionnaire.
The City of Ottawa provides accommodation during all parts of the hiring process, upon request, to applicants with disabilities. If contacted to proceed to the selection process, please advise us if you require any accommodation.
Accessible formats and communication supports are available upon request. Please contact the HR Service Centre at 613-580-2424, extension 47411.