Data Analyst – MS Access/SharePoint

Are you experienced in data management and automation? Apply Now!

Working with one of our top financial clients, this role calls for a Database Engineer specializing in MS Access, VBA and SharePoint. The position involves managing and consolidating data files, creating queries, automating processes with VBA, and supporting Python scripts for database integration. This is a fantastic opportunity to gain banking and financial exposure within a collaborative environment, with potential for extension and career growth.

Pay rate range (CAD): $67.65/hr – $81.18/hr

Responsibilities

Maintain multiple MS Access databases integrated with SharePoint lists
Develop and manage queries to organize and manipulate data efficiently
Automate MS Access forms and processes using VBA programming
Collaborate with team members to ensure data accuracy and integrity
Assist in consolidating various MS Access databases and Excel files using Python scripts
Manage SharePoint files and lists, ensuring smooth data workflows
Support the team in a fast-paced, Agile environment, delivering quality work on time
Desired Skill-Set

Strong experience in data analysis, data management, and data manipulation (5+ years)
Proficiency in MS Access, including Forms and VBA automation (5+ years)
SharePoint list management experience (5+ years)
Python scripting skills for data consolidation tasks (5+ years)
Excellent verbal and written communication skills
Ability to work independently with a positive attitude
Nice to Have

Prior experience building and designing databases
Analytical and reporting skills, including report creation and data analysis (1+ years)
Experience with data visualization tools or advanced reporting tools
Previous involvement in meta data projects or similar initiatives