Role Overview

Macnaught is building an AI-First Analytics Solution: a single, trusted analytics layer across Business Central (ERP), HubSpot (CRM), Shopify and Amazon (D2C/LNL), spanning operations, sales, and customer success data across Australia, NZ, the US, and India. This role is a key member of the team building that solution end to end: from modelling and transforming raw data into reliable business metrics, through to the semantic layer, and eventually the natural-language / AI-prompt layer that lets leaders and managers ask questions directly of the data.

This is a combined Analytics Engineer + Visualization Engineer role, and the person will be one of the core technical builders on this solution long-term, alongside an Analytics Architect and a Functional SME who bridges department context.

Significant: the AI-First Analytics Solution will take time to build. Until it is live, this person is directly responsible for keeping the business running on interim outputs: building and maintaining Power BI dashboards and, where a dashboard isn't yet practical, Excel-based reports,



for whichever business stakeholders need them. This interim delivery work is a core and ongoing part of the role.

Key Responsibilities
- Act as a key team member on Macnaught's AI-First Analytics Solution: help build the data extraction, transformation, semantic, and (eventually) AI-prompt layers as the solution is rolled out in phases.
- Until that solution is fully live, deliver interim outputs directly to business stakeholders: Power BI dashboards where practical, Excel-based reports where a dashboard isn't yet the right tool, so decisions don't wait on the longer-term build.
- Design and build data models that turn raw source data (Microsoft Business Central, HubSpot, Shopify, Amazon) into trusted business tables: brand-level P&L;, channel profitability, SKU-level margin, inventory ageing.
- Define and maintain metric logic in a semantic layer (e.g. contribution margin, inventory at

📌 Analytics Engineer (Gurugram)
🏢 Macnaught
📍 Gurugram