Senior Data Analyst

Job description

We’re on a mission to become the best specialist lending company in New Zealand and Australia, and we’re looking for ambitious, driven people to help get us there.

We’ve got bold goals and a clear vision for the future.

That means exciting opportunities for those ready to champion new ideas, challenge the status quo, and grow alongside us.

If you’re hungry to make an impact, thrive in a fast-paced environment, and love turning ideas into action – you’ll feel right at home here.

Reporting to the Data & Analytics Lead, the Senior Data Analyst designs, develops, and delivers data strategies and solutions that power decision-making across Avanti Finance.

You'll own the data warehouse environment—from sourcing and transformation through to integration, governance, and quality control.

Working closely with business stakeholders, IT, and external vendors, you'll build scalable, high-quality data solutions that support business performance, risk management, and regulatory compliance.

Responsibilities

• Lead requirements gathering and translate business needs into detailed technical specifications and scalable data solutions
• Design and support BI/visualisation solutions (Power BI, Tableau) that enable self-service reporting and deliver measurable commercial value
• Deliver fast, agile ad-hoc analysis using optimised coding techniques and clear data interpretation
• Design, develop, and maintain enterprise data models using dimensional modelling (star/snowflake schema) in cloud-based repositories (e.g., Snowflake)
• Build and optimise data marts and subject-area repositories for reporting, analytics, and performance
• Support Data Governance by maintaining centralised data dictionaries, metadata repositories, and ER diagrams
• Implement referential integrity, security, and access controls in line with governance, privacy, and regulatory requirements
• Apply strong analytical and problem-solving skills to troubleshoot data quality issues and optimise query performance
• Work within an agile squad framework alongside Data Engineering, Data Science, and Data Governance teams to deliver prioritised products

What we look for in the successful candidate

• High Proficien cy with BI/visualisation tools (Power BI, Tableau).
  
  In cluding workspaces, paginated reports, direct query, import , power automate and Dax.
  
  
• Strong experience in Python, Sql or R for analysis/automation.
  
  
• A strong understanding of all stages and tools associated to the Data pipeline.
  
  From Capture to Output / Archiving.
  
  Including database s (Oracle/ Sql Server ) , Integration platforms (Kafka, Fivetran ) and cloud based repositories (Snowflake).
  
  
• Experien ce in Cloud data warehouse design and modelling .
  
  Building of Data Marts through Kimball/star schema ’s .
  
  
• Exposure to cloud platforms (Azure/AWS/ GCP ) .
  
  
• Desirable knowledge of ETL/ELT procedures and tools (Coalesce/ dbt ).
  
  
• Experience with financial, risk, or compliance data preferred.
  
  
• Excellent communication skills, with the ability to explain data concepts to non-technical users.
  
  
• BSc in Computer Science, Engineering, Data Science, or equivalent.
  
  

We're reviewing applications as they come in - apply early to avoid missing out.

What's in it for me?

Within the Avanti Finance Group, you can look forward to flexible and hybrid working as we offer up to two days working from home following your initial training period.

We give back to our communities through our support of Duffy Books, and by offering an Annual Volunteer Day for you to use for a purpose that's close to your heart.

We believe in celebrating diversity, and we also celebrate talent and development by working with you through an established capability framework that puts you in the driving seat of your development while achieving business goals.

You won't find a gender pay gap here, as we have great remuneration packages but as we all know there's more to an awesome job than the money.If you are happy and fulfilling your potential, while feeling supported, valued and empowered, then that's a win for us! Fresh fruit, Healthy Food Guide Memberships, and increased Kiwisaver match is there for you to feel good from the inside out.

Even as we scale, our values remain our compass:

* People First : We care deeply – for our team, our customers, our partners, and our communities.

This is a place where you’re supported to show up as yourself and do your best work.

* Relentlessly Helpful : We roll up our sleeves and make things happen.

Whether it’s helping a customer, an introducer, a teammate, or your own career, we’re here to make the impossible possible.

* Do What’s Right : No shortcuts.

No ego.

Just doing the right thing, every time.

Trust and transparency are at the heart of how we do business.

We’re building a workplace where people are challenged, supported, and inspired to do their best work – because when our people thrive, so does our business.

At Avanti, you’ll be joining a team that’s as ambitious as it is grounded in purpose.

We’re not just growing fast – we’re growing to be the best.

Come be part of something that’s making a real difference.

Required Skill Profession

Database, Analytics & Bi