Software Engineer (Data Engineer)

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

E ngā iwi, e ngā karangatanga huri noa i te motu, tēnei te mihi atu ki a koutou katoa. He īnoi tēnei ki a koe. Tono mai ki tētahi tūnga ki te Kaunihera o Ōtautahi

E ngā iwi, e ngā karangatanga huri noa i te motu, tēnei te mihi atu ki a koutou katoa. He īnoi tēnei ki a koe. Tono mai ki tētahi tūnga ki te Kaunihera o Ōtautahi When you join the Christchurch City Council, you'll be getting involved working to shape the future of this city, our communities and environment. As well as working with awesome people within the organisation, you'll have an opportunity to develop your professional skills and make the city an even better place to live, work, and play.

About the role | Ko te mahi nei

As a Software Engineer in the Business Intelligence team, you will work alongside other Business Intelligence experts to deliver trusted information and analytics to Council.

You will enjoy working with a broad mix of enterprise data, integration, analytics, and cloud platforms, helping make the most of the organisation's data assets.

This role works within our large and diverse Digital Unit and collaborates across the various Council business units.

Day To Day, You Will

• 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.

About you | Ko Koe Tēnei

To Be Successful In This Position You Will

• Identify opportunities for innovation and continuous improvement working within an agile methodology
• Have experience in enterprise data warehousing ETL using the Microsoft stack (SSMS, SSIS), SQL and Kimball data modelling techniques
• Bring your existing experience, or grow your capability, in cloud BI solutions using Azure services such as 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

What's in it for you? He aha ngā hua ki a koe?

Want To Be Involved In Shaping Your City? Here At The Council We Know Our Strength Comes From Our People, Working Together As One Team To Create Results. When You Join Us, You're Getting Involved First Hand, And Contributing To Crafting The Christchurch Community. You Will Also Benefit From

• Access to training programmes, workshops, and development opportunities
• Flexible working arrangements - WFH, adjustable start and finish times, option to purchase extra leave.
• Collaboration - exposure to wider areas of the organisation
• Benefits - a variety of benefits for Council staff from health schemes to retail discounts.

Additional Information | Ko ētahi atu kōrero:

At the Christchurch City Council, we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with the job description,

We understand that recruitment processes can be challenging.

• Hours of work - Full Time
• Position - Permanent
• Location - This position is primarily based at Te Hononga, Christchurch City Council Civic Offices
• Salary - The salary band for this position goes from $99,122 to $110,136 per annum based on a 40 hour week. Starting salaries will be based on knowledge, skills and experience the successful candidate brings to the role, and relativities both, within the immediate team and in the broader organisation for the same or similar roles.
• Closing Date - 12 November 11:55PM

Applications will be reviewed as they are received, and interviews may take place prior to the close date. This means we reserve the right to close a job ad before the advertised close date.