Principal Data Warehouse DeveloperTe 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 7 to 74.It's an exciting time in the careers and education sector with large scale and meaningful change taking place.Mohiohio : Information DirectorateThe Information Directorate delivers the ICT infrastructure and information tools to support the business and develops data, data products, information, and new tools for colleagues, customers, TEOs, and other agencies to support TEC's invest and champion goals.He angitutanga : About the RoleReporting to the Team Leader Data / Development, the Principal Data Warehouse Developer provides data warehouse analysis and development expertise to support business initiatives and information reporting needs.Develop organisational policies, standards, and guidelines for the development and secure operation of data services and products.Plan and lead data engineering activities for strategic, large, and complex programmes.Use your extensive experience in dimensional data modelling, extensive knowledge of SQL, and deep understanding of database full lifecycle designing and application development.Provide expert guidance, mentoring, and support to other team members.Work with Data Architects and Data Analysts to model implementation options and build technical solutions that meet business requirements.Substantial technology experience that includes hands-on software development, data engineering, and systems architecture experience.Strong understanding of cloud-based data warehousing and ELT / ETL techniques and processes.Strong experience in SQL optimisation and performance tuning, and development experience in programming languages like Python.Experience with version control systems like Github and deployment & CI tools.Possess the people skills to mentor staff, provide feedback, and work with the team to build skill and capability.Nga ahuatanga kei a matou : What's in it for youUp to 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 $125,813 up to $148,015 + 3% KiwiSaver depending on demonstrable skills and experience.Me pehea te tuku tono : How to ApplyTo view the job description and/or apply for the role, please click Apply For This Job or visit the TEC Careers Portal.If this sounds like you, please apply now for this great opportunity with your tailored Cover Letter and CV. We welcome your application.The closing date for this role is 5:00pm 13 October 2024. For more information or if you have any questions, please contact ******** 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.The TEC is an equal opportunity employer and committed to providing a working environment that embraces and values diversity and inclusion.Your unique talents and experience will help us deliver exceptional services to New Zealand. We look forward to your application. #J-18808-Ljbffr