Microsoft Access/VBA Database Developer

Encore Talent Solutions is currently seeking a Microsoft Access/VBA Database Developer for a position that can work remotely.

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:

• Proficiency in: MS Access development, VBA programming (including Windows API usage), Complex SQL (joins, aggregations, performance tuning), Access forms, reports, macros, linked tables, DB2, SQL Server, Snowflake, ODBC/OLE DB.
• Strong problem-solving and analytical skills.
• Excellent communication and teamwork abilities.
• 5+ years of experience in MS Access development.
• Strong expertise in:
• 32-bit to 64-bit conversion of Access applications and VBA code (PtrSafe, API declarations, ActiveX compatibility)
• Migration across Access versions and environments
• MS Access version upgrades and application lifecycle management
• Resolution of broken references, deprecated components, and control issues
• Regression testing and validation post-upgrade
• Experience working with large, complex legacy systems
• Strong knowledge of relational data modeling and normalization
• Proven ability in code analysis, reverse engineering, and documentation
• Experience working in regulated environments (banking, finance, insurance)
• Strong stakeholder communication and business analysis skills

Preferred Qualifications

• Experience with: Regression testing and validation post-upgrade, Resolution of broken references, deprecated components, and control issues.

Encore Talent Solutions is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce.