The role is located downtown at Bay and Adelaide. It is a one year contract. The must-have’s for this role is strong Excel, VBA and SQL and someone who has their CPA or working towards it. Strong communication is also important. The other systems listed in the job description can be taught.
Note that this role is moving quickly and they are looking to have interviews next week some time.
Job Description
The Financial Systems Analyst will be responsible to assist with the design, implementation, support and maintenance of various financial systems, as well as data-mining, analysis and reporting from these systems. Possesses an understanding of how various accounting and reporting systems interact with databases to generate meaningful information. This position requires strong accounting, analytical, communication and organization skills. Preferred candidate will have knowledge of the real estate industry, a strong focus on customer service and be a team player with a proven ability to build relationships between the business group, financial team and IT department.
This role requires strong attention to detail as well as the ability to multitask in a complex environment.
Responsibilities:
Consolidated Management Reporting:
– Coordination and preparation of monthly/quarterly/budget/
– Compilation of ad hoc consolidated portfolio data and analysis.
– Review of data integrity, data reconciliation and problem solving.
Report Creation Support:
– Define requirements and specifications for financial and non-financial reports and test reports.
Projects:
– Provide support and participate in the design, development, implementation, and support effort of all new initiatives, enhancements, or integration with financial systems (in concert with IT).
– Testing, implementation and documentation of new systems and upgrades/enhancements/
– Actively participate in process improvement initiatives.
– Liaise with the Super User group to translate business requirements into functional specifications that can be implemented by IT or software vendors.
– Should have the ability to not only be a project team member, but in some instances also lead projects.
GL Administration:
– Testing and maintenance of financial applications such as JD Edwards, Hyperion Financial Management, OASIS, oxBiz, MRI IM, etc.
– Set-up of system metadata, including entity hierarchies, reporting regions, asset classes, asset id’s, companies, business units and accounts.
– Maintenance of automatic accounting instructions, user defined codes and category codes.
– Review of GL integrity reports.
– Run month-end and year-end close processes.
• Work on ad hoc assignments, as required.
Education & Skills required:
• University degree in accounting or business.
• Completion of or working towards a CPA designation.
• Minimum 3 – 5 years of experience working with financial applications, primarily Hyperion Financial Management and JD Edwards EnterpriseOne v.9.
• Accounting experience in a large environment with a complex organizational structure.
• Excellent financial analytical skills, reporting (data mining)
• Highly proficient in Microsoft Excel, Word, Access, Wdesk, SQL, VBA and Adobe Acrobat.
• Real estate experience preferred but not required.
• Project coordination/management experience preferred but not required.
• High attention to detail and accuracy.
• Self-motivated and adaptable to a changing and fast paced corporate environment managing multiple competing deadlines.
• Strong communication / interpersonal skills (both written and verbal) as job will require frequent communication with all levels of management and other departments.
• Able to embrace steep learning curve with an open attitude towards learning.
—
Ms. Hetal Saggu, CPA, CA, M.Acc
Senior Associate, Recruitment Services
hsaggu
