Senior Access

Title: Senior Access & SQL SpecialistTeam:AI Strategy & Transformation team(Integration Pod)Location:Remote |Experience:7–10 yearsRole OverviewWe are looking for highly versatile, pragmatic individual to join our AI Strategy & Transformation team as a hands-on engineer who pairs deep Microsoft Access/VBA expertise with strong SQL data engineering. You’ll take day-to-day ownership of a mission-critical Access application, help migrate data and algorithms to SQL Server and Azure Synapse, and supporting other initiatives within that environment.You’ll be highly fluent and capable of dealing with a complex Access application (with hundreds of objects, forms, and several thousand lines of VBA code). You’ll be adept at picking up complex form/code, diving in to understand how things work and reworking/improving or building out new capabilities. You’ll assume day-to-day ownership, improve reliability/change control, and partner tomigrate core data stores and selected algorithms from SharePoint/Access to SQL Serverand into ourAzure Synapseenvironment.Responsibilities (Access database)Own day-to-day operations of the Access app (front end + back end): forms, queries, reports, macros, and advanced VBA (class modules, error handling, logging).Diagnose/optimize existing code; refactor for performance and maintainability; reduce technical debt.Manage linked tables (within a SQL database in our Azure environment), implement pass-through queries, and tune for performance.Establish disciplined SDLC for Access: versioning (ACCDE builds), backup/restore, regression testing, change logs, documentation, and release checklists.Improve usability of forms and workflows for content managers.Responsibilities (SQL & Azure)Design and implement SQL Server / Azure SQL schemas, indexes, views, stored procedures, and UDFs to replace/augment Access data stores and calculations.Plan and execute migrations of capabilities into SQL Server with reconciliation, validation, and rollback strategies.Build/operate ELT/ETL with Azure Synapse and/or ADF; parameterize/orchestrate, monitor, and alert.Collaborate with analysts/data scientists to deliver high-quality, well-documented datasets for analytics/BI (e.g., Power BI).Contribute to secure data practices (RBAC, secrets management/Key Vault, row-level security where applicable).Skills/Qualifications (must-have)Microsoft Access expert: complex queries (joins, crosstabs), multi-form architectures, advanced VBA (API/ADO/DAO, performance tuning, robust error handling), pass-through queries, ODBC optimization.SQL expert: strong T-SQL, execution-plan analysis, indexing strategies, window functions, set-based design, stored procedures/UDFs.Data migration experience (SharePoint/Access → SQL Server/Azure SQL) with parity checks and rollback.Engineering discipline: backups, release packaging, documentation, and change control for a business-critical system.Communication: extremely clear written and spoken English in a must.Data capable: strong data/numeracy is very important in order to understand and work with the complex data and algorithms in our environment.Skills/Qualifications (nice-to-have)Azure Synapse, Azure SQL Database/MI, Azure Data Factory; Azure DevOps/Git; PowerShell for automation.Power BI exposure (datasets/models/DAX basics).Data quality frameworks, metadata/cataloguing (e.g., Purview).Experience with Data Governance (Quality, Lineage, Data dictionary, and Security).Proficiency in programming languages such as Python for data engineering tasks.How You Work :Highly organized, self-starting, extremely methodical and conscientious, and able to manage complex projects.Experience supporting and working with cross-functional teams in a dynamic environment.