Senior Data Migration & Modelling Consultant - Technology & Transformation

About the Opportunity We’re looking for a Senior Data Migration & Modelling Consultant to support our client on an  engagement focused on reverse engineering legacy warehouse/analytics logic and producing high quality source-to-target mappings to enable migration onto a modern Microsoft data platform. This is a hands on role suited to someone who can move quickly, bring structure, and produce clear artefacts stakeholders can actually use. What you’ll be Doing

• Analyse legacy data warehouse / analytics platforms and reverse engineer data flows
• Interpret and document transformation logic, calculations, business rules
• Produce source-to-target mapping specifications and migration documentation
• Define data lineage/traceability and establish mapping/documentation standards
• Support design playback sessions and stakeholder validation of assumptions
• Contribute to refactoring/simplification of legacy warehouse patterns (including Data Vault where relevant)
• Use AI tools to accelerate discovery, while validating outputs and ensuring accuracy

What you’ll Bring

• Strong SQL and data analysis skills (able to inspect, validate and explain logic)
• Proven experience with dimensional modelling (Kimball): facts/dimensions, grain, conformed dimensions, surrogate keys
• Experience working with legacy warehouse patterns and complex transformations
• Familiarity with Microsoft data ecosystem (ideally including Microsoft Fabric and broader Azure data services)
• Understanding of Power BI semantic models / analytical layer concepts
• Comfortable working on-site, engaging confidently with both business + technical stakeholders

Next Steps? To keep things simple, we ask that all applications are submitted through this advert. We’ll review applications as they come in and be in touch. For any questions give Aata Kearns  a call on and quote Job ID: 18579 for a confidential chat. To apply for this vacancy, you MUST be a New Zealand citizen, resident, or have already secured the right to work in New Zealand and therefore hold a valid visa. At the appropriate stage we will request your references, we ask that you do not include them on your CV when applying.  Tribe is a group of specialist teams, each of who truly understand their world, and together they partner to understand yours. Whether you’re looking for your next opportunity or recruiting, we’re all about bringing people together for a shared purpose. Find your people.