Advanced skills in Microsoft Excel and Microsoft Access are required.
One year of hands-on experience in a data support, programming, or application development role is required.
Highly developed analytical skills and a sound understanding of computer programming principles, including web, SQL, and application development, are required.
Responsibilities
Generate and maintain monthly reports.
Maintain, create, and modify process documents.
Write, modify, and test routines, queries, and macros.
Identify and develop standard import, bulk data transfer, and data transformation routines.
Review and maintain the quality of data and lists in Microsoft Access and SQL Server.
Provide systems, software, and application development support for internal systems and the web.
Liaise with the team to provide updates on routine reports, identify issues or anomalies, enhance processes, and document ad hoc reports or exceptions.
Improve marketing automation processes.
Maintain records for in-house and online incentive programs.
Perform other duties as required, including ad hoc reports and process improvements.
Desired Qualifications
Some experience with SQL Server, Microsoft CRM, and .NET would be helpful.
Application development experience using Visual Basic or C# with Visual Studio is an asset.
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 SupportAnalyst 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