Unfortunately, due to a system outage, access to the IP Australia recruitment system will be suspended until Tuesday, 23 April 2019.
During this time we welcome applications via email to the IP Australia Recruitment Team - email@example.com
We apologise for this inconvenience.
Please contact us on (02) 6283 2567 during business hours should you have any questions.
**Please note IP Australia will be closed on the Easter public holidays.
Position Title: Senior ETL Developer
Position Number: 8096
Group: Innovation and Technology
Division: Policy and Corporate
Immediate Supervisor: Executive Level 2
Security Classification: BASELINE
The Innovation and Technology Group (ITG) is responsible for developing and delivering the technology strategy and continued digital transformation of IP Australia across all levels of the organisation’s internal and external interactions.
This is done by embracing transformational and innovative technologies embodying a customer centric and agile culture to deliver smart solutions and new approaches that significantly improve both our internal and external stakeholder experiences. In working in this way, the Innovation and Technology Group is set to position IP Australia as both a domestic and international ICT leader.
The Innovation Section drives innovation and undertakes business transformation and innovation using emerging technologies to deliver strategic improvements across the intellectual property ecosystem. The section is driving internal business transformation through the implementation of cognitive computing, management of intellectual property rights data holdings, automation and process re-engineering. Externally, the section is developing innovative products, capabilities and services through engagement with key stakeholders to ensure Australians benefit from their great ideas.
Job Description / Context of the Role
The successful applicant will work as part of IP Australia’s RIO Program Data and Information Project. You will be required to assist in the delivery of high profile project outputs in support of the significant organisational benefits being delivered by the RIO Program.
Job Specific Duties
- As part of a team, leverage relationships, apply insights, and provide technical leadership into the sourcing, handling and transformation of IP Australia data to support the IP Rights Management Systems (IPRMS).
- Work as part of a team to design, model and build ETL routines for sourcing the data from legacy systems, transforming the data and loading it into IP Rights management systems.
- Develop and maintain technical documentation for supporting the data migration activities.
- Apply Release Management and Change Management procedures.
- Demonstrate attitudes and behaviours responsive to workplace change (including participating in and encouraging others to participate in change and contribute to successful outcomes)
- Improve organisational performance through effective engagement with and management of risk within relevant sphere of influence.
- Establish clear expectations and create an environment to achieve stated goals and objectives, take ownership and honour commitments.
- Maintain an understanding of their/worker responsibilities under the Work Health & Safety Act 2011 (WHS Act) and a commitment to promoting a healthy and safe workplace.
Job Specific Capabilities
- Demonstrated experience in transforming and migrating data between operational systems.
- Demonstrated experience in ETL development including design, build, test and deployment activities using enterprise ETL software tools such as Informatica PowerCentre or similar.
- Demonstrated skills and experience in SQL and PL/SQL in Oracle databases (with emphasis on data transformation and migration).
- Experience in data profiling and data quality analysis.
- Experience working on a mid to large-scale data migration and/or data warehouse project.
- Experience with the internal data structures of the Objective EDMS and migration of data from it to other systems.
- Ability to exercise mature technical leadership in handling, transforming and migrating Agency data holdings (structured and unstructured data) between systems.
- Well-developed organisational skills including the ability to prioritise and collaborate with others to achieve deadlines.
- Proficient verbal and written communication skills.
- Proficient interpersonal, liaison and negotiation skills.
- Intellectual property system (i.e. patents, trade marks, designs and plant breeder’s rights).
- Emerging technologies (i.e. machine learning, automation and digital assistants) is highly desirable but not essential.
Eligibility Qualifications / Knowledge Required
Candidates with IT qualifications would be highly regarded.
To apply for this position, candidates are asked to frame their responses around the job specific duties and job specific capabilities of the role (as set out in this job documentation), and provide:
- An explanation of how their skills, knowledge and experience will be relevant to this role (500 words maximum)
- Details of two (2) professional achievements, within the last 5 years, that demonstrate their suitability for this role (250 words maximum per achievement)
- A current CV detailing recent employment history which is relevant to the advertised position.
Names and contact details of two referees.
Applications must be submitted through the IP Australia Web Recruitment system (ESS).
Please note: you MUST be an Australian Citizen to be engaged in the APS and to meet IP Australia’s security clearance requirements.
For further information pertaining to this job please contact Andrew Peyton on (02) 62832031.
Working in IP Australia
Australia’s Intellectual property (IP) rights system supports innovation, investment and international competitiveness. IP Australia administers Australia’s IP rights system, specifically patents, trade marks, designs and plant breeder’s rights. IP Australia also undertakes programs to educate and promote an awareness of intellectual property (IP), provides IP policy input to Government, develops legislation to support the IP system and contributes to bilateral and multilateral negotiations to improve IP protection internationally.
IP Australia strives to deliver robust IP rights efficiently, satisfy our customers in terms of timeliness and value for money and be recognised as one of the leading IP offices in the world for the quality (including accuracy and consistency) of the IP rights we grant. IP Australia is committed to external certification of our Quality Management System which involves applying ISO 9001:2008 to key business processes and to environmental management through ISO14001 certification within the agency.
All IP Australia staff contribute to the achievement of organisational outcomes and the overall management of IP Australia by assisting, as appropriate, the Commissioner of Patents and the Registrars of Trade Marks and Designs and Plant Breeder’s Rights, and their deputies (where relevant), to perform statutory functions, and where appropriate, exercise relevant delegations.
IP Australia recognises the importance of employees balancing their work and personal lives by offering staff access to an ongoing series of health and wellbeing programs, flexible work-life policies and a range of professional development programs. IP Australia is a breastfeeding friendly workplace.
The IP Australia office in Canberra provides high quality accommodation and facilities. These include: an on-site café, conference, meeting and training rooms; limited on-site parking for cars and motor cycles available on a rotational basis; the provision of undercover bicycle racks; excellent shower/change facilities for staff choosing to walk or ride to work; and the advantage of all staff being co-located in the one building.
Please note: All IP Australia positions are subject to an ENTRY ONLY pre-employment check unless a higher security clearance has been identified. Other pre-employment checks may also apply.