Senior Data & Application Modernisation Consultant - Contract

• The Missing Link is an Australian IT services and consulting organisation specialising in IT infrastructure, cybersecurity, automation and specialist technology services.
• We are seeking an experienced Senior Microsoft Data Platform Consultant for a short-term client engagement.

Responsibilities

• You will lead the consolidation and migration of an existing Microsoft Access / Excel VBA application to Azure SQL Database.
• The client has limited internal technical capability, so you must be comfortable working directly with business stakeholders to understand the existing application, validate requirements and deliver the solution.
• Analyse and consolidate multiple Microsoft Access databases
• Validate database schemas and data integrity
• Migrate Access schemas and data to Azure SQL
• Develop and execute ETL and data reconciliation
• Configure ODBC connectivity
• Update Excel VBA database connections
• Test existing VBA macros and forms
• Lead UAT and resolve migration issues
• Produce technical and handover documentation

Requirements

• Strong Microsoft Access experience
• Strong Excel VBA experience
• Azure SQL / SQL Server expertise
• Access-to-SQL migration experience
• SQL, ETL and data reconciliation skills
• ODBC configuration and troubleshooting experience
• Strong stakeholder and requirements-gathering skills
• Ability to independently deliver an end-to-end technical solution

Preferred

• Legacy application modernisation experience
• Azure data platform experience
• Financial services or insurance experience
• Consulting experience with non-technical stakeholders
• If you have strong Microsoft Access, VBA and Azure SQL experience and are available for a short-term contract commencing mid-November, apply now with your CV and availability.

Senior Data & Application Modernisation Consultant - Contract

The Missing Link · Sydney, Australia (Hybrid) · Contract · Posted 2026-10-27