Software Developer

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 Microsoft Access CSS SQL Bachelor's degree JavaScript VBA APIs Front-end development

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 deep expertise in 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 MS SQL Server. 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). Build simple internal tools using

HTML/CSS/JS

that interact with back-end 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 1+ 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 Good command of

ANSI SQL

; experience with MS Access SQL dialect and, ideally, MS SQL Server. Web Skills Working knowledge of HTML5, CSS3, and vanilla JavaScript (including DOM manipulation and Fetch API). Best Practices Preferred Qualifications 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.

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