MS Access DB Developer

MS Access Database Developer Role Overview We are seeking a skilled and communicative MS Access Database Developer to modernize and optimize a critical legacy system. In this role, you will analyze our existing database architecture, redesign and normalize tables, and improve overall system performance. Because this system directly supports our day-to-day operations, you will work closely with end-users to understand their pain points, gather requirements, and translate them into technical solutions. Excellent written and verbal communication skills are absolute non-negotiables for this position. Schedule, Hours & Remote Work Location: 100% Fully Remote Core Hours: Monday through Friday, 8:00 AM - 11:00 AM Mountain Time (MT) . Attendance during this specific window is required for remote team alignment, live video/audio calls, and user collaboration. Flexible Hours: The remaining hours can be worked at your convenience from your home office. Weekly Commitment: Minimum of 20 hours per week , with the potential to scale up to 40 hours per week depending on project load. Key Responsibilities Database Restructuring: Evaluate the architecture of an existing legacy MS Access database; redesign and update tables, relationships, and queries to improve efficiency and data integrity. Remote User Collaboration: Interface directly with non-technical end-users via video calls, chat, and email to troubleshoot issues, gather feedback, and define system requirements. Optimization & Maintenance: Refactor legacy VBA code, optimize complex SQL queries, and build user-friendly forms and reports. Migration Readiness: Ensure data cleanliness and structured architecture to help pave the way for potential future migrations to SQL Server or cloud platforms. Documentation: Create clear, concise documentation for the updated database schema, user workflows, and technical updates. Qualifications & Skills Technical Requirements: Advanced MS Access Expertise: Deep understanding of MS Access (forms, reports, macros, and advanced query design). Database Architecture: Strong experience in relational database design, data normalization, and indexing. VBA & SQL: Proficiency in writing/debugging Visual Basic for Applications (VBA) and structured SQL queries within Access. Legacy Systems: Proven experience auditing, refactoring, and updating older, messy database structures without disrupting current operations. Soft Skills & Remote Work Basics: Communication: Exceptional verbal and written English communication skills. You must be able to explain technical concepts simply to end-users and collaborate smoothly across digital channels. Remote Independence: High self-motivation and a reliable, quiet home office setup with high-speed internet. Problem-Solving: Strong analytical mindset with a knack for reverse-engineering legacy systems. Self-Management: Highly organized and disciplined enough to manage a split/flexible schedule effectively without direct supervision. PRI Global