Lead Data Consultant - Microsoft Fabric Analytics

Theta (NZ); Wellington; Hybrid; NZD 120,000 - 160,000; Full time

Benefits offered by this job

Flexible hours

Hybrid model

Medical insurance for employees

Parental leave

Job summary

Theta (NZ) invites an experienced Lead Analytics Engineer to join our Data and Insights Practice in Wellington. You will own analytics delivery end-to-end, partnering with clients to turn questions into trusted reporting and semantic models using Microsoft Fabric and the Azure Data Platform.

You will design semantic models, deliver fit-for-purpose analytics solutions, lead discovery sessions, and coach teams to adopt outputs with clear documentation and practical handover.

Qualifications

• 4+ years hands-on Power BI delivery and semantic model design.
• 4+ years client-facing consulting, including discovery and stakeholder workshops.
• 4+ years analytics data modelling and SQL, including dimensional modelling.
• 4+ years end-to-end analytics delivery ownership in a client-delivery environment.

Responsibilities

• Lead client discovery to define KPIs/metrics and reporting outcomes.
• Design semantic and analytics data models; build first iteration in Microsoft Fabric and Power BI.
• Deliver pragmatic, fit-for-purpose solutions with documentation and coaching.

Skills

Power BI delivery

Semantic model design

DAX development

Performance optimisation

Client-facing consulting

Discovery workshops

Analytics data modelling

SQL proficiency

Dimensional modelling

End-to-end analytics delivery

Tools

Microsoft Fabric

Azure Data Platform

Job description

About this role | Mô ténei türanga mahi

Theta is seeking an experienced Lead Analytics Engineer to join the Data and Insights Practice, based in our Wellington office. This is a priority hire within a team that values delivery excellence and a sustainable pace of work.

This role is centred on analytics outcomes: partnering with customers to turn business questions into trusted reporting, governed metrics, and high-quality semantic models. You'll work directly with client stakeholders and take end-to-end ownership of delivery, working independently where appropriate, and collaborating with solution architects and delivery teams when scale, assurance, or project context requires it, with delivery centred on Microsoft Fabric and the Azure Data Platform.

The objective is consistent, reliable implementation that enables measurable business outcomes through well-modelled data, clear definitions of truth, and analytics products that teams actually adopt.

In practice, you will:

• Lead client discovery to define KPIs/metrics ("definitions of truth") and reporting outcomes
• Design the semantic model and analytics data model, then build the first iteration yourself in Microsoft Fabric and Power BI
• Deliver pragmatic, fit-for-purpose solutions that teams adopt, and hand over with clear documentation and coaching

Please note:A cover letter accompanying your application is requested

Skills and experience | Ngā ēkenga me nŏbŏa hewako

Essential skills:

• 4+ years hands-on Power BI delivery, including semantic model design, complexDAXmeasure development, andperformance optimisation(model + report)
• 4+ years client-facing consulting experience, leadingdiscovery, facilitating stakeholder workshops, and translating ambiguous business questions into clear analytics scope and requirements
• 4+ years analytics data modelling and SQL, including dimensional modelling/star schemadesign and strong SQL capability for profiling, transformation, and building analytics-ready datasets
• 4+ years end-to-end analytics delivery ownershipin a consulting (or equivalent client-delivery) environment, taking work from requirements through build, validation, release, and handover/adoption, and documentation

Great to have:

• Microsoft Fabric depth beyond Power BI, e.g. Lakehouse/Warehouse, OneLake concepts, Delta tables, workspace/lakehouse organisation, Data Factory and/or dataflows, Fabric notebooks (PySpark where appropriate)
• Engineering-style delivery practices: Git-based development, CI/CD, automated testing (where appropriate), release management, monitoring/alerting, and environment management
• Data governance and security-by-design experience, including metric governance ("definitions of truth"), data quality practices, and row-level security / access patterns
• Production support and operational ownership, e.g. incident triage, root-cause analysis, performance troubleshooting, and improving reliability over time
• Relevant Microsoft certifications(or active progress towards them), especially in Power BI/Fabric/Azure data disciplines
• Mentoring / capability uplift, e.g. coaching analysts/engineers, establishing standards, peer review, and reusable delivery templates/assets
• Experience with AI coding assistants(e.g., GitHub Copilot or similar) used responsibly to accelerate delivery and improve consistency

About You

You bring analytics engineering depth and genuine comfort working directly with customers. You can run discovery, translate ambiguity into clear scope, and deliver trusted reporting and semantic models that stakeholders understand and adopt.

You care about high standards, maintainability, reliability, and clarity. Balanced with delivery timelines and commercial realities. You're collaborative, give and receive constructive feedback well, and enjoy mentoring others.

Applications are welcomed from experienced Analytics Engineers who want meaningful client interaction, ownership of outcomes, and the opportunity to shape how a growing practice delivers.

About us | Mô mātou

We have 31 years of experience as a New Zealand-owned technology consultancy. We take pride in our multicultural and diverse team of circa 280 skilled professionals. Our offices are in Auckland, Tauranga, Wellington, and Christchurch.

Working with clients in both the public and private sectors, we strive to deliver innovative solutions and enable smarter outcomes. Our company attracts some of the brightest minds in the industry, as we foster a culture of excellence and continuous learning.

Theta values are at the heart of everything we do:

• Our people are our greatest asset
• We conduct business ethically
• Invention, imagination and creativity are the foundation for growth
• We work with positive energy, enjoyment, humour and work/life balance
• Excellence is our passion, and we deliver what we promise - or more!
• We strive to take a pragmatic approach to all our activities
• We value and appreciate our natural environment and seek to play our part to maintain it

Benefits of working at Theta |Ngāhuaka putaitemahi ki Theta

Theta offers a family friendly work environment with flexible work hours where practical; especially relevant for caregivers. We embrace gender equality and are committed to providing a supportive,diverseand inclusive work environment.

Theta is committed to giving back to the community and are avid supporters of Cure Kids. We compete in various adventure races and do many other things to raise money for Cure Kids. And wemake timefor the fun things in life!

We currently provide the following benefits to ensure your professional development and personal wellbeing:

• Professional growth and learning opportunities
• A competitive salary (commensuratewith experience)
• Hybrid working model- from a minimum of 2 days in the office
• Fully subsidised medical insurance for employees
• Heavily discounted medical insurance for immediate family of employees
• Enhanced parental leave payment - salary top-ups plus return-to-work incentive
• Volunteer days
• Internal Referral Incentive
• Staff Assistance Programme
• Annual Flu injections
• Sick leave from your first day on board
• Remote working options where practical and mutually agreed
• Daily fresh fruit basket, coffee machine, wide selection of teas and biscuits inall ofour offices.
• We are also an accredited employer with INZ

Please note, all potential employees will be required to consent to aMinistry of Justiceand credit check.

We are only accepting applications from those alreadyresidingin NZ with the relevant visas.