Lead Data Consultant - Microsoft Fabric Analytics

Role Overview

The Lead Data Consultant position at Theta is a key role within the Data and Insights Practice based in Auckland. This role prioritizes delivering sustainable, high-quality analytics centered on Microsoft Fabric and the Azure Data Platform. The consultant will engage directly with clients to translate complex business questions into well-structured reporting and trusted, governed metrics supported by semantic data models.

Key Responsibilities

• Lead customer engagements to define key performance indicators and clear reporting objectives.
• Architect semantic and analytics data models and implement initial builds using Microsoft Fabric and Power BI.
• Deliver pragmatic solutions that are easily adopted by teams, ensuring smooth handover accompanied by detailed documentation and coaching.

Required Skills and Experience

• Over four years of hands-on experience delivering Power BI projects including semantic model creation, complex DAX calculations, and performance enhancements for both models and reports.
• At least four years of direct consulting experience involving client collaboration, stakeholder facilitation, and translating vague business questions into precise analytics requirements.
• Proficient in analytics data modeling and SQL with more than four years focusing on dimensional/star schema design and dataset transformation for analytics readiness.
• Demonstrated ability to independently manage end-to-end analytics delivery in consulting or similar client-facing roles, covering all stages from requirements to adoption and documentation.

Preferred Qualifications

• Deep experience with Microsoft Fabric components beyond Power BI, including Lakehouse/Warehouse, Delta tables, OneLake, and workspace organization.
• Familiarity with engineering delivery practices such as Git, CI/CD pipelines, automated testing, release management, and monitoring.
• Practical knowledge of data governance including metric governance, data quality, row-level security, and access control patterns.
• Experience supporting production environments with incident management, root cause analysis, and system reliability improvements.
• Relevant Microsoft certifications or active pursuit particularly in Power BI, Fabric, and Azure data technologies.
• Strong mentoring capabilities, including coaching, standards establishment, peer review, and reusable asset development.
• Experience responsibly leveraging AI-assisted coding tools to improve development efficiency and consistency.

Candidate Profile

The successful candidate demonstrates proficiency in analytics engineering, excels in client communication to clearly define scope and deliverables, and produces maintainable, reliable analytics outputs with balanced pragmatism for business realities. Collaboration and mentoring are key traits valued in this role.

Company Background

Theta is a New Zealand-owned technology consultancy with over three decades of history and a diverse team of approximately 280 employees. Operating across major NZ cities and partnering with public and private sectors, the company emphasizes innovation, ethical conduct, and a culture of excellence and continuous learning.

Core Values

• People first – recognizing them as the greatest asset.
• Ethical business practices.
• Innovation and creativity as growth foundations.
• Positive work environment promoting enjoyment and work/life balance.
• Commitment to excellence and delivering beyond expectations.
• Pragmatic approaches to challenges.
• Respect for and protection of the natural environment.

Employee Benefits

• Family-friendly flexible working hours catering to caregivers.
• Commitment to gender equality and fostering a diverse and inclusive workplace.
• Support for community initiatives including fundraising for Cure Kids.
• Professional development programs.
• Competitive salary aligned with experience.
• Hybrid working model requiring at least two days in office.
• Fully subsidised employee medical insurance and heavily discounted coverage for immediate family.
• Enhanced parental leave with salary top-ups and return-to-work incentives.
• Volunteering days and internal referral bonuses.
• Staff assistance programs and annual flu vaccinations.
• Immediate sick leave entitlement from day one.
• Remote work options subject to practicality and agreement.
• Workplace amenities including fresh fruit, coffee, and snacks.
• Accredited employer status with immigration authorities.

Additional Information

All candidates must provide consent for a Ministry of Justice and credit check. Applications are only accepted from individuals currently residing in New Zealand with appropriate visas.