{"schemaVersion":"jobsearcher.job.v1","id":"4836155e645d77d373f40c3c","url":"https://jobsearcher.com/jobs/4836155e645d77d373f40c3c","canonicalUrl":"https://jobsearcher.com/jobs/4836155e645d77d373f40c3c","title":"Microsoft Access/VBA Database Developer","description":"Encore Talent Solutions is currently seeking a Microsoft Access/VBA Database Developer for a position that can work remotely.Key ResponsibilitiesDesign, 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 elementsBusiness logicData lineage and dependenciesCollaborate 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 modelsProcess flowsTransformation logicPartner 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 environmentsMS Access version upgrades and application lifecycle managementResolution of broken references, deprecated components, and control issuesRegression testing and validation post-upgradeExperience working with large, complex legacy systemsStrong knowledge of relational data modeling and normalizationProven ability in code analysis, reverse engineering, and documentationExperience working in regulated environments (banking, finance, insurance)Strong stakeholder communication and business analysis skillsPreferred QualificationsExperience 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.","company":"Encore Talent Solutions","rawCompany":"encore talent solutions","city":"Dayton","state":"OH","isRemote":false,"isActive":false,"createdAt":"2026-05-15T02:27:38.113Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Microsoft Access/VBA Database Developer","description":"Encore Talent Solutions is currently seeking a Microsoft Access/VBA Database Developer for a position that can work remotely.Key ResponsibilitiesDesign, 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 elementsBusiness logicData lineage and dependenciesCollaborate 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 modelsProcess flowsTransformation logicPartner 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 environmentsMS Access version upgrades and application lifecycle managementResolution of broken references, deprecated components, and control issuesRegression testing and validation post-upgradeExperience working with large, complex legacy systemsStrong knowledge of relational data modeling and normalizationProven ability in code analysis, reverse engineering, and documentationExperience working in regulated environments (banking, finance, insurance)Strong stakeholder communication and business analysis skillsPreferred QualificationsExperience 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.","datePosted":"2026-05-15T02:27:38.113Z","dateModified":"2026-05-15T02:27:38.113Z","hiringOrganization":{"@type":"Organization","name":"Encore Talent Solutions","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dayton","addressRegion":"OH","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"4836155e645d77d373f40c3c"},"url":"https://jobsearcher.com/jobs/4836155e645d77d373f40c3c"}}