Senior Data Engineer
Posted Updated
Description
H2R Technology is currently recruiting two Senior Data Engineers with hands-on Microsoft Fabric experience for 12-month contracts with a Wellington-based public sector organisation. The roles offer a competitive hourly rate and hybrid working in Wellington.
You’ll join a small B team delivering a migration from SAS to Microsoft Fabric. You’ll work alongside other data engineers, BI advisors and data scientists to rebuild pipelines in Fabric and design data marts that the Insights team can use for reporting and analysis.
What you’ll do
You’ll join a small B team delivering a migration from SAS to Microsoft Fabric. You’ll work alongside other data engineers, BI advisors and data scientists to rebuild pipelines in Fabric and design data marts that the Insights team can use for reporting and analysis.
What you’ll do
- Work with BI advisors and business stakeholders to understand how existing SAS workflows transform data and calculate reporting measures.
- Build, test and maintain ETL/ELT pipelines in Microsoft Fabric.
- Design dimensional models, including fact and dimension tables, for the new data marts.
- Reconcile Fabric outputs against existing SAS results, investigate discrepancies and validate the figures with the people who use them.
- Document transformation logic, data lineage and business rules so the team can maintain the pipelines after migration.
- Microsoft Fabric - Hands-on Fabric data engineering experience is required. You can explain what you’ve personally built and how you tested it.
- SQL and ETL/ELT - Strong SQL skills and experience building, testing and supporting production data pipelines.
- Dimensional modelling - Experience designing data marts, fact tables and dimension tables for reporting and analysis.
- Azure and Azure Data Factory (ADF) - Experience with Azure data services is preferred. ADF experience, particularly building, scheduling and monitoring pipelines, would be useful.
- Migration and data quality - Experience tracing transformation logic and reconciling data between platforms. Familiarity with SAS Enterprise Guide or SAS Viya would be nice to have.
- Stakeholder communication - Confidence working with technical and non-technical colleagues to clarify requirements, agree business rules and explain data issues in plain language.
Skills
Sign in to read and join the discussion.