Data Engineer/SQL Developer

Do you love wrangling complex datasets into something meaningful? Do you thrive on new challenges and working with a variety of different environments, datasets and industries?

We are seeking an experienced data engineer/SQL developer to join our team of data experts at Data Insight. The successful candidate will have the opportunity to work in an innovative, fast-paced environment, across a variety of projects and alongside a team of like-minded peers, helping our clients use data and analytics to solve complex business problems.

You will be responsible for:

  • Working collaboratively with our team of 20+ analysts, data scientists and data experts to deliver solutions for our clients
  • Working in a mix of technical environments, including our core internal environments; SQL Server on Microsoft operating systems and PostgreSQL on Linux
  • Developing SQL scripts to transform data into meaningful datasets and aggregations for analysis purposes
  • Working with analysts to design solutions to support data collection, storage and transformation for client projects
  • Analysis of business requirements, recommending solutions and estimating effort required
  • Receiving and loading data – and automating data load processes
  • Scripting primarily in SQL, Powershell, SSIS and bash
  • Interacting with peripheral tools and systems such as sFTP, APIs, cloud storage protocols and GIT
  • Data Loading, transformation, data quality checking and process improvement
  • Implementing technology and data best practices, guidelines and repeatable processes
  • Troubleshooting and issue resolution for existing processes
  • Keeping on top of new technologies and tools to ensure we’re always forward thinking and finding new and better solutions and ways to solve problems

Technical requirements:

  • Tertiary degree, Computer Science or related field, or ability to demonstrate equivalent experience and knowledge in the field
  • 3+ years experience in relevant data engineering roles, working on analytical projects
  • Proficiency in either the Microsoft/SQL Server environment or the Linux/PostgreSQL environment
  • Experience in data modelling and ETL

Personal attributes:

To be successful in this role you will need to be:

  • A motivated self-learner wanting to continuously upskill and tackle new challenges and can adapt to working in new environments
  • Able to work at a fast pace and manage your own workload and manage priorities to deliver to deadlines
  • Confident in talking to a variety of stakeholders from business users to technical staff
  • A great solutions-focused, problem solver
  • A desire to learn and keen interest in new and leading-edge technologies and tools

Why apply:

  • Opportunity to work with NZ’s leading data and analytics experts (perhaps we are biased!), across a range of clients and technical environments
  • Flexible work hours and work from home options negotiable
  • Career and development opportunities – lots of opportunity to learn new tools and technology
  • See more about the benefits we offer and why our staff love us here: https://www.datainsight.co.nz/were-hiring


This role is only open to candidates who already have the right to work in NZ and who are currently a resident in NZ.

If this sounds like the role for you, email your CV to info@datainsight.co.nz.