Junior Data Support Analyst-1-Year Contract

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

Looking for a new team member to help us continue to provide quality data service and support our clients come to rely on.

This position requires advanced Excel, MS Access and the ability to analyze and manage data sets.

This is an in‑office position and not a remote position.

We are centrally located in the Don Mills area with access to the TTC. We offer the opportunity to gain experience working on a series of projects and work in a small team to gain access to a variety of deliverables.

Note – this is a junior position for someone looking to gain experience. Please ensure to evaluate along with the skill set requirements before applying. This is an in office position.

We support various marketing and membership programs on behalf of our client. The Data Support Analyst position is ideal for someone looking to gain experience with program management, working to support us in building our capabilities in the information and analysis areas for these services. The position also allows you to enhance existing process and reports and includes potential for CRM development.

Description:

Provide support to business analysis, records management and data operations through queries, report and application design and maintenance in MS products including Excel, CRM 2011, MS Access, SQLServer, C# and VBA.

Location:

Don Mills-In Office

Ideal Candidate:

This position is best suited to those who have 1-2 years of office experience and have completed a post‑secondary data/application diploma or degree.

Requirements

• · Skilled in MS Excel and MS Access - Advanced Excel skills required
• · Some experience within SQL Server, MS CRM , .Net would be helpful
• · One year of hands on experience in a data support, programming or application development role.
• · Highly developed analytical skills and a sound understanding of computer programming principles including Web, SQL and Application Development.
• · Application development experience including Visual Basic or C# using Visual Studio another asset

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 the quality of data and lists in MS Access and SQL Server
• · Provide systems, software and application development support for internal systems and web
• · Liaise with rest of team to provide updates on routine reports, identify any issues/anomalies and work to enhance any processes to document any ad hoc reports or exceptions
• · Work to improve marketing automation processes
• · Record maintenance of in‑house and on‑line incentive programs
• · Other duties as required including ad hoc reports and process improvements