Data Engineer (690-668)

Summary about this job

Detail information about job Data Engineer (690-668). Terms and conditions vacancy

• At Z, we take a stand on what matters most - come and join us
• We're an Aon Hewitt 'Best Employer' - join the team
• Help us solve what matters for a moving world

We believe that if we want to be a world class Kiwi Company we shouldn’t just employ people, divide them into functional departments and tell them what to do. Instead we give them a reason for belonging, the possibility of a bigger purpose, and a hunger for the extraordinary.

In order to create a world class experience for our customers we need to gain a deeper understanding of the motivations and behaviors of our customers. That is why we are setting up a new customer analytics team, to provide customer reporting, analytics and insights. As Data Engineer you will be responsible for expanding and optimising our data to ensure insights for our analytics team.

In this role you will…

• Assemble large, complex data sets while ensuring agreed security standards are met by third party suppliers.
• Build analytics tools utilising data pipelines to provide actionable insights.
• Improving the accuracy of our data at source.
• Identify, design and implement process improvement.
• Develop standards and guidelines for data and data management.
• Work closely with the Data Manager to prioritise workloads and ensure that key data sets are being developed for Z which meet our target objective of being a World Class Kiwi company.

You will have…

• 5+ years of BI or data warehouse experience.
• Proven experience in dimensional modelling, preferable Kimball based.
• Strong understanding of the importance of data conformity, and a proven skillset in managing disparate data sources from across the enterprise.

• Proven experience in building relationships across business
• Proven skills in (preferably with certification):
  • SQL Server
    • Integration Services
    • Analysis Services
    • Reporting Services
    • Security and data management
  • Cloud Technologies and big data tools

Here at Z, we reckon everyone is a leader. Although you won’t have any direct reports, you are still expected to create what matters and inspire others to get after the most important things. And of course, you’ll be passionate about helping Z become a truly world-class Kiwi company.

Z is now New Zealand’s most preferred fuel brand. We are committed to diversity and inclusion and last year were named an Aon Hewitt best employer for the third year in a row. We have the Rainbow Tick and the YWCA Equal Pay Compact. This is a fabulous company to be part of, where the people work hard, learn lots and have fun. Have a look at the detailed job description below and if you believe you’re a strong ‘fit’ we’d love to hear from you. Applications close midday Wednesday 1 August 2018.

Required Skills: Position Description

Role title

Data Engineer

Business Unit
Reports to

FTR
Data Solutions Manager

Location
Career Level

Wellington
CL5

We believe that if we want to be a world class Kiwi company we shouldn’t just employ people, divide them into functional departments and tell them what to do. Instead we give them a reason for belonging, the possibility of a bigger purpose, and a hunger for the extraordinary. Having a career at Z means working with a company that is committed to your growth and personal development. We've got ambitions to be a world-class Kiwi company and we know it's our people who are going to get us there.

Z Why

At Z, we focus on achieving outcomes by setting the appropriate context, rather than trying to control people - we believe in "why" versus "way". In choosing to work for Z there are things you need to know, things you need to do and ways you need to be. Most of all you need to understand why. Before deciding to join us, please read the Z Why. If Z is a good match for your head and heart, come join us for one heck of a journey!

Role purpose

Z is on a journey to gain a deep understanding of customer behaviour and motivations and to deliver a world class customer experience. To achieve this we need to capture, manage and govern customer data at an enterprise level.

We are looking for a savvy Data Engineer to join our ICT team to expand and optimise our data, ensuring data is to provide insights to our analytics teams. Working closely with the Data Solutions Manager and Customer Data teams you will be optimizing data flows and collection for cross functional teams. The ideal candidate is experienced in understanding business needs and wrangling the data to optimise data systems and build them from the ground up. The Data Engineer will support our software developers, data architect, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.

This role will require someone with demonstrated experience with the principles of good data governance and strong technical knowledge of data strategies.

Role Dimensions

Number of Direct Reports
NIL

Key Relationships Internal
ICT. Marketing, Retail, Commercial

Key Relationships External
ICT Vendors and data specialists.

Role responsibilities

• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Accountable for the maintaining the data sets to meet our security and privacy policies.
• Working with third parties and suppliers to ensure data meets our agreed standards of accuracy and availability

Skills & Experience

Experience Required
4+ years of BI or datawarehouse experience

6+ years of ICT experience in a technical role

Proven experience in building relationships across ICT and Business units

Building data sets for analytics use

Qualifications Required
Degree in Computer Science, IT or Data

Or equivalent experience in a ICT or business role

Skills Required
SQLServer,

Cloud technologies (Azure preferred), Data Factory

SSAS, SSRS

MuleSoft or other integration technology

ETL

Experience with unstructured data

Experience with big data tools

Z’s Values

Z is a distinctive company. One of things that makes us Z is our values; they are the soul of our company and these are the things that make us so very Z!

Share Everything
We believe that so much more can be achieved if we are united. If we share our thoughts, our knowledge and our passion then we’ll all share the success.

Have the Passion
It is impossible to be the best unless you are absolutely passionate about what you are doing and you take ownership of it. We are and we do. Our business helps to keep the country running. Literally. And we intend to do it better than anyone and bring more benefits to the whole of New Zealand.

Be Bold
There’s no point being in this business to be just another energy company. We intend to be the best. We can only do that by taking the initiative, by challenging the status quo, by being bold and courageous, and by backing ourselves. So that’s exactly what we do.

Be Straight Up
As far as we’re concerned there’s only one way to do business, and that’s the New Zealand way. So we make it our mission to be honest, open, transparent and real.

We Back Our People
We back our employees to grow and succeed. We give back to the neighbourhoods we work in. We back our customers by knowing what they want and making it happen for them.

Z’s Stands Right now these are the areas where we stand for changing the game in New Zealand. We know we'll only be able to do this if we're all on the same page, so everyone at Z is expected to behave in a way which supports our commitments. You can read more about each of these in the Z Why.

HSSE
We take personal responsibility for making health, safety, security and the environment (HSSE) a vital part of our business.

Environmental Sustainability
To us, sustainability means acting in a way that benefits the future of the neighbourhoods we operate in and the planet we live on.

Community
We stand for making a positive difference where we live and operate in New Zealand.

Diversity & Inclusion
Z is committed to diversity & inclusion. We’re a company made up of a diverse mix of people which we believe makes for a more interesting and rewarding workplace, and better business results!

Z Leadership Competencies

Leadership Level: Leading Self

Make Things Happen

• Deliver what you say you will deliver
• Show confidence and respond positively to new priorities
• Be determined to make a contribution to Z and a difference for our customers, show tenacity and don’t give up
• Motivate and support colleagues in tough times
• Follow up on issues until they are resolved
• Hold yourself accountable: ‘no excuses’
• Make decisions and take action

Act as One Team

• Put what matters to your team and what’s important to our customers before personal goals
• Go out of your way to support and encourage others, even beyond your own team
• Positively support team decisions or initiatives
• Share your knowledge and expertise willingly
• Go the ‘extra mile’ for our customers
• Be patient when supporting others

Grow Capability

• Share knowledge and skills for the benefit of the team
• Respect and value the contribution of others
• Champion processes and procedures that focus on safety, operational integrity and customer experience
• Seek, accept and act upon feedback to improve performance
• Own mistakes and demonstrate learning
• Recognise personal strengths and development needs and work with both
• Share knowledge and customer insights for the benefit of the business

Inspire People

• Be committed, positive and passionate about your work
• Actively listen to our people and our customers, to understand what matters to them
• Communicate concisely, clearly and simply
• Role model the Z Why in all that you do
• Use initiative
• Show empathy; sharing your knowledge and supporting others

Create What Matters

• Speak up and challenge where you see issues, risks or inefficiencies
• Volunteer for projects or new initiatives
• Bring a solutions focus to all that you do
• Offer considered opinions and well-reasoned arguments for change
• Respond positively to change and new ways of working
• Build on and support the ideas of our people and our customers

Think Commercially

• Highlight opportunities for, and risks to the business
• Think about financial returns; suggesting ways to work more efficiently and effectively
• Know how we make money; making good choices and how we use company resources
• Prioritise activities, focusing on those that add the most value to our customers and to Z
• Demonstrate the customer matters in all you do
• Provide good value for money services

HSSE Leadership
You are the owner of ensuring your actions and the actions of others you interact with do not cause harm. You are personally responsible for your actions around safety and intervene in unsafe actions of those around you.

Make HSSE part of what you stand for by actively identifying and reporting hazards, incidents and near misses immediately. Read and understand the HSSE Stand, Zero Harm Pledge, the Z lifesaving Rules and our Golden Rules. Have knowledge of what your obligations may be under the law.