TCA Financial Systems Consultant 2

at  City of Calgary

If you are committed to public service, enjoy collaborating with others, share our values and have a desire to learn and grow, join The City of Calgary. City employees deliver the services, run the programs and operate the facilities which make a difference in our community. We support work-life balance, promote physical and psychological safety, and offer competitive wages, pensions, and benefits. Together we make Calgary a great place to make a living, a great place to make a life.
The City is committed to fostering a respectful, inclusive and equitable workplace which is representative of the community we serve. We welcome those who have demonstrated a commitment to upholding the values of equity, diversity, inclusion, anti-racism and reconciliation. Applications are encouraged from members of groups that are historically disadvantaged and underrepresented. Accommodations are available during the hiring process, upon request.

As a TCA Financial Systems Consultant 2 you will provide consultative services in the review, development, and implementation of initiatives focused on the optimization of PeopleSoft Financial Modules functionality to meet business needs. This focus will also include providing recommendations to leadership on the use and integration of systems with corporate financial policies and business processes. Primary duties include:

• Collaborate on the design, development, and documentation of innovative and productive financial system solutions in support of enhanced master data integrity and financial reporting.
• Provide Financial systems support and guidance to users to facilitate understanding of data input and data capture for reporting and analytical purposes and being the primary support for Business Objects.
• Provide input and guidance to Tangible Capital Asset (TCA) users regarding the financial policy implications of existing or anticipated business activities in the system process.
• Participate in cross-functional team meetings and projects to provide leadership, financial expertise and advice.
• Coordinate between system users and systems technical staff to facilitate a shared understanding and solutioning of business issues with cost effective solutions.
• Review existing and potential financial and information Technology (IT) system policies of other municipalities and governments related to systems handling of accounting/financial data and identify changes that would be relevant to the City of Calgary policy.

QUALIFICATIONS

• A professional accounting designation such as Chartered Professional Accountant (CPA) and at least 4 years of progressively more responsible financial accounting experience.
• Equivalent combinations of experience and education may be considered.
• Extensive financial experience from both a corporate and operational perspective and expert knowledge of financial and accounting processes.
• Advanced systems, analytical, and reporting experience.
• Advanced knowledge of financial software, data analysis, and report development tools such as SAP Business Objects, Power BI, Microsoft Excel.
• Experience with large Enterprise Resource Planning (ERP).
• Coursework or proficiency in Standard Query Language (SQL).
• Hands on experience supporting the PeopleSoft Asset Management and project costing modules.
• Success in this position requires strong financial, systems technology, and analytical skills; the ability to effectively communication and organize, and the ability to work with a diverse team.

PRE-EMPLOYMENT REQUIREMENTS

• Successful applicants must provide proof of qualifications.
• Applicants must include a cover letter.
  Note: Please note all exempt positions at The City are undergoing a compensation review. This means the union jurisdiction and/or salary range listed here may change. Tell me more.
  Union: Exempt
  Business Unit: Finance
  Position Type: 2 Temporary (up to 18 months)
  Location: 800 Macleod Trail SE
  Compensation: Level E $83,059 - 125,413 per annum
  Days of Work: This position typically works a 5 day
  work week, earning 1 day off in each 3 week cycle.
  Hours of work: Standard 35-hour work week
  Audience: Internal/External
  Apply By: January 24, 2025
  Job ID #: 311268

• Collaborate on the design, development, and documentation of innovative and productive financial system solutions in support of enhanced master data integrity and financial reporting.
• Provide Financial systems support and guidance to users to facilitate understanding of data input and data capture for reporting and analytical purposes and being the primary support for Business Objects.
• Provide input and guidance to Tangible Capital Asset (TCA) users regarding the financial policy implications of existing or anticipated business activities in the system process.
• Participate in cross-functional team meetings and projects to provide leadership, financial expertise and advice.
• Coordinate between system users and systems technical staff to facilitate a shared understanding and solutioning of business issues with cost effective solutions.
• Review existing and potential financial and information Technology (IT) system policies of other municipalities and governments related to systems handling of accounting/financial data and identify changes that would be relevant to the City of Calgary policy