About the role
We're hiring a hands-on lead who lives in the data model. You'll be the primary developer behind our Power BI dashboards across the enterprise analytics scope — project profitability, resource utilization and capacity, client finance and pipeline, and FP&A.; You'll design star-schema models, write the DAX, build the Power Query pipelines that feed them, and perform the detailed reconciliation and variance analysis that keeps the numbers trustworthy.
This is a unique opportunity to help build the data foundation for a company-wide analytics transformation. Working closely with Finance, Operations, Sales, and HR leadership, your work will directly influence how the business measures performance, makes decisions, and evolves toward a modern, AI-ready data platform. As one of the key technical builders on a growing analytics team, you'll have significant influence over data architecture, modeling standards, and the future direction of our enterprise reporting environment.
What you’ll do
Own our Power BI dashboards end-to-end across project profitability, utilization/capacity,



pipeline/revenue, and FP&A; — maintaining and improving the data model, relationships, DAX measures, and report layout.
Integrate and model data from multiple source systems — CRM (HubSpot), project/time-tracking, finance/ERP, and resourcing (Workday) — into clean, consistent star schemas that hold up across teams, entities, and our regional subsidiaries.
Build and debug Power Query (M) pipelines with typed column transformations, anti-join patterns for current-record ingestion, normalization, and refresh logic.
Develop and troubleshoot DAX measures (margin and profitability, utilization rates, coverage ratios, YTD totals, weighted pipeline, budget-vs-actual variance) and diagnose model issues like relationship ambiguity, filter propagation, and grain mismatches.
Produce the recurring reconciliations and variance analyses leadership relies on — project forecast-vs-actual, utilization vs. p

📌 Lead Analytics Engineer Enterprise BI (Chennai)
🏢 OneMagnify
📍 Chennai