VBA Software Developer

VBA Software Developer Harmony Home Health & Hospice - 3.7 Murray, UT Job Details Full-time $65,000 - $85,000 a year 1 day ago Benefits AD&D insurance Health insurance Dental insurance Vision insurance Life insurance Qualifications RDBMS Version control Microsoft Access Computer Science CSS Git SQL Bachelor's degree JavaScript Software documentation Technical writing VBA Front-end development Unit testing

HTML Full Job Description Job Description:

Software Developer (Access, VBA, SQL)

Job Title:

Software Developer (Microsoft Access/VBA Specialist)

Reports To:

Lead Software Engineer /

IT Manager Employment Type:

Full-time Location:

On-site Job Summary We are seeking a skilled Software Developer to maintain, enhance, and modernize our Microsoft Access database applications. The ideal candidate will have a good understanding of Visual Basic for Applications (VBA) and SQL , with additional proficiency in HTML, JavaScript, and CSS to support web-enabled features and potential migration paths. You will be expected to follow standard software development best practices , including version control, code reviews, testing, and documentation. Key Responsibilities Core Development (Access & VBA) Design, develop, and maintain complex Microsoft Access databases (Forms, Reports, Modules, Macros). Write clean, efficient, and well-documented VBA code to automate business processes and enhance UI/UX. Optimize Access applications for performance, security, and multi-user concurrency. Data Management (SQL) Write and optimize complex SQL queries (SELECT, INSERT, UPDATE, DELETE, JOINs, subqueries, stored procedures). Manage data integrity, indexing, and relationships between local Access tables and external databases (SQL Server, MySQL, or Oracle). Troubleshoot and resolve data-related issues, deadlocks, and performance bottlenecks. Web Technologies (HTML, JavaScript, CSS) Develop lightweight web interfaces that integrate with Access data (e.g., using Web Browser controls or exporting data to internal web dashboards). Assist in migrating legacy Access forms to web-based front-ends when appropriate. Build simple internal tools using

HTML/CSS/JS

that interact with backend databases via APIs or direct ODBC connections. Software Development Best Practices Use version control (e.g., Git) for VBA code export/source files and database schemas. Participate in code reviews and contribute to team coding standards. Write unit tests for critical VBA functions and SQL routines. Maintain thorough technical documentation (system architecture, data dictionaries, setup guides, change logs). Follow a change management process for database objects (e.g., tracking form/table changes across environments: Dev → Test → Prod). Apply error handling and logging consistently across all modules. Collaboration & Support Work with business analysts to translate requirements into technical specifications. Provide end-user training and Level 2/3 support for Access applications. Collaborate with IT teams to ensure database security, backups, and disaster recovery plans. Required Qualifications Education Bachelor's degree in Computer Science, Information Systems, or equivalent work experience. Experience 3+ years of professional experience with Microsoft Access and

VBA. VBA

Skills Advanced knowledge of Access object model, events, error handling, class modules, API calls. SQL Skills Strong command of

ANSI SQL

; experience with MS Access SQL dialect and at least one enterprise RDBMS (SQL Server, PostgreSQL, etc.). Web Skills Working knowledge of HTML5, CSS3, and vanilla JavaScript (including DOM manipulation and Fetch API). Best Practices Demonstrated use of Git, code documentation, unit testing, and structured development cycles.

Preferred Qualifications (Nice to Have) Familiarity with REST APIs (consuming or creating). Experience with Access Runtime deployment and patching. Understanding of database normalization . Basic familiarity with responsive design principles. Key Soft Skills Strong analytical and problem solving abilities. Ability to refactor "spaghetti code" into modular, maintainable VBA. Excellent communication; explaining technical debt and solutions to non-technical stakeholders. Self-disciplined in documenting code and following team workflows. Why Join Us? Opportunity to modernize legacy systems while maintaining mission-critical tools. Collaborative environment that values clean code and continuous improvement.

Pay:

$65,000.00 - $85,000.00 per year

Benefits:

AD&D insurance Dental insurance Health insurance Life insurance Vision insurance

Work Location:

In person