Job Specifications
Job title: CRM Data Analyst
Duration: 12 months
Working Location: Toronto, ON [Hybrid 2- 3 days in office]
About the role
We’re hiring a contract CRM Data Analyst to reconcile datasets with our CRM and prepare clean, enriched files for upload.
You’ll combine Excel (including fuzzy matching/Power Query) with structured rules and clear documentation to drive accurate, repeatable results.
This role suits someone who enjoys problem-solving with imperfect data.
What you’ll do
- Compare external data to CRM records and determine the correct matches.
- Use Excel lookups (and/or Power Query) and other techniques to automate matching.
- Apply judgment on ambiguous cases; validate results with supporting fields.
– Document matching scenarios, rules, and assumptions so the process is auditable and repeatable.
- Produce a final, enriched dataset ready for CRM import and maintain a clear audit trail.
- Maintain overall CRM system hygiene, ensuring data accuracy and completeness.
MUST HAVE
- 5+ yrs of experience in similar role
- Intermediate–Advanced Excel skills (XLOOKUP/INDEX-MATCH, Power Query; fuzzy matching).
- Experience with data reconciliation, deduplication, and quality checks across multiple sources.
– Strong documentation habits and attention to detail.
- Ability to document matching logic clearly so it can be repeated and automated – Solid understanding of data quality management and validation techniques
- Familiarity with CRM platforms (e.g., Salesforce) and the asset/wealth management sector in Canada.
- Detail-oriented with a commitment to data accuracy and consistency
Nice to have
- Ability to script in Python (pandas) and/or write basic SQL is an asset.
- Experience with data integration and ETL processes (Extract, Transform, Load)
- Banking/Financial industry preferred
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
Dexian will on request provide accommodation for disabilities to support your participation in all aspects of Recruitment, Assessment and selection process
About the Company
Dexian is a leading provider of staffing, IT, and workforce solutions with nearly 12,000 employees and 70 locations worldwide. As one of the largest IT and professional staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was launched in 2023 and created from the combination of DISYS, Signature Consultants, and other strategic acquisitions.
Dexian fuses the best elements of its legacy companies to create a platform that connects talent, technology, and organizations to produce game-chan...
Know more