OneMagnify is an AI native, platform-enabled B2B digital agency operating at the intersection of data, technology, and creativity. We help complex organizations drive measurable business outcomes by building smarter customer experiences and delivering highly integrated solutions across digital, media, and technology. By combining deep industry expertise with advanced analytics and artificial intelligence, we enable our clients to make better decisions, move faster, and compete more effectively in dynamic markets.
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.
The Impact You'll Have:
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 new-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. plan, and week-over-week pipeline snapshot comparisons.
- Audit source-data quality across systems — flagging date problems, owner gaps, duplicates, and misclassified records before they reach a dashboard — and help strengthen our data governance and data-management standards.
- Build clean, well-documented deliverables (multi-tab workbooks, reusable templates) and make the results clear to business partners and US-based leadership.
What You'll Need:
- 5-7 years in data analysis or BI development with significant hands-on Power BI work.
- Strong, demonstrable skills in DAX and Power Query (M) — able to build a model from raw exports to finished dashboard independently.
- Solid data modeling fundamentals (star schema, fact vs. dimension tables, grain), including combining data from several source systems.
- Advanced Excel and comfort with reconciliation/variance work.
- Strong attention to detail and the ability to explain technical results to non-technical stakeholders.
- Strong SQL and working familiarity with cloud data warehouses and ELT tooling.
Future-Ready Skills (Nice to Have):
- Python (pandas) for data matching and reconciliation.
- Experience with project profitability, utilization/capacity, or professional-services finance data.
- CRM (especially HubSpot), project/time-tracking, and finance/ERP data experience (Workday).
- Experience reporting across multiple entities or business units.
- Experience working in an AI-enabled environment, including using AI tools in day-to-day analytics/BI work.
- Experience in integrated marketing, digital agency, marketing services, or consulting environments preferred.
Benefits
We offer a comprehensive benefits package including Medical Insurance, PF, Gratuity, paid holidays, and more.
We are an equal opportunity employer
We believe that Innovative ideas and solutions start with unique perspectives. That’s why we’re committed to providing every employee a workplace that’s free of discrimination and intolerance. We’re proud to be an equal opportunity employer and actively search for like-minded people to join our team.
