QA Valley Inc. jobs - Access VBA Developer

Provide data integration management, database and user interface development
This role will have responsibilities for:
(i) developing, enhancing and maintaining database solutions for multiple compliance initiatives,
(ii) creating user friendly interfaces for data integration, maintenance, and report creation,
(iii) designing and developing detailed reports designed assist users in managing and monitoring compliance activities,

Responsibilities:

1.Design and develop tools and processes for data collection and integration to MS Access database
3.Design and develop reporting tools using MS Access, MS Excel
4.Design and develop metric reports and consolidated dashboards to monitor status and review transparency and training data utilizing MS Excel, MS Access and Business Intelligence tools.
5.Consolidation and integration of data from multiple sources into a single reporting environment. Creation of data models to support efficient query and reporting processes.
6.Liaise with Compliance users for requirements gathering, testing, implementing and training on new or enhanced database/reporting tools.
7Liaise with IT and business areas to sustain accurate and timely transfers of data.
8.Create and maintain standards and procedural documentation related to reporting/database solutions.
9.Manage projects and facilitate meetings with compliance personnel and subject matter experts to develop/enhance reporting & metric capabilities.

Required Skills:

1.Advanced proficiency in Microsoft Access a must. Ability to create data models, user entry forms, Marcos, VBA procedures, and report creation.
2.Advanced proficiency in Microsoft Excel including linking spreadsheets to MS Access tables, Vlookups, pivot tables. Demonstrated VBA skills a plus
3.Proficient in designing and developing database tools and reporting/metric resources to drive efficiency
4.Experience with VBA Scripting, SQL Development, Data Modeling and ETL
5.SharePoint form development experience preferable