Data Modeler

Great flexible working options
- Contribute to Fidelity Life's new data streaming platform
- Join a supportive inspiring team

**The Opportunity**:
We currently have an exciting opportunity for a Data Modeller to join the Data Engineering team building Data Solutions. This is a permanent role based in our Auckland CBD office with flexible working arrangements.

Central to the development is the implementation of a new data streaming platform - an Azure hosted Confluent Cloud implementation of Apache Kafka. Data from multiple policy administration systems will be ingested to the data platform, which is being developed to conform to a common data model. Downstream there are integrations with a Microsoft Dynamics based General Ledger.

Some key accountabilities include.
- Mapping data from various source systems to a common destination data model
- Providing data transformation logic to the development team of the vendor
- Incorporating changes to data transformation logic as suggested by the business and operations teams
- Holding discussions with the operations teams to obtain missing data
- Ensuring that data from spreadsheets can be easily ingested into target system on an ongoing basis
- Data validation against source systems and requirement documents
- Supporting development and test teams to resolve any issues with the output data
- Providing regular feedback on achievements, risks, and issues

**About you**:
With 5 years plus proven experience, you’ll bring a strong understanding of data modelling. You will be a natural collaborator, and relish the opportunity collaborate and contribute.

You’ll thrive within a collaborative, dynamic working environment, enjoy building strong internal and external relationships with key stakeholders. You’ll be a great communicator (both written and verbal), have exceptional organisational skills and bring an agile mindset.

Together with this you will bring:

- SQL Proficiency (Query building + data transformation).
- Excellent communication skills.
- Strong technical knowledge in data manipulation.
- Advanced Excel skills - pivots, formulas, lookups.
- High attention to detail
- Insurance experience is ideal, but not essential.
- KSQL and Kafka experience desirable.

**About Us**:
At Fidelity Life, we’re super proud to be New Zealand’s largest locally owned and operated life insurer. Our people are connected by our purpose to give New Zealanders certainty to live a more rewarding life; and by our aspiration to reimagine life insurance so we can protect even more New Zealanders.

We’re bringing our purpose and aspiration to life through an exciting customer led transformation. It’s easy to talk that talk, but we’re already walking the walk - building new data / insights and digital capabilities to unlock a deep understanding of our customers, and provide innovative solutions and experiences that meet their needs.

We also know our future success requires us to step up and help New Zealand meet some big challenges - like responding to climate change and achieving better outcomes for communities who are being left behind.

So taking our lead from what our customers, people, partners, shareholders and the wider community expect of us, we’re exploring ways to be more community and environment aware, ensuring we contribute to a sustainable future for all New Zealanders.

In short, we have big aspirations and a big plan to deliver them - and we’re looking for people like you to help make it happen.