30 Oct
|
The Missing Link
|
Sydney
30 Oct
The Missing Link
Sydney
About The Missing LinkThe 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.About the RoleYou 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.Key ResponsibilitiesAnalyse and consolidate multiple Microsoft Access databasesValidate database schemas and data integrityMigrate Access schemas and data to Azure SQLDevelop and execute ETL and data reconciliationConfigure ODBC connectivityUpdate Excel VBA database connectionsTest existing VBA macros and formsLead UAT and resolve migration issuesProduce technical and handover documentationRequirementsStrong Microsoft Access experienceStrong Excel VBA experienceAzure SQL / SQL Server expertiseAccess-to-SQL migration experienceSQL, ETL and data reconciliation skillsODBC configuration and troubleshooting experienceStrong stakeholder and requirements-gathering skillsAbility to independently deliver an end-to-end technical solutionDesirableLegacy application modernisation experienceAzure data platform experienceFinancial services or insurance experienceConsulting experience with non-technical stakeholders
#J-*****-Ljbffr
📌 Senior Data & Application Modernisation Consultant - Contract (Sydney)
🏢 The Missing Link
📍 Sydney