(Senior MS Access Database Developer)

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