Senior Data Migration Engineer - Technology And Systems Integration

Job DescriptionOur Enterprise Technology and System Integration team brings together skills in intelligent automation, data engineering and software integration to help our clients align their technology capabilities with their strategic and operational objectives. We also draw on KPMG's extensive national and global resources, adopting a multidisciplinary approach to help unlock the full potential of existing and new technology investments.We are seeking a highly skilled Data Engineer to join the Data Migration team. The successful candidate will be responsible for developing ETLs on Azure Synapse to facilitate the migration of data from customers' on-premise applications to new SaaS-based systems. This role requires strong technical expertise in ETL processes, and Azure Data Factory / Synapse, as well as excellent problem-solving and communication skills.Your new opportunityAs a member of our Technology and System Integration team, the Senior Data Migration Engineer will play a crucial role through the following responsibilities:

• Work with functional experts to understand Data Migration requirements and translate into data engineering and data analytics functionality.
• Design and implement data integrations, pipelines, and algorithms to extract and transform data from various sources into a format ready to load into target systems.
• Design and development of data profiling tools to analyse and understand the structure, quality, and integrity of data prior to migration.
• Implement reconciliation reports to verify and validate data accuracy post-migration, identifying discrepancies and ensuring consistency between source and target systems.
• Aid in scoping, estimation, and task planning for assigned projects.
• Perform testing of ETL processes and data profiling tools, debugging issues and refining operations based on feedback and requirements.
• Document the ETL processes, data profiling methods, and reconciliation procedures to maintain clear and accessible records for future reference and compliance.
• Keep up-to-date with the latest tools, technologies, and best practices in data engineering to continuously improve the quality and efficiency of work.

How are you extraordinary?

• You are passionate about the importance of fantastic communication to share ideas, inspire, and create change.
• You love being part of a collaborative and multidisciplinary team and building strong relationships both internally and externally.

Your ExperienceAt KPMG, we believe diversity of thought, background and unique experience strengthens relationships and delivers meaningful benefits to our people, our clients and communities. To be considered for this opportunity, your qualifications, skills & experience could include:

• Proven experience in ETL development with Azure Synapse or Azure Data Factory and Azure SQL Database.
• Strong skills in programming languages such as Python, and SQL.
• Strong understanding of data warehousing concepts and technologies.
• Comfortable in an Agile working environment and using Scrum project management.
• Strong analytical and problem-solving skills to troubleshoot issues during the migration process and optimize data workflows.
• High attention to detail to accurately implement ETL processes and generate precise reconciliation reports.
• Experience of building ETL solutions against COTS or SaaS based applications, such as TechnologyOne, SAP, Oracle ERP or Microsoft Dynamics is desirable.

Additional InformationKPMG is a professional services firm with global outreach and deep sector experience. We work with clients across an array of industries to solve complex challenges, steer change and enable growth.Our people are what make KPMG the thriving workplace that it is and what sets us apart is that we know great minds think differently. Collaborate with a team of passionate, highly skilled professionals who've got your back. You'll build relationships with unique and diverse colleagues who will provide you with the support you need to be your best and produce meaningful and impactful work in an inclusive, equitable culture.At KPMG, you'll take control over how you work. We're embracing a new way of working in many ways, from offering flexible hours and locations to generous paid parental leave and career breaks. Our people enjoy a variety of exciting perks, including retail discounts, health and wellbeing initiatives, learning and growth opportunities, salary packaging options and more.Diverse candidates have diverse needs. During your recruitment journey, information will be provided about adjustment requests. If you require additional support before submitting your application, please contact the .At KPMG every career is different, and we look forward to seeing how you grow with us.