Apply for Data Migration Lead at Showtime Consulting in Canberra, ACT, AU. This full‑time, on‑site position offers great opportunities for growth opportunities.

Role Overview

Showtime Consulting is a leading provider of Shielded Cloud and Digital Solutions across Australia and New Zealand, specialising in secure, enterprise‑scale technology solutions across cloud, data, DevSecOps, platform engineering, and digital transformation. The Data Migration Lead will join a high‑performing delivery team to support a large‑scale enterprise data migration initiative.

Key Responsibilities

- Provide technical leadership, guidance, and mentoring to a small data migration team.
- Design, develop, and maintain data migration solutions using SQL Server Integration Services (SSIS).
- Develop and optimise complex SQL queries, stored procedures, views, and database objects to support migration activities.
- Perform ETL across multiple source and target systems.
- Work closely with business stakeholders, analysts, architects, and technical teams to understand migration requirements and define migration strategies.
- Develop data mapping specifications and transformation rules to ensure accurate migration outcomes.
- Perform data cleansing, profiling, validation, reconciliation, and quality assurance activities throughout the migration lifecycle.
- Investigate and resolve data migration issues, discrepancies, and performance bottlenecks.
- Ensure the accuracy, completeness, and integrity of migrated data through comprehensive testing and validation processes.
- Support migration rehearsals, cutover planning, production deployments, and post‑migration activities.
- Monitor and optimise ETL processes, SQL performance, and migration execution efficiency.
- Develop and maintain migration documentation, technical specifications, reconciliation reports, and operational procedures.
- Collaborate with project managers, business teams, and technical stakeholders to manage delivery timelines and risks.




- Provide production support and troubleshooting during critical migration and deployment activities.

What You’ll Need

- Experience in data migration, ETL development, database engineering, or related technical roles.
- Strong hands‑on experience with SQL Server Integration Services (SSIS).
- Advanced SQL development skills, including stored procedures, views, functions, query optimisation, and performance tuning.
- Experience with Microsoft SQL Server, SQL Server Management Studio (SSMS), and SQL Server Agent.
- Strong understanding of data quality, data governance, and migration best practices.
- Experience troubleshooting migration defects, data discrepancies, and ETL performance issues.
- Experience leading technical teams or providing technical leadership within project environments.
- Excellent analytical, problem‑solving, communication, and stakeholder management skills.
- Bachelor’s degree in Computer Science, Information Technology, or a related discipline.

Desirable Skills

- Experience with Salesforce Health Cloud or related Salesforce platforms.
- Experience delivering healthcare, government, or enterprise‑scale data migration programs.
- Knowledge of data profiling and data quality assessment techniques.
- Experience working within Agile delivery environments.
- Exposure to cloud‑based data platforms and integration technologies.
- Experience with migration planning, cutover management, and deployment support.
- Knowledge of data security, privacy, and compliance considerations within migration projects.

Why Join Us?

Work on large‑scale enterprise data migration and digital transformation initiatives.

Lead critical migration activities that directly support business transformation outcomes.

Collaborate with experienced data, integration, architecture, and delivery specialists.

Influence migration strategy, technical standards, and delivery best practices.

Gain exposure to complex enterprise ecosystems and modern data transformation programs.

This role is only available for Australian residents.

#J-18808-Ljbffr

📌 Data Migration Lead at Showtime Consulting (Canberra)
🏢 Showtime Consulting
📍 Canberra