Data & Analytics Engineer — Microsoft Fabric
About Umbrellar
Umbrellar Technology Group is a New Zealand–owned cloud company with a history stretching back close to three decades. For more than 20 years we have implemented and managed our customers’ infrastructure, datacentres and cloud environments.
Our ambition is simple: to be New Zealand’s most respected cloud company giving our customers honest, insightful guidance, world-class support, and the engineering expertise to trust us with what matters most.
Our Growing Data Practice
Our Data practice is growing fast. We deliver practical, outcome-focused data and analytics solutions built on Microsoft Fabric turning raw, scattered data into insight our customers trust to run their business.
Our approach is deliberately pragmatic real business outcomes over hype, governed foundations customers can build on, and data quality, security and governance designed in from day one. Solutions are built inside each customer’s own environment, working with their data, so trust is never traded off against speed.
As a key engineer in the practice, you’ll help shape how we build, the standards we set, and the delivery patterns we take to market with the backing of an established, profitable cloud business behind you.
Growing the Team
We’re investing and growing. This role is part of a deliberate expansion of our data engineering capability as demand for trusted data and analytics accelerates across New Zealand and beyond. You’ll join a team where you own what you build, work directly with clients, and have genuine influence over the direction of a growing practice the kind of scope that’s rare in an established business and rarer still on the ground floor of one.
About the Role
We’re looking for a Fabric Engineer who can build the data platform and turn it into insight customers trust and who is as comfortable in front of a customer as they are in front of the pipeline. This is a client-facing engineering role: you’ll sit down with customers to understand their data and reporting needs, then design and build the pipelines, models, and reports that answer their real business questions.
Microsoft Fabric is the platform this role lives on. You’ll work across the full stack, ingesting and transforming data through Fabric Data Factory pipelines and notebooks, shaping lakehouses and warehouses on OneLake, and building the semantic models and Power BI reports on top. You’ll partner with our architecture team on platform foundations, but you’ll own real engineering from ingestion through to the report a customer opens every morning.
We care about both the engineering and the customer conversation. The strongest candidates bring genuine data engineering depth alongside the ability to translate a business question into a data model and explain the answer in plain language.
The Role in Practice
The sections below describe what the role delivers, the technology it depends on, and the additional experience that strengthens an application.
Working with Customers
• Running discovery conversations and workshops to understand what customers actually need from their data, not just what they’ve asked for
• Translating business questions into data models, pipelines, measures, and reporting requirements
• Presenting findings and solutions back to business stakeholders in plain language, from operations staff through to executives
• Building trusted relationships through multi-month engagements, becoming the person customers call about their data
• Helping customers build confidence in their own numbers, including data quality and definitions of truth
Building on Microsoft Fabric
• Designing and building end-to-end data solutions in Microsoft Fabric — Data Factory pipelines, dataflows, lakehouses, warehouses, and OneLake
• Developing and maintaining ETL/ELT pipelines and transformation logic using SQL and Python (PySpark / Fabric notebooks)
• Implementing medallion (bronze / silver / gold) architecture patterns to deliver scalable, governed, reusable data platforms
• Modelling data for both the warehouse and the semantic layer, applying star-schema and dimensional design
• Building reusable assets, patterns, and standards that speed up delivery across engagements
Reporting and Insights
• Designing and building Power BI reports and dashboards that are clear, performant, and answer the question asked
• Building and maintaining semantic models in Microsoft Fabric, including DAX measures and star-schema design
• Finding the insights customers didn’t ask for trends, anomalies, and opportunities hiding in their data
• Documenting models, pipelines, and measures so customers can maintain what we hand over
Engineering Practices
• Working to modern engineering disciplines source control (Git), CI/CD deployment, testing, and monitoring
• Building data quality, security, and governance into every solution, in line with Microsoft Purview and best-practice standards
• Managing workspace and OneLake organisation, security, and access across environments
Core Technology Stack
• Microsoft Fabric Data Factory pipelines, lakehouses, warehouses, notebooks, OneLake, Delta tables, and workspace organisation. This is a must
• Data pipeline engineering — ETL/ELT design, data transformation, and medallion architecture
• Strong SQL for querying, profiling, transforming, and modelling data
• Python and PySpark for data preparation, transformation, and analysis in Fabric notebooks
• Power BI report design, DAX, and semantic data modelling
• Azure data services — Azure Data Factory, ADLS, and Synapse
• Data governance and security — Microsoft Purview and secure-by-design practices
• Excel at an advanced level, because customers still live in it
Nice to Have
• Databricks and deeper Apache Spark / PySpark internals
• Kafka, streaming, or real-time data processing
• dbt for transformation and modelling
• Data science fundamentals — statistics, forecasting, and experimentation
• Microsoft certifications such as DP-700 (Fabric Data Engineer), DP-600 (Fabric Analytics Engineer), or PL-300 (Power BI Data Analyst)
• Prior experience in a consulting or professional services environment
Personal Attributes and Values
• Excellent written, verbal, and presentation communication skills.
• Strong stakeholder management, able to influence, motivate, and build trust at all levels.
• Highly organised, with strong attention to detail and the ability to prioritise across multiple concurrent projects.
• Resilient and adaptable.
• Committed to personal development and developing others.
• Self-motivation, initiative and drive.
• Willingness to share knowledge and contribute to a “continuous learning” environment.
• A commitment to the customer experience.
Why Join Us
We offer a people-first culture with a strong emphasis on personal and professional development. Our benefits include:
• 10 days bonus leave on top of your 20 days annual leave.
• Car park or subsidised public transport.
• Medical and life insurance for peace of mind.
• A modern, fun office environment in Takapuna.
• A supportive and flexible team culture with real work-life balance.
Employment Criteria
To be eligible for this role, you must:
• Be Auckland based.
• Be a New Zealand citizen or resident, currently based in New Zealand.
• Hold a current NZ Driver’s Licence.
• Be able to pass a Ministry of Justice background check.