Senior Data Engineer - (Australia Only)

About us

Pivot Analytics is the trusted data partner for CIOs and senior technology executives at billion-dollar companies. We act as their extended data team: we build their data capability, train their internal teams, take accountability for outcomes and form partnerships that run for years.

We punch well above our weight. Major retail and FMCG companies trust us with their most critical data initiatives, Snowflake has recognised us as an Emerging Partner, and we're on track to become the best Snowflake implementation partner in Australia.

Our stack

Snowflake, dbt, Terraform, AWS, Power BI, and AI coding tools including Cursor.

Our standards

We're a small, high-performing team with a tight culture and unrelenting standards. We expect excellence from ourselves and from each other, and we push hard to get there. If that sounds exhausting, this role isn't for you. If it sounds energising, keep reading.

We also move fast. Briefs are often incomplete, priorities shift, and the answer usually isn't written down anywhere. You'll be comfortable with ambiguity and able to work things out for yourself.

How we work with AI

AI sits at the centre of how we deliver. Every task starts with two questions: how do we do this again with AI, faster and more reliably, and how do we prove the output is right? You'll work on the latest tech with the latest tools, including Claude Code, every day, and you'll build the tests, checks and review habits that make AI-assisted work trustworthy at enterprise standard.

The opportunity

You have 3-5 years of data engineering experience and you've built and run production pipelines. You're ready to own technical delivery, work directly with senior client stakeholders and take on projects that matter to enterprise organisations.

• From day one: deliver on client engagements as a core member of the team, with real ownership of what you build
• As you demonstrate capability: take technical lead on projects, owning architecture decisions and the technical client relationship
• Longer term: lead major client engagements, mentor junior engineers and shape how we deliver Snowflake implementations

You'll work alongside our experienced technical architect, who will teach you how to build trusted, strategic data partnerships with C-level executives.

What you'll do

• Work directly with client teams, technical and business
• Train and mentor client data teams
• Own the success of the solutions we build together
• Build with medallion architecture, dbt, CI/CD and infrastructure as code in Terraform
• Use AI coding tools to deliver faster, and design the testing that proves the output is correct

What you need to bring

The foundations (non-negotiable):

• 3-5 years of hands-on data engineering experience
• Strong SQL: joins, CTEs, window functions, query optimisation
• Dimensional modelling: star schemas, slowly changing dimensions, and why these patterns matter
• Cloud data warehouse experience, Snowflake preferred
• Production dbt experience
• Terraform or another infrastructure-as-code tool
• Git: branching, pull requests, CI/CD
• A track record of holding yourself to a high standard and pushing yourself further
• The honesty to say "I don't know" and the ability to work it out quickly
• Full working rights in Australia

Bonus points:

• Snowflake certification or deep Snowflake knowledge
• Experience with medallion architecture patterns
• Productive daily use of AI coding assistants, and a clear method for validating what they produce
• Consulting, client-facing or technical mentoring experience

The people who thrive here

• Hold themselves to a high bar and enjoy being pushed
• Move fast and stay calm when things are unclear
• Work things out without waiting to be told
• Are technically strong and humble about what they don't know
• Can laugh at themselves and keep perspective
• Communicate clearly with everyone from data analysts to CIOs
• Take ownership and accountability seriously
• Enjoy teaching others and seeing them grow

Our hiring process

1. Cultural fit conversation: do we enjoy talking to you, and would we want to work with you every day?
2. Technical assessment: our stack and tools, including how you use AI coding tools and how you test what they produce

We want solid foundations, high standards and honesty about what you know and what you don't.

Why Pivot Analytics

• Work on the latest tech with the latest tools, including Claude Code
• Work with billion-dollar clients on their most important data initiatives
• Learn from an experienced technical architect in a team that sets a high bar
• Clear path from engineer to technical lead to client engagement leader
• Help build Australia's best Snowflake implementation partner
• Fully remote, Australia-based
• Small team where your work directly shapes our growth
• Competitive salary and professional development