Docstoc

Candidate Kit

Document Sample
Candidate Kit Powered By Docstoc
					GENERAL                 JOB CANDIDATES            INSTRUCTIONS              DECEMBER 11

SEGMENT                 AUDIENCE                  FORMAT                    DATE




  Candidate
  information kit
  Expression of interest
  This kit provides information about the advertised job and our
  selection process.

    Job title:                IT Teradata Physical Data Modeller
    APS level:                APS6
    Sub-plan:                 Enterprise Solutions and Technology
    Business line:            Enterprise Applications
    Section:                  Business Intelligence, Data Warehouse
    Location:                 Chermside
    Working arrangements:     Full-time
    Type of employment
                              Temporary transfer at level or higher duties allowance
    opportunity:
    Expected duration of
                              Up to 6 months with possible extension
    employment:
    Security classification
                              Highly Protected
    of position:
    Contact officer:          Mark Meaden
                              (07) 321 38523
    Contact details:
                              0422 556 011
    Closing date:             16 June 2010, 5.00 pm (AEST)
UNCLASSIFIED                                                                                                 CANDIDATE INFORMATION KIT




Table of contents
Table of contents....................................................................................................................... 2
Where the job fits ...................................................................................................................... 3
  The Enterprise Solutions and Technology Sub-plan ............................................................. 3
  Enterprise Applications ......................................................................................................... 3
The job ...................................................................................................................................... 4
  Job description ..................................................................................................................... 4
  Duty statement ..................................................................................................................... 4
  Selection criteria ................................................................................................................... 5
The selection process ............................................................................................................... 6
  Eligibility ............................................................................................................................... 6
         More information ............................................................................................................. 6




UNCLASSIFIED                                                                                                                     PAGE 2 OF 6
UNCLASSIFIED                                                              CANDIDATE INFORMATION KIT




Where the job fits

The Enterprise Solutions and Technology Sub-plan
The EST Sub-plan supports ATO outcomes by providing efficient and effective enterprise
solutions and information technology (IT) services. This includes IT architecture and design
services, applications, infrastructure, and security services. EST also provides leadership of our
enterprise processes and capabilities.

Through ongoing advice and support, the EST Sub-plan builds strong relationships by
collaborating with key stakeholders and service providers. The EST Sub-plan:
     ensures IT systems are reliable, responsive and available
     supports and facilitates ATO change and innovation, by leading and governing
       enterprise capabilities including: IT strategy, architecture, design processes, information
       management, systems and technology, risk management, intelligence, project
       management, IT security and information security
     optimises and leverages enterprise technology, systems and processes
     manages ATO technology investments in a robust and transparent process.

The EST Sub-plan comprises six areas:
    Change Program
    Business Solutions
    Enterprise Applications
    Office of the Chief Knowledge Officer
    Strategy, Planning and Assurance
    Business & ICT Provider Relations.


Enterprise Applications
Enterprise Applications provides support for current systems, legacy systems and new systems
being developed. This extensive framework integrates the elements of applications
management and also serves as a model to effectively deliver applications development
outcomes.
Enterprise Applications supports a work force of over 1200 people engaged in a broad and
diverse range of activities relating to the design, delivery and management of the business
systems that underpin our administrative and compliance platforms within the Australian
Taxation Office.




UNCLASSIFIED                                                                            PAGE 3 OF 6
UNCLASSIFIED                                                                   CANDIDATE INFORMATION KIT




The job

Job description
As a Data Analyst / Modeller, you will be responsible for the delivery and support of a wide
spectrum of activities, including:
       data modelling and physical database design for the Teradata environment
       designing and tuning native Teradata SQL and Stored Procedures
       supporting ETL processing of mainframe (DB2), mid-range (Datastage and SQL Server)
        and business defined data sets for legacy and the new enterprise data warehouse
       undertaking support tasks to maintain and deliver upon design / build work for logical
        data mart models used by the suite of Cognos reporting applications.
We are looking for a results-driven team player, with a strong attention to detail and the ability
to demonstrate or quickly acquire a strong understanding of Teradata relational databases and
dimensionally modelled data marts. Previous experience in either systems development or in a
business analysis / data analysis role is considered advantageous.
The position requires a ‘Highly Protected’ security clearance. The successful candidate must be
prepared to undergo the security clearance process at this level.


Duty statement
The occupant will either individually or in co-operation with other technical specialist undertake
the following duties:
       undertake data modelling and physical database design activities, primarily in the
        Teradata data warehouse environment and Cognos reporting environment
       undertake systems analysis and/or systems design and tuning of SQL queries
       undertake systems analysis and/or systems technical design and tuning of analytical
        models based in Teradata SQL
       identify, build and manage relationships with other Senior Technical Specialists to
        resolve operational issues that arise
       prepare and maintain technical documentation, and produce operational reports for
        technical and business audiences
       manage and assist with the investigation and resolution of complex technical issues
        involving the data warehouse and related data flows
       ability to provide technical and end user support for ETL processing of mid-range,
        mainframe and user defined datasets
apply Tax Office and APS people policies and practices, including employment equity and diversity,
occupational health and safety, workplace relations and access and equity, and the ability to encourage
and develop appropriate behaviours




UNCLASSIFIED                                                                                  PAGE 4 OF 6
UNCLASSIFIED                                                         CANDIDATE INFORMATION KIT




Selection criteria

1. Technical skills
      Demonstrated experience in writing and tuning SQL queries (Teradata specific SQL an
       advantage but not essential)
      Ability to demonstrate / quickly acquire an understanding of the Cognos reporting
       environment
      Ability to demonstrate / quickly acquire an understanding of the Teradata technical
       architecture and data warehouse operational environment – including security and
       access controls, data provisioning, ETL processing and reporting, and the packaging
       and deployment of Teradata Objects.
      Experience in data management and database design.
      Understanding of the principles, practices and techniques of data modelling and
       physical database design.
      Experienced in working on a Microsoft platform.

2. Strategic thinking
      Harnesses information and opportunities
      Shows judgement, intelligence and commonsense

3. Achieves results
      Uses professional expertise
      Ensures closure and delivers on intended results

4. Productive working relationships
      Facilitates cooperation and partnerships

5. Personal drive and integrity
      Demonstrates public service professionalism and probity
      Commits to action

6. Communicates with influence
      Communicates clearly




UNCLASSIFIED                                                                       PAGE 5 OF 6
UNCLASSIFIED                                                               CANDIDATE INFORMATION KIT




The selection process
All ATO job applications are to be submitted through the online application system, prior to the
closing date. You will not be able to edit or submit your application once the closing time has
passed. Applicants who are unable to apply online will need to email or phone the contact
officer prior to the closing date.

You should restrict your responses to the length specified on the online application form, and
wherever possible include specific relevant examples of your work.
Your experience and skills will be assessed against the requirements of the position to
determine your suitability. If you are successful, a release date will be negotiated with your
current manager.


Eligibility
To be eligible to apply for vacancies, you must be a current ongoing ATO employee. For
vacancies advertised as transfer at level, you must be at the same substantive level as the
vacancy.
Please speak with the vacancy contact officer if you have any concerns or questions regarding
your eligibility.


   More information

You can find more information about how to apply for vacancies using e-Recruitment on the
careers site, please read the applicant user guide before accessing the system for the first time.
General recruitment information is also available on the careers site.




UNCLASSIFIED                                                                             PAGE 6 OF 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:12/11/2011
language:
pages:6