MS Access Database Developer

Atlantic Central is currently accepting applications for a MS Access Database Developer. This is a one year term position.

Who WE Are:
Atlantic Central is the trade association for credit unions in Atlantic Canada. We work together to build and maintain partnerships, and offer timely, results-oriented solutions to our customer credit unions enabling the Atlantic credit union system and the communities they serve to thrive.

We are committed to balancing health and wellbeing with efficient service delivery and strive to create an environment where all team members have opportunities for growth and feel welcome, valued, supported and connected.

If your values align with ours, consider joining our team as a MS Access Database Developer.

 A TYPICAL DAY:

The major focus of this Term position will be the improvement and/or re-development of an existing Application in MS Access.  The Application stores portfolio and transactional details and is pivotal in managing a multi-million-dollar investment portfolio.  The current data requirements have outgrown the original application and the intent is to improve processes, increase automation, leverage opportunities to import/export data and expand complex reporting capabilities.

Beyond this initial project, you will also assist with the development and implementation of processes to improve, centralize, and automate the delivery of management and regulatory reporting via Power BI and SQL databases.

RESPONSIBILITIES:

  • Maintains an understanding of the business processes and data structures.
  • Develops and maintains automatic processes, using various software platforms including Microsoft Access, VBA (Visual Basics for Applications), Microsoft Excel (with a strong focus on Power Query), Power BI, SQL Databases, XML and Exact Globe, our financial management software.
    1. Collects functional and data requirements to identify and understand the business requirements of end users with respect to the development of solutions.
    2. Designs, develops and/or modifies new and existing solutions to accommodate requirements or restrictions in the areas of regulatory reporting, management reporting, data analysis, and ad-hoc requests.
    3. Tests the solution throughout its development, identifies and resolves issues.
    4. Provides training and support to end users after the system has been delivered, including but not limited to, demonstrating how to use the solution, answering questions, providing advice, guidance, and mentoring.
    5. Makes necessary modifications to the solution based on user feedback and improves the overall integrity and usability of the solution by performing regular reviews and updates.
    6. Develops and maintains related process documentation and user procedures.
  • Assists and provides backup support for other priority tasks in response to resource shortfalls and/or requirements for specific expertise.
  • Completes other duties and projects as assigned.

HIRING QUALIFICATIONS:

As the ideal candidate you will possess demonstrated success in MS Access Application Development along with experience working with Power BI and SQL Databases.  Experience or knowledge of Finance/Accounting/Banking is considered an asset.

SKILLS

You have strong oral and written communication skills including the ability to communicate with technical and non-technical users and create detailed technical manuals.  You have analytical and organizational skills and the ability to multitask.  You demonstrate competency in working effectively with diverse stakeholder groups and interacting with all levels of management and staff.

LOCATION:

This position offers the ability to work remotely and services Atlantic Canada & time zone.

COMPENSATION:
This is a term position and is rated a Salary Level CU-6 ($60,644 – $71,346). Atlantic Central offers a competitive benefits package as well as the opportunity to participate in the Performance Sharing Incentive Plan.

TO APPLY
Applications will close on January 21, 2023

A cover letter is requested with all applications and candidates may be required to provide a sample of an application built in Microsoft Access.

If this role sounds like a fit for you, please submit your application via this link : Click Here

About Atlantic Central

Atlantic Central is the regional trade association for more than 40 independent member credit unions across Atlantic Canada. We provide a range of financial services, leadership, and advocacy to support credit unions and the communities we serve to grow well. Our credit unions proudly serve nearly 293,000 members and play a significant role in the Atlantic Canadian economy.

We are proud to be a Certified B CorporationTM joining a global movement of people using business as a force for good. We are committed to making business decisions that are in the best interests of our employees, credit unions and their members.

Curious about what else we do? Check out our website or LinkedIn page.