Analyst, Competitive Intelligence

Davies Ward Phillips & Vineberg LLP is a top-tier Canadian law firm focused on high-stakes matters. They are seeking an Analyst for Competitive Intelligence to gather, organize, and analyze data to support marketing and business development opportunities while contributing to strategic decision-making.

Responsibilities

• Extract, clean and organize data from CRM systems, experience databases and internal reports
• Build and maintain Excel-based trackers and basic dashboards to monitor client activity, deal flow and competitor trends
• Work with large datasets, ensuring accuracy, consistency and usability
• Support the development of repeatable reporting processes
• Track league tables, including Bloomberg and Mergermarket, and update internal datasets
• Monitor competitor activity including hires, mandates and public announcements
• Maintain structured datasets to support ongoing market analysis
• Support the preparation of competitor profiles and market summaries
• Contribute to identifying patterns and trends in data
• Assist in drafting summaries and reports based on data and research
• Support senior team members in translating data into clear takeaways
• Respond to data requests from marketing and business development teams
• Support go-to-market efforts with accurate, timely data
• Work regularly in Excel and CRM systems to support reporting and analysis
• Help maintain data quality and consistency across systems
• Support improvements to templates, trackers and reporting processes
• Work closely with marketing, business development and other internal teams
• Take direction from senior CI team members while building confidence and independence
• Contribute to a team environment focused on accuracy, clarity and responsiveness

Skills

• One to four (1–4) years of experience in data analysis, research, business intelligence or a related degree
• Strong Excel skills, including working with large datasets, formulas and data manipulation
• Experience working with CRM or structured datasets is an asset
• Comfort working with numbers and detail-oriented tasks
• Strong attention to detail and ability to manage multiple priorities
• Clear written and verbal communication skills
• Experience in professional services is helpful but not required
• Bilingual French and English is an asset for Montréal

Company Overview