Junior Data Support Analyst-1-Year Contract

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

Job summary

A leading company in marketing is seeking a Data Support Analyst to provide quality data services and support to clients. This junior position offers a chance to gain experience in program management and data analysis while working in a small team environment in their centrally located office.

Qualifications

• 1-2 years of office experience.
• Proficiency in MS Excel and MS Access.
• Some experience with SQL Server and application development is helpful.

Responsibilities

• Generate and maintain monthly reports.
• Develop routines for data import, transfer, and transformation.
• Support systems and application development for internal and web systems.

Skills

Data analysis

Programming principles

Analytical skills

Education

Post-secondary diploma or degree in data or applications

Tools

Excel

MS Access

SQL Server

C#

VBA

Visual Studio

Job description

Job Description

We are seeking a new team member to help us provide quality data services and support to our clients.

This position requires advanced skills in Excel, MS Access, and data analysis and management.

This is an in-office position, pending local regulations.

Our office is centrally located in the Don Mills area with access to the TTC. We offer opportunities to work on various projects in a small team environment, gaining exposure to a range of deliverables.

Note: This is a junior position suitable for someone looking to gain experience. Please evaluate your skills accordingly before applying. This is an in-office position.

We support marketing and membership programs for our client. The Data Support Analyst role is ideal for someone interested in gaining experience in program management, data analysis, and report building. There is also potential for CRM development and process enhancement.

Description : Provide support for business analysis, records management, and data operations through queries, reports, and application design and maintenance using MS products including Excel, CRM 2011, MS Access, SQL Server, C#, and VBA.

Location : Don Mills - In Office

Ideal Candidate : This role is best suited for individuals with 1-2 years of office experience and a post-secondary diploma or degree in data or applications.

Requirements

• Proficiency in MS Excel and MS Access
• Some experience with SQL Server, MS CRM, and .NET is helpful
• At least one year of hands-on experience in data support, programming, or application development
• Strong analytical skills and understanding of programming principles including Web, SQL, and Application Development
• Experience with application development using Visual Basic or C# in Visual Studio is an asset

Responsibilities :

• Generate and maintain monthly reports
• Maintain, create, and update process documents
• Write, modify, and test routines, queries, and macros
• Develop routines for data import, transfer, and transformation
• Ensure data quality in MS Access and SQL Server
• Support systems, software, and application development for internal and web systems
• Collaborate with team members to update on reports, troubleshoot issues, and improve processes
• Enhance marketing automation processes
• Maintain records for incentive programs
• Perform other duties including ad hoc reports and process improvements