Senior MS Database Developer

Senior MS Access Database Developer Location: Remote Overview We are seeking a Senior MS Access Database Developer to stabilize, enhance, and modernize mission-critical Access applications supporting lending, risk, and regulatory reporting. This role combines deep legacy system expertise with a forward-looking mindset to help refactor and migrate solutions to enterprise data platforms. You’ll work in a high-visibility, regulated environment where data accuracy, auditability, and business continuity are critical. Key Responsibilities • Design, develop, and maintain complex MS Access applications, including front-end/back-end split architectures • Optimize VBA code, SQL queries, forms, and reports for performance, usability, and stability • Analyze, reverse-engineer, and refactor legacy Access systems supporting risk, underwriting, and regulatory workflows • Integrate Access applications with enterprise data platforms (DB2, SQL Server, Snowflake) via ODBC/OLE DB • Identify critical data elements, business logic, and data lineage within existing applications • Partner with stakeholders across Risk, Finance, and Underwriting to translate business needs into technical solutions • Support data validation, reconciliation, and audit processes for regulatory reporting • Create and maintain technical documentation including data models, process flows, and transformation logic • Collaborate with data engineering teams to migrate Access-based workflows to modern platforms (e.g., Snowflake, dbt) • Ensure compliance with data governance, security, and regulatory requirements Required Qualifications • 5+ years of hands-on Microsoft Access development experience • Strong expertise in: • VBA programming (including Windows API usage) • Advanced SQL (complex joins, aggregations, performance tuning) • Access forms, reports, macros, and linked tables • Experience managing Access upgrades and full application lifecycle Must-Have Experience • Senior Access Development: Proven experience building and maintaining complex Access environments • Legacy System Stabilization & Refactoring: Ability to clean up and optimize large, fragile systems without disrupting critical workflows • Access Upgrades & 32/64-bit Conversions: Experience with version migrations, PtrSafe/API updates, and resolving broken dependencies • Enterprise Data Integration: Hands-on experience integrating Access with DB2, SQL Server, Snowflake, or similar systems • Regulated Environment Experience: Background in banking, finance, or similar industries with strong audit and compliance requirements Additional Qualifications • Strong understanding of relational data modeling and normalization • Experience working with large, complex legacy systems • Expertise in code analysis, reverse engineering, and technical documentation • Ability to communicate effectively with both technical and business stakeholders What Success Looks Like • Quickly stabilizes complex or fragile Access ecosystems • Approaches systems with a data-first mindset (data flows, lineage, and products) • Balances immediate risk mitigation with long-term modernization strategy • Navigates legacy environments with incomplete documentation (“tribal knowledge”) • Demonstrates strong ownership in high-impact, high-visibility environments Why This Role This is a high-impact opportunity to own critical legacy systems while playing a key role in modernization initiatives. You’ll have direct visibility across business and technical teams and help bridge the gap between legacy applications and enterprise data platforms.