Senior Data Analyst

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.

As a Senior Data Analyst, you can expect to:

• 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 Proficiency with BI/visualisation tools(Power BI, Tableau). Including 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 databases (Oracle/Sql Server), Integration platforms (Kafka, Fivetran) and cloud based repositories (Snowflake).
  
• Experience in Cloud data warehouse designand 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, My Everyday Wellbeing Memberships, and increased Kiwisaver match is there for you to feel good from the inside out.