Data Warehouse Developer

**Kaiwhakawhanake Pātaka Raraunga**: Data Warehouse Developer (intermediate)
Te Amorangi Mātauranga Matua, the TEC - is a small Crown agency with a big job to do - ensuring New Zealanders have the skills and the knowledge they need to build a great life, and ensure New Zealand thrives. We invest over $3 billion annually across the tertiary education and careers systems.
If you're looking for your “why”, then come and join us at TEC. We truly believe in the transformational benefits of education and vocational training and as a result we invest $3 billion a year in tertiary education and training and seek to lift the aspirations and skill bases of all New Zealanders from ages 7 to 74.
It's an exciting time in the careers and education sector with large scale and meaningful change taking place.

**He angitūtanga**: About the Role
This role reports to the Team Leader - Data/Development. The team is made up of Data Analysts and Data Warehouse Developers at varying levels of experience. This role will be responsible for providing data warehouse analysis and expertise to support business initiatives and information reporting needs.

**Key Accountabilities**:

- Designs, implements and maintains complex data engineering solutions to acquire, prepare and present data.
- Applies data engineering standards and tools to create and maintain data pipelines and extract, transform and load data.
- Plans and drives the development of data engineering solutions ensuring that solutions balance functional and non-functional requirements.
- Contributes to organisational policies, standards and guidelines for data engineering.
- Ensures adherence to technical strategies and architectures.
- Applies knowledge of software development lifecycle and testing practices.
- Carries out Unit testing.

**He kōrero mōu: What we are looking for**:
This is a great opportunity for someone who has some good experience as a Junior Data Warehouse Developer and is looking to move to a more intermediate role or someone who has been working as a Data Warehouse Developer and is looking for their next challenge.

**The position holder will have**:

- 1-2+ years of technology experience that includes hands-on software development, data engineering
- Experience utilising MS SQL Server, SSIS, SSRS and SSAS
- Good understanding of cloud-based data warehousing and ELT/ETL techniques and processes
- Experience in SQL optimization and performance tuning, and development experience in programming languages like Python
- Experience using Agile principles and techniques
- Experience with version control systems like Github and deployment & CI tools

There are many opportunities for you to develop your skills with TEC, with Senior and Principal level roles in the Data/Development Team and also exciting opportunities within the wider organisation.

**Ngā āhuatanga kei a mātou**: What's in it for you
- Three additional (TEC Days) leave days
- A range of benefits including flexible working options, a wellness programme and the ability to purchase extra leave.
- A motivated and supportive manager, keen to make the most of your skill set
- Reduced premiums through our Health Insurance Group Scheme
- A focus on Career development and internal opportunities

The salary range for this position starts from $82,034 up to $96,511+ depending on demonstrable skills and experience.

**Me pēhea te tuku tono**: How to Apply
Applicants must have the ability to obtain and maintain the legal right to work in New Zealand.
Prior to the Tertiary Education Commission confirming any offer of employment, pre-employment checks will be undertaken including criminal conviction history and reference checking as a minimum.