GHX
Healthcare
VisualBasicApplicationsAnalystII
Neural analysis suggests this role is
optimal for Mid candidates.
“Visual Basic Applications Analyst II at GHX. Skills: MS Access, VBA, SQL Server, Power BI. Develop applications using Microsoft Access and VBA. Maintain applications using Microsoft Access and VBA”
What You'll Achieve.
Deliver scalable reporting and database solutions; Ensure database performance optimization; Ensure data integrity; Ensure application reliability
Industry & Context.
analytical and problem-solving skills
What They're Looking For.
Must Have
MS Access & VBA 4+ years of hands-on experience in MS Access VBA development, expertise in VBA scripting and automation, Experience in designing and writing complex Access queries, Experience creating Forms, Reports, Modules, Macros, and Functions, knowledge of error handling and debugging techniques in VBA, 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 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, Knowledge of BAT file scripting, Experience with Windows Task Scheduler automation, Knowledge of SharePoint and MS Forms, Familiarity with JIRA ticketing system, Basic knowledge of AWS services, Knowledge of FTP/SFTP file transfer processes, 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
Nice to Have
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
What You'll Do.
Develop applications using Microsoft Access and VBA
Maintain applications using Microsoft Access and VBA
Enhance applications using Microsoft Access and VBA
Design complex queries in MS Access
Write complex queries in MS Access
Create reusable functions
Maintain reusable functions
Create automation scripts
Maintain automation scripts
Customize Access Forms
Develop Access Reports
Customize Access Reports
Develop Access Macros
Customize Access Macros
Integrate MS Access with SQL Server
Execute SQL Server Stored Procedures
Implement exception handling in VBA
Implement debugging in VBA
Implement logging mechanisms in VBA
Develop interactive dashboards
Develop analytical reports using Power BI
Work with Power BI Desktop
Work with Power Query Editor
Work with data modeling
Create ETL workflows using SSIS
Maintain ETL workflows using SSIS
Execute SSIS packages through SQL jobs
Execute SSIS packages through VBA code automation
Support database operations
Support production deployment activities
Support issue resolution
Work with Windows Task Scheduler
Collaborate with business users
Collaborate with cross-functional teams
Deliver technical solutions
Ensure database performance optimization
Ensure data integrity
Ensure application reliability
Maintain technical documentation
Maintain deployment procedures
How You'll Work.
Team & Collaboration
Collaborate with business users; Collaborate with cross-functional teams; Provide cross-functional technical support
Communication Scope
Good communication; Stakeholder management
Full Job Description
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
Applying for this Visual Basic Applications Analyst II role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
How to Apply on Greenhouse
- Create a Greenhouse profile before applying — it saves time across multiple applications.
- Upload your resume as a PDF; the parser handles it better than Word.
- Answer all knockout questions carefully — wrong answers auto-reject before a human sees you.
- Enable email notifications to track application status in real time.
ANONYMOUS · UNFILTERED
What do employees actually say about GHX?
Real rants from real employees. Read before you apply.