Portfolio Accounting Administrator ensures accurate account data, reconciles daily positions, maintains system files, generates trade tickets, resolves discrepancies, and prepares client reports in Toronto, ON.
Responsibilities
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.
Requirements
We’re 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
Snowflake Administrator role requiring 6+ years of database admin experience with Snowflake, SQL proficiency, and AWS knowledge. 100% remote position based in Mississauga, ON.
Database Architect serving as subject matter expert for ACS databases, assessing database needs and improving overall readiness. Collaborating with engineering teams to automate and deploy database standards.
Database Administrator ensuring performance, integrity, and security of databases at Access Credit Union. Collaborating with teams to design, implement, and maintain various database systems under Manitoba’s top employer.
Junior to Intermediate SQL Database Administrator at Polar Asset Management managing SQL Server and cloud databases. Collaborating with developers and data scientists to optimize database performance.