Senior Data Migration Analyst

Location Melbourne
Job Type Contract
Reference JO-2104-103920_1619054279
Posted 15 days ago

12 Month contract role - Working from home initially - Close to Melbourne CBD

A Data Migration Specialist is required for the Data Preparation and Migration Stream. As the Data Migration Specialist, you will be experienced leading discussions, determine the project data migration strategy, and ensure project adherence to Data Governance policies. The role will also require you to have experience working with cloud-based hosting services specifically, Microsoft Azure. This will be a very hands on role.

  • 5-8+ years of relevant experience in Data roles and as a Data Migration specialist supporting system migration and data transformation
  • Prior experience with billing systems and Oracle Databases (specifically Gentrack) is advantageous
  • Experience with Microsoft Azure Data Factory would be advantageous
  • Lead, support, and execute the Billing and Collections data migration
  • Provide hands-on technical and development support to the Data Preparation team during the implementation and testing of the solution across multiple environments
  • Perform technical assessments for data migration activities and produce effort estimates
  • Lead end to end testing life cycles activities that are related to the data migration activities
  • Provide technical expertise and strategy for ETL / ELT approach
  • Ensure the meta data is captured and consistent across the target system
  • Good understanding of system data models and data modelling techniques
  • Liaise with the Information Architect and Sr. Data Modeller to comply with Data Governance policies structure and ensure data ownership and stewardship are adhered to
  • Write data mapping reports, analyse the source system, and target platform data requirements
  • Define data extract criteria and data transformation rules
  • Define automated data cleansing rules
  • Agree the mappings with all relevant parties, the business and technical teams.
  • Work closely with the project stream leads to understand the data migration requirements
  • Perform data extraction, cleansing, transformation, validation, reconciliation and be involved in exception handling
  • Engage with application teams to evaluate the viable technical options for migrating data
  • Produce, functional / technical specifications for any developments required to support data migration
  • Strong written and verbal communication skills
  • Strong problem solving and analytical skills

  • Applied programming skills in SQL and ETL tools, including automation of data management
  • Experience with Oracle and MS Azure SQL databases
  • Understanding of cloud migrations (Azure)
  • Demonstrated experience in data mining and data migration
  • Advanced MS Office, Excel, SQL, Visio, ER Studio or equivalent
  • Develop supporting project documentation as required:
    1. Data Migration Strategy and Plans
    2. Data Migration Test Strategy
    3. Data Mapping (Source system to Target system)
    4. ETL / ELT Approach
    5. Parallel Test Runs
    6. Support development of Implementation Plans
    7. Migration Outcome Report

To apply, click the link and upload your current resume in Microsoft Word format only (.doc or .docx), quoting ref no. JO-2104-103920. Want to know more about Davidson? Visit us at