BI & Data Warehousing Software Engineer (Azure ETL)

Christchurch City Council; Christchurch; On-site; NZD 99,000 - 110,000; Full time

Benefits offered by this job

Training & development

Flexible work arrangements

Collaborative environment

Staff benefits

Job summary

Christchurch City Council is seeking a Software Engineer in the Business Intelligence team to deliver trusted information and analytics to Council. You will collaborate with BI experts to unlock insights from enterprise data, integration and cloud platforms.

You will join a large Digital Unit, contributing to data pipelines, reporting platforms, and documentation while working in Agile SCRUM environments across the organisation to support informed decision-making.

Qualifications

• Experience in enterprise data warehousing ETL using the Microsoft stack (SSMS, SSIS), SQL and Kimball data modelling techniques.
• Grow capability in cloud BI solutions using Azure Data Factory.
• Experience in SAP's Business Intelligence solutions including SAP HANA Studio, BW4HANA, and SAP BW Modelling would be advantageous but not essential.

Responsibilities

• Design, develop, test and implement data integration, business intelligence and data warehousing solutions.
• Work closely with business stakeholders, analysts and technical specialists to understand requirements and deliver fit-for-purpose solutions.
• Support reporting and analytics platforms that help inform Council decision-making.
• Develop and maintain ETL processes and data pipelines using Microsoft's BI and data platforms.
• Contribute to solution design and ensure alignment with Council's technology architecture and strategy.
• Work within Agile teams using the SCRUM framework to deliver quality outcomes.
• Support continuous improvement initiatives and identify opportunities to enhance systems, processes and services.
• Produce high-quality technical documentation and contribute to maintaining the integrity and reliability of solutions.

Skills

ETL data warehousing

SQL

Kimball data modelling

Azure cloud BI

Microsoft SQL Server

Tools

SSMS

SSIS

Azure Data Factory

Power BI

Job description

Christchurch City Council is seeking a Software Engineer in the Business Intelligence team to deliver trusted information and analytics to Council. You will collaborate with BI experts to unlock insights from enterprise data, integration and cloud platforms.

You will join a large Digital Unit, contributing to data pipelines, reporting platforms, and documentation while working in Agile SCRUM environments across the organisation to support informed decision-making.