Analytics Engineer

About The Role:

As an Analytics Engineer, you will be responsible for building robust, scalable analytics infrastructure to empower data-driven decision making. You will work closely with our data team and clients to understand their requirements, design robust data models/pipelines, and ensure data integrity and security, and create commercially sound outputs that deliver to the business needs.

You will be responsible for:

• Working closely with our clients to understand business needs and translate them into technical requirements


• Working with multiple data sources (APIs, databases, cloud platforms) to unify data into a centralised lakehouse or data warehouses


• Developing, testing and maintaining robust data pipelines used to integrate, transform and deliver data aligned to business requirements.


• Monitoring, troubleshooting and enhancing the performance and reliability of data pipelines and queries to align with best practices


• Implementing data quality checks and optimisations to validate the accuracy and reliability of data while constantly improving performance and scalability of pipelines


• Designing and implementing scalable data models used to support and inform decision-making.


• Detailing and maintaining clear, comprehensive documentation for data processes, models and flows


• Taking ownership of project management for assigned tasks, ensuring clear understanding of objectives, proactive communication, and the delivery of analytical and architectural solutions aligned with client needs.


• Delivering and presenting commercially focused outcomes that are actionable by our clients


• Perform analytics tasks, including data visualization, to translate complex data insights into clear and actionable outputs for stakeholders.


• Creating strategies for data integration and ensuring seamless integration of data across various platforms

What you will bring to this role:

• Strong SQL skills, particularly for data modelling, transformation and analysis


• Develop, debug, and optimise Python scripts for data manipulation and analysis, with proficiency in handling data structures (dictionaries, lists, Pandas) and leveraging PySpark/SparkSQL. Ensure adherence to Python coding standards (e.g., PEP 8) and implement efficient error handling and resource utilisation.


• Ability to set up Python environments, manage packages, and build unit tests to ensure robust, maintainable, and efficient code.


• Experience building and maintaining robust data pipelines in Python supported by tools such as Azure Data Factory and AWS Glue


• Familiarity with data warehouses and lakehouses like Snowflake, Databricks, & Fabric


• Experience with cloud platforms (e.g. AWS, Azure) is a plus


• Knowledge of best practices for data engineering, data quality and governance


• A strong desire to learn new tools and ways of working on the job


• Passionate about problem solving, great communication skills and ability to communicate effectively about your solutions


• Commercially minded and always focused on the ‘so what’


• Ability to work with clients and stakeholders on projects


• Ability to work in a fast-paced team environment and manage your own workload

Why join us?

• Opportunity to work with NZ’s leading data and analytics experts (perhaps we are biased!), across a range of clients and technical environments


• We combine the best of the fun agency culture while steering clear from the bureaucracy, if you are up for a change of pace and working with a friendly bunch of analysts, this is the place for you


• Flexible work hours and hybrid work options available


• Career and development opportunities


• To sweeten the deal, be part of an active and fun social club!


• See more about the benefits we offer and why our staff love us here: https://www.datainsight.co.nz/careers

About Data Insight: 
Established in 2013, Data Insight is not your average analytics agency. Over the past ten years, we've carved out a reputation as the go-to partner for countless businesses, helping them navigate their data journeys as trusted consultants and expert analysts. At Data Insight, we employ the best, with the skills and experience to meet all our clients analytics needs; from Data Strategy to AI, we've got all the bases covered.

Our impressive growth in the past 18 months speaks volumes about our team's dedication and the trust our clients place in us. We pride ourselves in the great work we do for our clients, and it’s our awesome team who have made that happen.

Want a sneak peek? Watch our story here: https://youtu.be/5Erfk0iNAtI

Please note:

• We will be reviewing CVs as they come along and start interviewing so please apply asap


• To be considered for this role, you must have NZ work rights and ideally be in NZ