Senior Data Engineer/BA - SAS/ETL III
Title: Senior Data Engineer/BA - SAS/ETL III (Senior MS Access Database Developer)Location: OH / RemoteDuration: 6 months ContractMust Have32-bit to 64-bit conversion of Access applications and VBA code (PtrSafe, API declarations, ActiveX compatibility)5 years of MS Access developmentAccess forms, reports, macros, and linked tablesComplex SQL (joins, aggregations, performance tuning)Migration across Access versions and environmentsMS Access version upgrades and application lifecycle managementVBA programming (including Windows API usage)Nice To Have Regression testing and validation post-upgradeResolution of broken references, deprecated components, and control issuesJOB DESCRIPTIONWe 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 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: 5 years of experience with MS Access developmentStrong expertise in: VBA programming (including Windows API usage)Complex SQL (joins, aggregations, performance tuning)Access forms, reports, macros, and linked tablesProven experience with MS Access version upgrades and application lifecycle management, including:Migration across Access versions and environments32-bit to 64-bit conversion of Access applications and VBA code (PtrSafe, API declarations, ActiveX compatibility)Resolution of broken references, deprecated components, and control issuesRegression testing and validation post-upgradeEnsuring minimal disruption to business-critical workflows Experience working with large, complex legacy systemsStrong knowledge of relational data modeling and normalizationHands-on experience integrating Access with enterprise databases (DB2, SQL Server, Snowflake, or similar)Proven ability in code analysis, reverse engineering, and documentationExperience working in regulated environments (banking, finance, insurance)Strong stakeholder communication and business analysis skillsWhat Good Looks Like: Can stabilize messy Access ecosystems quicklyThinks in terms of data flows and data products, not just toolsBalances short-term fixes vs long-term modernizationComfortable dealing with tribal knowledge gapsStrong ownership mindset in high-risk, high-visibility environments