Job Description

Job Header

Data Migration Analyst

Advertiser: Royal Australasian College of Physicians2.7 out of 52.7 overall rating (34 employee reviews) More jobs from this company

Job Information

Job Listing Date
4 Jun 2019
Location
Sydney, CBD, Inner West & Eastern Suburbs
Work Type
Full Time
Classification
Information & Communication Technology, Business/Systems Analysts
Data Migration Analyst
  • Great Sydney CBD location
  • Friendly working environment
  • Fixed term 3 year contract

The Role

The College is undergoing considerable organisational change through which numerous business improvement initiatives and projects are being implemented to improve the way the College delivers services and requirements.

At the same time, the College has embarked on an ambitious multi-year education renewal program which encompasses design, development and implementation projects.

The role will provide input into the Education, Learning And Assessment's (ELA) data strategy and migration plan and work end to end being involved in data creation and migration, data cleansing, data governance set up and business engagement through to data testing and migration. You will be responsible for delivery of quality and fit-for-purpose data reconciliation documentation, including plans, test scripts and reports derived from the approved business and technical requirements and timeframes.

Your responsibilities will include:

  • Assist with the analysis of the datasets in the current training and accreditation administration systems (AU/NZ) 
  • Assist with investigative work to determine future dataset requirements for ELA
  • Liaise with the subject matter experts, expert system users, data and process owner to  enable development of data sources and data target reconciliation reports documents
  • Assist in the verification and enhancement of requirements produced through the detailed design process particularly from data migration perspective
  • Delivery data reconciliation, plans, test scripts and reports artefacts
  • Perform effective data cleansing in preparation for migration
  • Ensure data is formatted, extracted, reviewed and validated for system trials and go lives
  • Provide user acceptance testing, and feedback on new development tools.
  • Utilising a range of tools associated with data extraction
  • Undertake other ad hoc analysis and/or reporting functions as required

The successful candidate

  • 3 to 5 years’ experience with performing Data Validations and Data Reconciliations
  • Demonstrated experience in data analysis across multi systems, data convergence and migration projects
  • Strong knowledge of data processing activities, including databases, ETL tools, data conversion, table management, and table structure.
  • Experience in gathering and documenting data requirements, data migration business rules and development of complex data maps.
  • Experience liaising with the subject matter experts to enable business to reconcile migrated data
  • Ability to understand and deconstruct complex data structures
  • Experience in delivering data reconciliation, plans, test scripts and reports documentation
  • Experience in change projects involving system development and data migration from a number of disparate IT systems to a single source of truth system
  • Experience in working on systems with multiple internal and external interfaces
  • Experience working across a diverse set of teams and maintain a professional relationship
  • Demonstrated experience in developing and executing business data reconciliation plans and reconciliation summary reports
  • Experience in conducting workshops with business and technical audience

Working Together as One

In return for your commitment the College offers you the chance to join a prestigious international organisation. As an educational body, the College encourages its employees to continue their education through our professional development funds and internal training opportunities. Employees of the College also receive access to a range of benefits, including additional paid leave between Christmas and New Year and exclusive employee discounts

 

To apply, please send your resume and short cover letter addressing the criteria listed under "The Successful Candidate" section by 20 June 2019

For the Position Description visit https://www.racp.edu.au/about/careers-at-racp

 

About the Royal Australasian College of Physicians (RACP):

The RACP trains, educates and advocates on behalf of 15,570 physicians and 7,000 trainees across Australia and New Zealand.

The College represents a broad range of medical specialties including general medicine, paediatrics and child health, cardiology, respiratory medicine, neurology, oncology, public health medicine, occupational and environmental medicine, palliative medicine, sexual health medicine, rehabilitation medicine, geriatric medicine and addiction medicine. Beyond the drive for medical excellence, the RACP is committed to developing health and social policies which bring vital improvements to the wellbeing of patients.

www.racp.edu.au

No agencies please | The RACP is an equal opportunity employer

  • Great Sydney CBD location
  • Friendly working environment
  • Fixed term 3 year contract

The Role

The College is undergoing considerable organisational change through which numerous business improvement initiatives and projects are being implemented to improve the way the College delivers services and requirements.

At the same time, the College has embarked on an ambitious multi-year education renewal program which encompasses design, development and implementation projects.

The role will provide input into the Education, Learning And Assessment's (ELA) data strategy and migration plan and work end to end being involved in data creation and migration, data cleansing, data governance set up and business engagement through to data testing and migration. You will be responsible for delivery of quality and fit-for-purpose data reconciliation documentation, including plans, test scripts and reports derived from the approved business and technical requirements and timeframes.

Your responsibilities will include:

  • Assist with the analysis of the datasets in the current training and accreditation administration systems (AU/NZ) 
  • Assist with investigative work to determine future dataset requirements for ELA
  • Liaise with the subject matter experts, expert system users, data and process owner to  enable development of data sources and data target reconciliation reports documents
  • Assist in the verification and enhancement of requirements produced through the detailed design process particularly from data migration perspective
  • Delivery data reconciliation, plans, test scripts and reports artefacts
  • Perform effective data cleansing in preparation for migration
  • Ensure data is formatted, extracted, reviewed and validated for system trials and go lives
  • Provide user acceptance testing, and feedback on new development tools.
  • Utilising a range of tools associated with data extraction
  • Undertake other ad hoc analysis and/or reporting functions as required

The successful candidate

  • 3 to 5 years’ experience with performing Data Validations and Data Reconciliations
  • Demonstrated experience in data analysis across multi systems, data convergence and migration projects
  • Strong knowledge of data processing activities, including databases, ETL tools, data conversion, table management, and table structure.
  • Experience in gathering and documenting data requirements, data migration business rules and development of complex data maps.
  • Experience liaising with the subject matter experts to enable business to reconcile migrated data
  • Ability to understand and deconstruct complex data structures
  • Experience in delivering data reconciliation, plans, test scripts and reports documentation
  • Experience in change projects involving system development and data migration from a number of disparate IT systems to a single source of truth system
  • Experience in working on systems with multiple internal and external interfaces
  • Experience working across a diverse set of teams and maintain a professional relationship
  • Demonstrated experience in developing and executing business data reconciliation plans and reconciliation summary reports
  • Experience in conducting workshops with business and technical audience

Working Together as One

In return for your commitment the College offers you the chance to join a prestigious international organisation. As an educational body, the College encourages its employees to continue their education through our professional development funds and internal training opportunities. Employees of the College also receive access to a range of benefits, including additional paid leave between Christmas and New Year and exclusive employee discounts

 

To apply, please send your resume and short cover letter addressing the criteria listed under "The Successful Candidate" section by 20 June 2019

For the Position Description visit https://www.racp.edu.au/about/careers-at-racp

 

Right to live and work

You must have the right to live and work in this location to apply for this job.

Report this job advert

Be careful- Don’t provide your bank or credit card details when applying for jobs. If you see something suspicious .

Share this role