Portfolio Accounting Administrator

Akkodis; Toronto; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

Akkodis is seeking a Portfolio Accounting Administrator to support Project Accounting Administrator program and portfolio operations. The role emphasizes Excel VBA macros and operational readiness, ensuring accurate reporting and compliance.

The successful candidate will manage account reconciliation, generate trade tickets, and prepare client reports among various tasks. A post-secondary degree or relevant experience is required, with strong skills in finance and MS Office preferred.

Qualifications

• Prior experience in financial services administration is an asset.
• Detail-oriented and process-driven approach to work.
• Able to organize and prioritize work effectively.

Responsibilities

• Support portfolio operations and governance processes.
• Reconcile cash, security positions, book values, and market values.
• Assist with calculating account performance and management fees.

Skills

Excel VBA macros

Strong analytical skills

Knowledge of securities/finance industry

MS Office proficiency

Excellent communication skills

Ability to prioritize work

Education

Post-secondary degree or equivalent experience

Completion of Canadian Securities Course or Level 1 CFA

Tools

Advent Axys

Advent APX

Access

Job description

Duration: Contract Assignment

Client Location: Hybrid / Remote (as applicable)

Engagement Model: Professional Services Engagement – B2B (Incorporated Entities Only)

About the Engagement

Our organization is seeking the services of an experienced Portfolio Accounting Administrator consultant to support Project Accounting Administrator program and portfolio operations. This engagement is focused on Excel VBA macros execution support, coordination, reporting accuracy, and artefact management across multiple project teams and functional stakeholders.

The successful consultant will play a critical role in enabling disciplined portfolio governance, operational readiness, and consistent delivery practices.

Services to be Provided

Excel VBA macros highly preferred. Prior experience using Advent Axys or Advent APX systems is not mandatory but nice to have.

• Ensure account information is accurate in all systems and on daily basis reconcile cash, security positions, book value and market value to custodial records. Investigate and resolve all differences.
• Maintain system data files such as daily price files, FX files, Paydown, Index and Security Master File.
• Generate trade tickets in timely manner ensuring Transfer Agency is instructed before industry cut off time. Resolve all trade related discrepancies.
• Assist with calculating account performance and management fees.
• Maintain client data in various systems by assisting with opening new accounts, processing account closing and updating existing clients’ data as required.
• Prepare client statements and ad-hoc client reports.
• Maintain data on client and advisor portal.
• Submit corporate action instructions to custodians in a timely and accurate manner. Post and reconcile corporate action transactions.
• Participate in the testing and implementation of operational enhancements.
• Using your analytical skills and sound decision-making methodology to make appropriate business decisions.
• Ensure deadlines are met and appropriate escalations are in place.
• Adhere to departmental and company policies and procedures, ensuring compliance.
• Perform ad hoc duties as assigned.
• We are looking for an individual with the right skill set, work ethic, and personality to fit in with our team. Prior experience in financial services administration is an asset. Post-secondary degree or an acceptable combination of education, training and/or related work experience. Completion of Canadian Securities Course or working towards completing Level 1 CFA.
• Strong knowledge of the securities / finance industry, including separate account reconciliation.
• Proficient in MS Office (medium/expert user of Excel, familiar with Access).
• Strong analytical and problem-solving skills.
• Strong attention to detail.
• Ability to organize and prioritize work effectively.
• Excellent written and verbal communication skills.
• Ability to learn new systems quickly & adapt to evolving processes.
• Detail-oriented and process-driven approach to work.
• Strong work ethic, maturity, and commitment to client service.
• Committed to ethical and professional standards regarding confidentiality of client information.
• An enthusiastic team player who can work effectively with others both internally and externally.

Accessibility & Equal Opportunity Statement

We are committed to fostering an inclusive and accessible workplace. Reasonable accommodations are available throughout the engagement and selection process for individuals with disabilities. We encourage applications from all qualified individuals and value diversity across backgrounds, experiences, and perspectives.