Lead Data Consultant - Microsoft Fabric Analytics Engineer

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 closely with client stakeholders, solution architects, and delivery teams, 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.

What the role delivers

• Lead discovery conversations and workshops to understand what customers truly need from their data, beyond the initial request
• Translate business questions into clear analytics deliverables: semantic models, measures, reporting requirements, and definitions of truth
• Design and deliver analytics solutions in Microsoft Fabric across Data Factory / dataflows, Lakehouses/warehouses, OneLake, and semantic models
• Develop and maintain transformation logic using SQL and Python (Fabric notebooks / PySpark where appropriate) to produce analytics-ready datasets
• Apply medallion architecture (bronze / silver / gold) patterns to deliver scalable, governed, reusable analytics products
• Model data for both the warehouse and semantic layer, applying star schema / dimensional modelling best practice
• Design and build Power BI reports and dashboards that are clear, performant, and answer the question asked (Power BI is a strong requirement)
• Build and maintain semantic models, including DAX measures, performance optimisation, and maintainable model design
• Surface insights customers didn’t ask for - trends, anomalies, opportunities - and explain them in plain language
• Document models, measures, pipelines, and metric definitions so customers can confidently maintain what we hand over
• Provide clear communication on progress, risks, dependencies, and blockers to stakeholders and delivery leadership
• Promote consistent delivery patterns across documentation, peer review, and analytics standards
• Mentor team members, supporting capability uplift and delivery confidence
• Contribute to Theta delivery assets including templates, reusable components, documentation, and continuous improvement initiatives

Please note: A cover letter accompanying your application is requested

Skills and experience | Ngā pūkenga me ngā wheako

• A minimum of 4+ years Power BI experience is essential
• 4+ Years experience within a consulting environment is required
• Significant experience delivering analytics solutions in enterprise environments, including stakeholder engagement, modelling, and production support considerations
• Excellent interpersonal skills essential
• Strong experience delivering with Microsoft Fabric (e.g., Power BI, Azure Data Factory / dataflows, Lakehouse/warehouse, OneLake, notebooks, Delta tables, workspace organisation)
• Strong data modelling capability for analytics workloads (dimensional modelling / star schema)
• Strong SQL capability for querying, profiling, transformation, and modelling
• Working proficiency in Python (including Fabric notebooks / PySpark where relevant)
• Strong experience building and maintaining semantic models and measures (including DAX)
• Strong experience producing Power BI reporting solutions that are performant and business-friendly
• Understanding of governed analytics delivery: data quality, definitions of truth, and security-by-design practices
• Delivery discipline: Git, CI/CD, testing, and monitoring practices appropriate to the engagement
• Strong stakeholder engagement and communication skills across technical and non-technical audiences
• Experience mentoring others and/or providing technical leadership in analytics delivery
• Relevant Microsoft certifications (or a commitment to ongoing professional development) are beneficial
• Experience using AI coding assistants, including GitHub Copilot or Claude coding agent

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 30 years of experience as a New Zealand-owned technology consultancy. We take pride in our multicultural and diverse team of circa 290 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ā hua ka puta i te mahi 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, diverse and 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 we make time for 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 (commensurate with 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 in all of our offices.
• We are also an accredited employer with INZ

Please note, all potential employees will be required to consent to a Ministry of Justice and credit check.

We are only accepting applications from those already residing in NZ with the relevant visas.

Apply now | Tono ināianei

Ready to take your career to the next level? We would love to hear from you!