IP Australia

RFQ No:C2018/10606 - C

Role:Senior Data Analyst

Closing Date:10:00am 8 May 2018

Contract Start Date:1 July 2018

Contract Duration/End Date:30 June 2019 (An option to extend for any period(s) up to 30 June 2021 at the direction of the Department)

Department / IP Australia
RFQ number / C2018/10606 - C
Role / Senior Data Analyst
RFQ closing date / 10:00am 8 May 2018
Citizenship Status / All applicants must be Australian Citizens
Security Clearance / Applicants will be required to undergo a restricted police check
Services/work required / The Senior Data Analyst will be part of a team of other data analysts, database designers, and ETL developers working on a range of IPA projects.
The primary role is to analyse and document the requirements for migrating data from one source to another.
The responsibilities of the Senior Data Analyst will include
  • Analysis of the data in the legacy system and identifying the equivalent data structures and data in the target system.
  • Identify and specify any transformation required for the data to be transferred to the new system.
  • Undertake data profiling of the legacy system to identify any problems that would prohibit data migration and develop necessary cleansing rules.
  • Specify the mapping of data from source to target and the development of specifications that allow ETL developers to create the necessary migration software and testers to validate the ETL software developed.
  • Identify and specify any requirements for successful data migration that are outside the scope of ETL. An example would be data that must be manually corrected.
  • Assist other team members with data issues relating to the source or target systems.
  • Being proactive in the resolution of problems that arise.
  • Mentoring less-experienced Data Analysts.

Additional information / For this role our client have stated that they may impose penalties should the successful candidate terminate this agreement early due to the nature of this environment.
Other Requirements / This role has been deemed Entry Only Level (no Australian Government Security Clearance is required).
Please indicate which applies to your candidate:
Place of Birth:……………………………
(if Australia, no need to continue)
Australian citizen Yes No
Date grantedAustralianCitizenship - dd monthyyyy
Non-Australian Citizen Yes No
Citizenship/Residency
Status:……………………………….

YOUR RESPONSE

Name / First Name / <response>
Surname / <response>
Gender / <response>
Your mobile number / <response>
Your email / <response>
Date of birth / <response>
Home address / <response>
Availability / <response>
Rate (Excluding GST, Payroll Tax and Agency Fee) / Your Rate Excluding GST, Payroll Tax and Agency Fee>
<response>
Citizenship Status / Australian Permanent Resident Work Visa
Security Clearance / Clearance Level: / <response>
Date Granted: / <response>
Department: / <response>
Department contact: / <response>
Referee 1 / Name: / <response>
Title:
Organisation:
Professionals relationship to you:
Phone:
Mobile:
Email:
Referee 2 / Name: / <response>
Title:
Organisation:
Professionals relationship to you:
Phone:
Mobile:
Email:

Required

  • Experience in data analysis and modelling.

Describe your experience in both the development of green-fields data models and the development of data models for legacy systems. Describe how you collected information and validated your models.

  • Extensive hands-on experience in the development of large data models that involve data from multiple sources.

Describe your experience, skills and achievements with large data models and especially in the harmonisation of data concepts from diverse systems.

  • Extensive experience in the ongoing maintenance of enterprise database designs and/or data.

Describe your experience in managing design changes to operational application databases. Describe your experience in developing fixes for production data problems.

  • Demonstrated knowledge and hands-on experience in the migration of one operational system to another.

Describe your experience, skills and achievements in migrating data from one application to another. Also identify your experience with data profiling and data cleansing.

  • Experience with agile projects and tight timeframes.

Describe your experience working on projects with tight timeframes where the full requirements are not understood from the start or where requirements change.

Desirable skills

  • Experience with Sparx Enterprise Architect
  • Experience with Adabas databases.
  • Experience in the Intellectual Property Domain..

Business Address: Unit 4, 15 Tench Street, Kingston. ACT 2604, Mailing address: Po.Box 153 Civic Square, ACT -2608,

Ph: 02 6108 3661, Fax: 02 6108 3662, E-mail: , ABN: 92 129 869 174