Posted 7 months ago
CRM Data Analyst
@ Procom
Toronto, Ontario
Overview
Procom is hiring a CRM Data Analyst on contract for BMO in Toronto, hybrid with 2-3 office days per week. The role reconciles external datasets against CRM records, uses advanced Excel and Power Query to match and validate data, and prepares enriched files for CRM upload. Requires 5+ years of similar experience and strong Excel skills.
Pay:
$48.75–$65 an hour
Responsibilities:
- Reconcile external data with CRM records
- Automate matching with Excel lookups and Power Query
- Validate matches and document rules and assumptions
- Produce enriched datasets for CRM import
Requirements summary:
- 5+ years in a similar role
- Advanced Excel skills including Power Query and fuzzy matching
- Experience in data reconciliation and deduplication
- Familiarity with Salesforce and Canadian asset or wealth management
Tools & skills
Source and dates
Employer career site / ATS feed · careerpage
- Employer posting date
- 2026-04-17
- First seen by our source
- 2026-10-11
- Source record updated
- 2026-10-18
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Data & analytics |
| Experience | 5+ years |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Procom
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
Full company description
Procom is one of North America’s leading staffing and contract workforce services providers. Successfully meeting the needs of Fortune 500 clients since 1978, we have 18 offices across North America, with over 12,500 skilled professionals currently on assignment. We are an award winning staffing firm. Discover more about our Best of Staffing award and what real clients and job seekers have to say about working with Procom by checking out our client and talent ratings on ClearlyRated. Procom has long been recognized as a market-leading source of high-performing services and solutions that transform how our clients acquire and manage the very best talent. Relying on the excellence of individuals to make a difference, we know that people matter. And we want to work with you. CNESST License: AP-2504746, AR-2504747, AP-2000583, AR-2000584
- LinkedIn followers
- 195,312
- People associated on LinkedIn
- 1,304
- Reported office locations
- 30 St Clair Ave W, Toronto, Ontario M4V 3A1, CA
- 320 March Rd, 200, Ottawa, Ontario K2K 2E3, CA
- 333 7 Ave SW, Suite 2100, Calgary, Alberta T2P 2Z1, CA
- 10025 - 102A Avenue, Suite 1800, Edmonton, Alberta T5J 2Z2 , CA
- 1021 W Hastings St, Suite 1100, Vancouver, British Columbia V6E 0C3, CA
- 1280 Boulevard Lebourgneuf, 300, Québec, Quebec G2K 0H1, CA
- 1130 Situs Court, Suite 216, Raleigh, North Carolina 27606 , US
- Other recorded names
- Procom
- Specialties
- Hybrid Statement of Work and Contractor Management Technology
- Profile identifies a recruitment agency
- Yes
Procom is one of North America’s leading staffing and contract workforce services providers. Successfully meeting the needs of Fortune 500 clients since 1978, we have 18 offices across North America, with over 12,500 skilled professionals currently on assignment. We are an award winning staffing firm. Discover more about our Best of Staffing award and what real clients and job seekers have to say about working with…
| Field | Value |
|---|---|
| Industry | IT Services and IT Consulting |
| Company size | 201-500 employees |
| Headquarters | Toronto, Ontario |
| Organization type | Privately Held |
| Specialties | Hybrid Statement of Work and Contractor Management Technology |
| Open jobs on Jobsy | 234 |
| View page |
BMO is currently sourcing for a CRM Data Analyst to support data quality and automation projects. This is a hybrid contract role in Toronto (2-3 days in office per week).Role Overview:The CRM Data Analyst will reconcile datasets with the CRM and prepare clean, enriched files for upload. This role focuses on utilizing Excel's advanced features to drive accurate data matching and validation while improving overall data integrity, making significant contributions to the organization’s data quality initiatives.Key Responsibilities:- Compare external data to CRM records and determine correct matches.- Use Excel lookups and Power Query to automate data matching processes.- Validate matching results with supporting fields and apply judgment in ambiguous cases.- Document matching scenarios, rules, and assumptions for process auditability.- Produce enriched datasets ready for CRM import and maintain an audit trail.- Ensure overall CRM system hygiene and data accuracy.- Collaborate with team members to streamline data processes.Must-Have Skills:- 5+ years of experience in a similar role (intermediate to senior level).- Proficiency in Excel (XLOOKUP, INDEX-MATCH, Power Query, fuzzy matching).- Experience in data reconciliation, deduplication, and quality checks.- Strong documentation skills with attention to detail.- Understanding of data quality management and validation techniques.- Familiarity with CRM platforms (e.g., Salesforce) and the Canadian asset/wealth management sector.Nice to Have Skills:- Ability to script in Python (pandas) and/or basic SQL knowledge.- Experience with data integration and ETL processes.- Background in the banking or financial industry is preferred.Ideal Candidate:- Demonstrates a strong commitment to data accuracy and consistency.- Has a proactive approach to problem-solving with imperfect data.- Possesses ability to articulate complex data processes clearly to stakeholders.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.