Data Warehouse Developer

**Data Warehouse Developer (intermediate) : Kaiwhakawhanake Pataka Raraunga**: - An exciting senior-level opportunity to be an integral part of a key data platform modernisation programme of work - Work on modern tools and technologies such as Databricks and Azure Data Factory - Wellington-based role in a modern office space Te Amorangi Matauranga 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. We are looking for an intermediate-level Data Warehouse Developer to join our Data/Developer team on a permanent basis. This is a great opportunity for someone who is wanting to contribute to meaningful work and be an integral part of a key data platform modernisation programme of work. **He angitutanga**:_About the Role_** This role reports to the Team Leader - Data/Development, and you will be working within a cross-functional team of Data Warehouse Engineers and Data Analysts. You will be part of the team developing data pipelines, optimising existing workloads and ensuring reliability of workloads. This role will be responsible for providing data warehouse 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 korero mou**_:_**_ _**_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 with version control systems like Github and deployment & CI tools - Experience using Agile principles and techniques There are many opportunities for you to develop your skills with TEC, with Senior and Principal level roles in the Data/Development Team and exciting opportunities within the wider organisation. **_ Nga ahuatanga kei a matou_**:_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 - At TEC we are committed to supporting a range of flexible working arrangements to help staff manage their work and personal commitments, we also expect team members to be in the office at least three days per week to help collaboration. The salary range for this position starts from $87,997 up to $103,526 + 3% KiwiSaver depending on demonstrable skills and experience. **Me pehea 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.