Senior Engineer, Enterprise BI & Analytics

OneMagnify; Chennai District; On-site; INR 1,500,000 - 2,800,000; Full time

Benefits offered by this job

Medical Insurance

PF

Gratuity

paid holidays

Job summary

OneMagnify in India seeks a hands-on data analytics lead to shape the data foundation for the company’s analytics transformation. You’ll own end-to-end Power BI dashboards, influence data architecture, and collaborate with Finance, Operations, Sales, and HR leadership to deliver AI-ready insights.

The role requires 5–7 years of BI experience, strong DAX/Power Query, SQL, and data modeling skills. You’ll work with multiple source systems (HubSpot CRM, ERP, Workday) to build scalable models and

Qualifications

• 5–7 years of BI/data analytics experience with hands-on Power BI.
• Strong DAX and Power Query skills to build end-to-end models.
• Solid data modeling fundamentals (star schema, grain) across multiple sources.
• Advanced Excel and reconciliation/variance analysis.
• Strong SQL and cloud data warehouse familiarity.

Responsibilities

• Own end-to-end Power BI dashboards for profitability, utilization, pipeline, and FP&A.
• Model data from CRM, project time-tracking, ERP, and resourcing into star schemas.
• Develop and optimize M pipelines and DAX measures.
• Diagnose model issues and ensure data governance and quality.
• Prepare reconciliations and variance analyses for leadership.
• Deliver well-documented, business-facing reports and templates.

Skills

Power BI

DAX

Power Query (M)

SQL

Excel

Data Modeling

EDW/Cloud DW

Tools

HubSpot

Workday

ERP systems

Job description

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.

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 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

• 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. Whether it’s awareness, advocacy, engagement, or efficacy, we move brands forward with work that delivers results. Through meaningful analytics, engaging communications and innovative technology solutions, we help clients tackle their most ambitious projects and overcome their biggest challenges.