Job Summary

We are looking for a highly skilled and experienced MS Access VBA Developer with strong expertise in Microsoft Access application development, VBA scripting, SQL Server integration, and Power BI reporting solutions. The ideal candidate should have hands-on experience in developing enterprise-level database applications, creating dashboards and KPI reports, automating data workflows, and supporting production/database operations.

The candidate should be capable of working independently, handling cross-functional technical support activities, and delivering scalable reporting and database solutions.

Key Responsibilities

Develop, maintain, and enhance applications using Microsoft Access and VBA.
Design and write complex queries in MS Access.
Create and maintain VBA modules, reusable functions, and automation scripts.
Develop and customize Access Forms, Reports, and Macros.
Integrate MS Access applications with SQL Server using ODBC connectivity.
Execute SQL Server Stored Procedures from Access applications.
Implement robust exception handling, debugging, and logging mechanisms in VBA.
Develop interactive dashboards, KPI reports, and analytical reports using Power BI.
Work with Power BI Desktop, DAX, Power Query Editor, and data modeling.
Create and maintain ETL workflows using SSIS packages.
Execute SSIS packages through SQL jobs and VBA code automation.
Support database operations, production deployment activities, and issue resolution.
Work with BAT files and Windows Task Scheduler for automation processes.
Collaborate with business users and cross-functional teams to gather requirements and deliver technical solutions.
Ensure database performance optimization, data integrity, and application reliability.
Maintain technical documentation and deployment procedures.

Required Skills

MS Access & VBA

4+ years of hands-on experience in MS Access VBA development.
Strong expertise in VBA scripting and automation.
Experience in designing and writing complex Access queries.
Experience creating Forms, Reports, Modules, Macros, and Functions.
Strong knowledge of error handling and debugging techniques in VBA.

SQL Server & Database Skills

Experience with ODBC SQL Server connections.
Hands-on experience executing SQL Server Stored Procedures.
Good knowledge of MS SQL Server and T-SQL.
Understanding of relational database concepts and performance optimization.

Power BI

Strong experience in Power BI Dashboard and Report development.
Experience creating KPI dashboards and analytical reports.
Hands-on experience with:

Power BI Desktop
DAX
Power Query Editor
Data Modeling

Additional / Preferred Skills

SSIS (Added Advantage)

Knowledge of SSIS package development and execution.
Experience executing SSIS packages via SQL jobs and VBA code.
Understanding of ETL processes and data integration workflows.

Automation & Scheduling

Knowledge of BAT file scripting.
Experience with Windows Task Scheduler automation.

Collaboration & Tools

Knowledge of SharePoint and MS Forms.
Familiarity with JIRA ticketing system.

Cloud & Infrastructure

Basic knowledge of AWS services.
Knowledge of FTP/SFTP file transfer processes.

Candidate Profile

Strong analytical and problem-solving skills.
Ability to work independently and manage multiple tasks.
Flexible to support production deployments and database operations.
Ability to provide cross-functional technical support as required.
Good communication and stakeholder management skills.

Educational Qualification

Bachelor's Degree in Computer Science, Information Technology, or related field.

GHX: It's the way you do business in healthcare

Global Healthcare Exchange (GHX) enables better patient care and billions in savings for the healthcare community by maximizing automation, efficiency and accuracy of business processes.

GHX is a healthcare business and data automation company, empowering healthcare organizations to enable better patient care and maximize industry savings using our world class cloud-based supply chain technology exchange platform, solutions, analytics and services. We bring together healthcare providers and manufacturers and distributors in North America and Europe - who rely on smart, secure healthcare-focused technology and comprehensive data to automate their business processes and make more informed decisions.

It is our passion and vision for a more operationally efficient healthcare supply chain, helping organizations reduce - not shift - the cost of doing business, paving the way to delivering patient care more effectively. Together we take more than a billion dollars out of the cost of delivering healthcare every year. GHX is privately owned, operates in the United States, Canada and Europe, and employs more than 1000 people worldwide. Our corporate headquarters is in Colorado, with additional offices in Europe.

Disclaimer

Global Healthcare Exchange, LLC and its North American subsidiaries (collectively, GHX) provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. All qualified applicants will receive consideration for employment without regard to any status protected by applicable law. This EEO policy applies to all terms, conditions, and privileges of employment, including hiring, training and development, promotion, transfer, compensation, benefits, educational assistance, termination, layoffs, social and recreational programs, and retirement.GHX believes that employees should be provided with a working environment which enables each employee to be productive and to work to the best of his or her ability. We do not condone or tolerate an atmosphere of intimidation or harassment based on race, color, national origin, sex, sexual orientation, gender identity, religion, age, genetic information, disability, veteran status or any other status protected by applicable law. GHX expects and requires the cooperation of all employees in maintaining a discrimination and harassment-free atmosphere. Improper interference with the ability of GHX's employees to perform their expected job duties is absolutely not tolerated.

Read our GHX Privacy Policy

Visual Basic Applications Analyst II