Client Financial Reporting Analyst

at  AIMCo Alberta Investment Management Corporation

CLOSING DATE:

February 17, 2025
Opportunity
Work our way from Edmonton, or Calgary. Our flexible work style lets you work remotely while allowing regular visits to our vibrant offices, where you can soak up our culture and collaborate with colleagues.
Posting will close Sunday February 16th at 11:59pm MT
Are you enthusiastic about problem solving and are looking for an opportunity to tailor resolutions to the accounting needs of internal and external stakeholders? This could be your next career adventure!
The Investment Finance- Client Financial Reporting (IFCFR) team at AIMCo is currently looking for an Analyst II to join their dynamic team. In this role, you will be responsible for performing highly specialized financial reporting functions across a breadth and multi-layered investment pool structure for AIMCo’s clients. You will have the opportunity to provide expert guidance to internal and external clients on ongoing financial accounting reporting and statutory audits. Additionally, you will support ad hoc accounting projects and initiatives as required by Senior Leadership and the Board to deliver on the Investment Finance - Client Financial Reporting (IFCFR) team objectives.
High performing Analysts at AIMCo are self-driven, analytical, have a curious mindset, detailed oriented and celebrates teams’ success.

Responsibilities Include:

• Conduct daily validations and resolve technical issues on accounting and financial reporting systems including data validation between dashboards, Simcorp Dimension (SCD), and existing internal reporting systems, ensuring data integrity and consistency.
• Analyze, investigate, and resolve complex technical issues related to accounting systems and dashboards, ensuring data integrity and consistency.
• Develop, enhance, and maintain accounting reports using SQL, ensuring efficient data retrieval and integration with financial reporting systems. Optimize queries to improve report performance, accuracy, and troubleshoot any SQL-related issues impacting reporting workflows.
• Maintain and update Accounting Power BI dashboards using existing datasets, including implementing changes within designated systems as required.
• Prepare periodic and annual financial reports for clients, incorporating relevant investment-related accounting notes and disclosures.
• Ensure the effective operation of system controls to meet CSAE 3416 reporting requirements.
• Evaluate system change requests, perform User Acceptance Testing (UAT), and support the implementation of new processes and assigned projects.
• Recommend and contribute to improvements in standard operating procedures and policies that guide the IFCFR team’s activities.
• Respond to accounting and audit queries from internal and external clients, providing accurate and timely information.
• Perform any other assigned responsibilities linked to Business As Usual (BAU), divisional, or corporate objectives, taking ownership and ensuring timely and accurate completion.

One Year Success Measures:

• You will have developed a strong working knowledge of accounting and financial reporting systems such as SimCorp Dimension (SCD) and AIMCo’s internal reporting tools, along with proficiency in data analytics tools like SQL and Power BI to meet client reporting needs.
• You will have built and maintained strong relationships with internal and external stakeholders, demonstrating effective communication and collaboration skills.

Our Ideal Candidate:

• Possesses a degree/diploma in Business, Accounting, Finance, Computer/Data Science, or a related field.
• Demonstrates strong academic credentials with a minimum of 2 years of relevant experience in the financial industry and accounting reporting, or an equivalent combination of education and experience.
• A CPA or CFA designation, or actively pursuing one, would be considered an asset.
• Proficient in using SQL for database querying, with strong skills in data visualization tools like Microsoft Excel (pivot tables) and Power BI.
• Possesses a good knowledge of capital markets, investment finance, and accounting rules and guidelines, including GAAP, PASB, IFRS, and the Financial Administration Act (asset).
• Exceptional at managing rapidly changing work priorities within designated timelines and can effectively communicate verbally and in writing with clients.
• Highly resourceful, takes a collaborative approach to work, and can deliver primary assigned tasks.
• Demonstrates a strong commitment to AIMCo’s core values of excellence, transparency, humility, integrity, and collaboration, and inspires the same in others. Degree/diploma in Business, Accounting, Finance, Computer/Data Science, or a related field.

Next Steps
We are excited to meet you. Please submit your resume or CV to be considered for this opportunity. Applications are being reviewed on a rolling basis and we will be in touch with any questions.
Final candidates will be asked to undergo a security screening, which includes a credit bureau and a criminal record investigation, the results of which must be acceptable to AIMCo.
ALERT - Be on the lookout for AIMCo career opportunities advertised through third parties that request an application fee or too much information. To verify, all opportunities are posted on aimco.ca/jobs
Just like our investments, our international team is stronger when we are diversified. At AIMCo, we draw upon the differences in who we are, where we come from, and the way we think to foster sophisticated solutions for Albertans. Doing business the right way means building an equitable organization inclusive of all races, genders, ages, abilities, religions, neurodiversity, identities, and lived experiences. Simply put, when you can show up as your authentic self every day, you and your team can truly thrive — all in service of our clients and their beneficiaries

• Conduct daily validations and resolve technical issues on accounting and financial reporting systems including data validation between dashboards, Simcorp Dimension (SCD), and existing internal reporting systems, ensuring data integrity and consistency.
• Analyze, investigate, and resolve complex technical issues related to accounting systems and dashboards, ensuring data integrity and consistency.
• Develop, enhance, and maintain accounting reports using SQL, ensuring efficient data retrieval and integration with financial reporting systems. Optimize queries to improve report performance, accuracy, and troubleshoot any SQL-related issues impacting reporting workflows.
• Maintain and update Accounting Power BI dashboards using existing datasets, including implementing changes within designated systems as required.
• Prepare periodic and annual financial reports for clients, incorporating relevant investment-related accounting notes and disclosures.
• Ensure the effective operation of system controls to meet CSAE 3416 reporting requirements.
• Evaluate system change requests, perform User Acceptance Testing (UAT), and support the implementation of new processes and assigned projects.
• Recommend and contribute to improvements in standard operating procedures and policies that guide the IFCFR team’s activities.
• Respond to accounting and audit queries from internal and external clients, providing accurate and timely information.
• Perform any other assigned responsibilities linked to Business As Usual (BAU), divisional, or corporate objectives, taking ownership and ensuring timely and accurate completion