[Montréal] - Data administrator (hybrid)

QUANTEAM - North America (RAINBOW PARTNERS Group); Montreal (administrative region); On-site; CAD 42,000 - 54,000; Full time

Job summary

QUANTEAM - North America (RAINBOW PARTNERS Group) seeks a programmer analyst workflow developer for an investment bank in Montreal. The role focuses on accurate data entry, KYC processing, and setup of counterparty records across trading and back-office systems.

Ideal candidates have a university degree and 0–2 years in finance, with strong MS Excel skills, attention to detail, and the ability to multi-task under time pressure.

Qualifications

• University degree or equivalent.
• 0–2 years of experience in a financial institution; back office or data administration experience preferred.
• Ability to work with a small team while multi-tasking and prioritizing.

Responsibilities

• Enter approved counterparty data into the in-house KYC system and local counterpart database, following completion of KYC review by the KYC team.
• Set up and maintain counterparty records in trading systems (back office and front office) as instructed.
• Run and review daily reconciliation reports to flag data inconsistencies between systems for team review.
• Process client onboarding tasks in electronic platforms, including access setup and mailing address updates, coordinating with the KYC team as directed.
• Close client files and accounts in downstream systems upon instruction, after confirming no open activity.
• Track and process Patriot Act certificate renewals; elevate to compliance contacts and the Front Office as needed.
• Collect, capture, and validate W-8 and W-9 tax certification forms in internal systems; flag invalid forms to the relevant Sales or WRM contact and elevate system issues to the Tax Department.
• Collect and process Prime Brokerage documentation (Forms 150, 151, and F1SA) in accordance with established procedures.
• Set up and maintain USD Fed Wire transfer templates in the bank payment system per business line instructions.
• Maintain accurate documentation in bank systems in line with record-keeping standards.
• Complete all mandatory trainings and maintain competence requirements for the role.

Skills

Attention to detail

Time management

Team player

English communication

Education

Bachelor's degree or equivalent

Tools

MS Excel

Job description

As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto and Casablanca.

We are looking for a programmer analyst workflow developer for one of our clients, an investment bank set in Montreal

Key responsibilities:

• Enter approved counterparty data into the in-house KYC system and local counterpart database, following completion of KYC review by the KYC team.
• Set up and maintain counterparty records in trading systems (back office and front office) as instructed.
• Run and review daily reconciliation reports to flag data inconsistencies between systems for team review.
• Process client onboarding tasks in electronic platforms, including access setup and mailing address updates, coordinating with the KYC team as directed.
• Close client files and accounts in downstream systems upon instruction, after confirming no open activity.
• Track and process Patriot Act certificate renewals; elevate to compliance contacts and the Front Office as needed.
• Collect, capture, and validate W-8 and W-9 tax certification forms in internal systems; flag invalid forms to the relevant Sales or WRM contact and elevate system issues to the Tax Department.
• Collect and process Prime Brokerage documentation (Forms 150, 151, and F1SA) in accordance with established procedures.
• Set up and maintain USD Fed Wire transfer templates in the bank payment system per business line instructions.
• Maintain accurate documentation in bank systems in line with record-keeping standards.
• Complete all mandatory trainings and maintain competence requirements for the role.
• University degree or equivalent.
• 0–2 years of experience in a financial institution; back office or data administration experience preferred.
• Ability to work with a small team while multi-tasking and carrying a good sense of prioritization
• Follows established processes accurately and flags issues promptly.
• Comfortable with repetitive, process-driven tasks requiring high accuracy.
• Ability to work under time pressure.
• Good knowledge of MS office packages, especially in Excel.
• Strong organisational skills with excellent attention to detail.
• An excellent verbal and written communication skill in English.
• Self-motivated and excellent team player.
• Understanding tax certification is a plus.