Experience: 5 - 20 years
Must Have Skills:
- 32-bit to 64-bit conversion of Access applications and VBA code (PtrSafe, API declarations, ActiveX compatibility)
- 5+ years of MS Access development
- Access forms, reports, macros, and linked tables
- Complex SQL (joins, aggregations, performance tuning)
- Migration across Access versions and environments
- MS Access version upgrades and application lifecycle management
- VBA programming (including Windows API usage)
Nice To Have Skills:
- Regression testing and validation post-upgrade
- Resolution of broken references, deprecated components, and control issues
Summary:
We are seeking a Senior MS Access Database Developer to support and modernize critical desktop-based data applications used for commercial lending, underwriting, and regulatory reporting. This role will focus on maintaining legacy Access solutions while driving refactoring, optimization, and migration toward scalable enterprise data platforms.
Key Responsibilities
- Design, develop, and maintain complex MS Access databases (front-end/back-end split architectures).
- Optimize VBA code, queries, forms, and reports for performance and usability.
- Analyze and refactor legacy Access applications used in risk, regulatory, and lending workflows.
- Integrate Access applications with enterprise data sources (DB2, SQL Server, Snowflake) using ODBC/OLE DB.
- Reverse-engineer existing solutions to identify:
- Critical data elements
- Business logic
- Data lineage and dependencies
- Collaborate with business stakeholders (Risk, Finance, Underwriting) to translate requirements into technical solutions.
- Support data validation, reconciliation, and audit processes required for regulatory reporting.
- Develop documentation including:
- Data models
- Process flows
- Transformation logic
- Partner with data engineering teams to migrate Access-based solutions to modern platforms (e.g., Snowflake, dbt).
- Ensure compliance with data governance, security, and control frameworks.
Required Qualifications:
- 5+ years of experience with MS Access development
- Strong expertise in:
- VBA programming (including Windows API usage)
- Complex SQL (joins, aggregations, performance tuning)
- Access forms, reports, macros, and linked tables
- Proven experience with MS Access version upgrades and application lifecycle management, including:
o Migration across Access versions and environments
o 32-bit to 64-bit conversion of Access applications and VBA code (PtrSafe, API declarations, ActiveX compatibility)
o Resolution of broken references, deprecated components, and control issues
o Regression testing and validation post-upgrade
o Ensuring minimal disruption to business-critical workflows
- Experience working with large, complex legacy systems
- Strong knowledge of relational data modeling and normalization
- Hands-on experience integrating Access with enterprise databases (DB2, SQL Server, Snowflake, or similar)
- Proven ability in code analysis, reverse engineering, and documentation
- Experience working in regulated environments (banking, finance, insurance)
- Strong stakeholder communication and business analysis skills
What Good Looks Like:
- Can stabilize messy Access ecosystems quickly
- Thinks in terms of data flows and data products, not just tools
- Balances short-term fixes vs long-term modernization
- Comfortable dealing with tribal knowledge gaps
- Strong ownership mindset in high-risk, high-visibility environments
Never miss an opportunity! Create an alert based on the job you applied for.