Data Engineer (12-Month FTEC)

About the company

ClearPoint has spent more than 19 years partnering with organisations through complex digital change. Their work blends software engineering, AI, data and insights, cloud capability, and human-centred design to deliver durable outcomes.

The business supports some of New Zealand’s most influential organisations and places strong emphasis on quality. Its Auckland head office looks over the Viaduct, about five minutes from Britomart, and team members can also use co-working spaces across New Zealand and Australia. ClearPoint operates across New Zealand, Australia, and the UK with a focus on creating value for clients, teams, and the wider community.

Culture

ClearPoint describes its environment as collaborative, inquisitive, and high performing. Its core values are respect and care for people, acting with integrity, and building trust in a lasting way. The team is made up of motivated people who take responsibility for their work, aim high, and enjoy what they do. The company also supports growth for staff based in Auckland, Wellington, and Christchurch.

Role overview

ClearPoint is seeking a mid-level full-stack data engineer for a 12-month fixed-term engagement within a key client setting. This is an active delivery role, not a passive support position. You will own end-to-end delivery across data domains, work inside an established platform, and contribute in a fast-paced, visible environment.

You will be closely embedded with the client’s internal team, expected to work transparently and to deliver against defined patterns with consistency and care.

Key responsibilities

• Take ownership of end-to-end delivery for 2 to 3 defined data domains across the Bronze, Silver, Gold, and Reporting layers of the medallion model.
• Create, expand, and support ETL/ELT pipelines using Fivetran and dbt, following agreed specifications and established ways of working.
• Operate within a Terraform-based framework for schema change deployment, making confident adjustments and escalating when needed.
• Bring REST and SaaS APIs into the Bronze layer by following existing documentation and implementation patterns within the current CI/CD process.
• Work closely with the team through daily stand-ups, pull request reviews, and regular syncs, while keeping communication clear and timely around progress and blockers.

Required experience and skills

• Practical working knowledge of Snowflake and a sound understanding of medallion or lakehouse architecture.
• Advanced SQL capability.
• Strong understanding of star and snowflake schemas, plus how medallion layering works.
• Hands-on experience with Fivetran and dbt, including building pipelines from specifications and extending existing models.
• Comfort using Git and CI/CD pipelines within established workflows.
• A collaborative, delivery-focused mindset with comfort in ambiguity and high-visibility work.
• Ability to execute within existing frameworks rather than trying to redesign them.

Nice to have

• Python scripting skills for reading or lightly adjusting existing scripts and simple pipelines.
• Basic familiarity with modern BI tools and creating polished Gold-layer outputs for presentation use.

What’s on offer

• Interesting, complex work that provides technical challenge and meaningful impact.
• Competitive pay, health insurance, a subsidised gym, barista coffee, wellness workshops, and other benefits.
• Flexible and remote working, with trust placed in you to deliver from where you work best.
• An annual training budget plus access to learning resources from AWS, Google Cloud, Microsoft, and Salesforce.
• BYOD and phone allowances, along with access to the technology needed to do strong work.
• An award-winning workplace, including recognition as AWS Social Impact Partner of the Year and a CIO 50 Award recipient.

Additional information

This role is based in Auckland and described as hybrid, with flexible/remote working available. It is a fixed-term position for 12 months.

Applicants should be eligible to work in New Zealand. ClearPoint is an equal opportunity employer committed to an inclusive hiring environment.

The company may use AI tools during parts of the hiring process to assist with application review, resume analysis, or response assessment, but final hiring decisions are made by people.

To be considered, candidates should send a CV and a brief introduction to the hiring team.

• Own delivery for multiple defined data domains from source to reporting across the full medallion stack.
• Develop and support Fivetran and dbt pipelines based on existing requirements and implementation standards.
• Make schema deployment changes within a Terraform-led release process and escalate issues when appropriate.
• Integrate external REST and SaaS APIs into the Bronze layer using current patterns and CI/CD practices.
• Stay engaged in team ceremonies, reviews, and status updates while communicating progress and blockers early.

• Working knowledge of Snowflake and medallion/lakehouse architecture.
• Advanced SQL skills.
• Solid understanding of star and snowflake data models.
• Hands-on experience with Fivetran and dbt.
• Experience working in Git and CI/CD environments.
• Ability to operate independently within a structured delivery setup.
• Comfort working in a client-facing, high-visibility environment.

• Competitive remuneration.
• Health insurance.
• Subsidised gym membership.
• Barista coffee and wellness workshops.
• Flexible or remote work options.
• Annual training budget.
• Access to AWS, Google Cloud, Microsoft, and Salesforce learning materials.
• BYOD allowance and phone allowance.
• Access to the technology required to perform well.
• Recognition as an award-winning employer.

Applicants must be legally eligible to work in New Zealand.nullSnowflakeSQLData ModelingETL/ELT Pipeline DevelopmentdbtFivetranGitCI/CDTerraformAPI IntegrationMedallion ArchitecturePython ScriptingBusiness Intelligence Toolstruenullnullnull