Junior Data & Analytics Support Analyst

CMG Marketing; Toronto; On-site; CAD 45,000 - 65,000; Full time

Job summary

CMG Marketing in Toronto is seeking a Data Support Analyst to assist with data operations, reporting, and basic CRM development. This in‑office role is ideal for someone looking to gain hands‑on experience across multiple projects within a small team.

The ideal candidate has 1–2 years of office experience and completed a data or diploma program. Strong skills in Excel and Access are essential, with working knowledge of SQL Server, CRM, and VBA considered an asset.

Qualifications

• Advanced Excel and MS Access skills are required.
• Experience with SQL Server and CRM systems is helpful.
• 1–2 years in data support, programming, or application development roles.

Responsibilities

• Monthly report generation and maintenance.
• Maintain, create and modify all process documents.
• Write, modify, and test routines, queries and macros.
• Identify and develop standard import and bulk data transfer and transformation routines.
• Review and maintain data quality in MS Access and SQL Server.
• Provide systems, software and application development support for internal systems and web.
• Liaise with team to update on routine reports and enhance processes.
• Work to improve marketing automation processes.
• Record maintenance of in‑house incentive programs.
• Other duties as required including ad hoc reports.

Skills

Advanced Excel

MS Access

SQL Server

MS CRM

.NET

C#

VB.NET

Education

Post-secondary data/application diploma or degree

Tools

Visual Studio

VBA

Job description

CMG Marketing in Toronto is seeking a Data Support Analyst to assist with data operations, reporting, and basic CRM development. This in‑office role is ideal for someone looking to gain hands‑on experience across multiple projects within a small team.

The ideal candidate has 1–2 years of office experience and completed a data or diploma program. Strong skills in Excel and Access are essential, with working knowledge of SQL Server, CRM, and VBA considered an asset.