Data Analyst

**ARPC Position Description**

**Function**:Operations **Classification broadband**:ARPC5_6

**Location**:Sydney **Security clearance**:Baseline

**Role Reports to **(role title)**:Head of Information Technology

**Direct Reports **(role titles)**:Nil

**Purpose of the role **(Why the role exists; how the role contributes to the ARPC’s strategic objectives)

This role enables ARPC’s strategic priority of providing data driven insights via service and support to the
business in relation to its data assets. The role will provide technical support via maintenance of the data
assets, including extract, transform and load (ETL) design and maintenance between source systems and the
data warehouse. The role also builds and maintains ARPC’s management reporting.

**Key Accountabilities** (Key activities, tasks, and outcomes to be achieved)**
**Data systems support**
- Support the development and implementation of a data roadmap that aligns with ARPC IT Cloud First

principle to meet the business strategic and operational outcomes.
- Plan and deployment of technology infrastructure and CI/CD data pipelines to store and process large

amounts of data to serve analytics models.
- Develop and maintain databases by acquiring data from primary and secondary sources and build

scripts that will make our data evaluation process more flexible or scalable across datasets.
- Maintaining relevant procedures, documentation, monitoring and control of all relevant systems and

data to support information governance, integrity, privacy, security, and regulatory requirements.
- Enhance and maintain actuarial data marts within the data warehouse.

**Reporting and analysis**
- Create and maintain rich interactive reporting and visualizations through data interpretation and
- analysis, with components from multiple data sources.- Work closely with ARPC business teams to understand and maintain focus on their analytics needs,

including critical metrics and KPIs.

**Other**:

- Participate in other ARPC Corporate projects and initiatives as and when opportunities arise.- Role model ARPC’s Values and Code of Conduct and capabilities set out in ARPC’s Capability

Framework

**Key legislative / regulatory role responsibilities**
**Public Interest Disclosure Act 2013 (PID Act)**
- ARPC Managers may receive disclosures from staff they supervise or manage and are responsible for

providing to an ARPC Authorised Officer (CEO, CFO, COO) as soon as practicable, any information
provided to them that concerns disclosable conduct (within the definition of PID Act S.60A).
- ARPC Managers must assist the ARPC CEO (or delegate) and/ or the Commonwealth Ombudsman in

the conduct of a PID investigation.

***
- ARPC staff must assist the ARPC CEO (or delegate) and/ or the Commonwealth Ombudsman in the

conduct of a PID investigation.
**Privacy Act 1988**:

- ARPC staff must adhere to the Australian Privacy Principles and the ARPC Privacy Policy and report

any privacy breaches by any employee or contractor to the Privacy Officer (CFO) and/ or Privacy
Champion (COO) as soon as they become aware of them.

**Freedom of Information Act 1982 (FOI Act)**:

- ARPC staff are responsible for notifying and supporting the Information Public Scheme (IPS) Team to
- ensure published website Information is accurate, up-to-date and complete.- ARPC ‘owners’ of website content are required to review content on their page(s) at least annually.

**Security**:

- Responsible for monitoring their staff (including contractors), resources and functions to ensure
- security controls are maintained and operate effectively.- Responsible to ensure that staff (including contractors) are aware of and practice the appropriate

security procedures for protecting individuals, official information, and other valuable resources.

**Working Relationships **(Key stakeholders, clients, customers, suppliers, providers, consultants, etc.)***

**Internal Relationships**:

- Build and maintain strong relationships across ARPC by working closely with the business

**External Relationships**:

- Build and maintain strong relationships with industry peers

**Person specification
**Qualifications and experience**

**Qualifications **(indicate whether mandatory or desired)
- Tertiary qualification in computer science, IT, mathematics, statistics, or a related field. _Mandatory_

or
- Relevant intermediate/advanced Azure Data certifications. _Mandatory_

**Knowledge and experience **(minimum type and level of knowledge and experience required to perform the
role)
- Strong development & hands on solution design experience with Azure stack - Azure PaaS services,

Azure SQL, Azure Data Factory, Azure Data Warehouse, Azure Synapse Analytics and Power BI.
- Mandatory_
- Expertise in scripting in SQL or Python. _Mandatory_
- Technical writing experience in relevant areas, including queries, reports, and presentations
- Mandatory_
- Knowledge of insurance, reinsurance banking or financial serv