Junior Data Support Analyst

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.

· 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