(Senior MS Access Database Developer)
Posted 4 days ago by Javen Technologies, Inc
Negotiable
Undetermined
Remote
Remote
Summary: The Senior Data Engineer/BA - SAS/ETL III role focuses on supporting and modernizing critical desktop-based data applications for commercial lending, underwriting, and regulatory reporting. The position requires maintaining legacy MS Access solutions while optimizing and migrating them to scalable enterprise data platforms. The ideal candidate will possess extensive experience in MS Access development and VBA programming, with a strong emphasis on performance tuning and integration with enterprise data sources. This role is remote and is expected to last for six months.
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, and 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.
Key Skills:
- 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.
- 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.
Salary (Rate): undetermined
City: undetermined
Country: undetermined
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Title: Senior Data Engineer/BA - SAS/ETL III (Senior MS Access Database Developer)
Location: OH / Remote
Duration: 6 months Contract
Must Have
- 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
- Regression testing and validation post-upgrade
- Resolution of broken references, deprecated components, and control issues
JOB DESCRIPTION
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:
- Migration across Access versions and environments
- 32-bit to 64-bit conversion of Access applications and VBA code (PtrSafe, API declarations, ActiveX compatibility)
- Resolution of broken references, deprecated components, and control issues
- Regression testing and validation post-upgrade
- 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