Senior Access

Job Description Title: Senior Access & SQL Specialist Team:AI Strategy & Transformation team (Integration Pod) Location: Remote | Experience: 710 years Role Overview We 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 to migrate core data stores and selected algorithms from SharePoint/Access to SQL Server and into our Azure Synapse environment. 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.