Power BI Architect

Kumaran; Chennai District; On-site; INR 2,500,000 - 5,000,000; Full time

Job summary

Kumaran Systems is seeking a highly experienced Power BI Architect to lead the modernization and migration of legacy reporting platforms to Microsoft Power BI. The role requires deep expertise in Power BI components, data modeling, and automation, with a track record of migrating from SAP BusinessObjects, Cognos, and similar platforms.

You will define migration patterns, build scalable semantic models, and establish governance for enterprise BI deployments, while mentoring a team of Power BI

Qualifications

• 10+ years of experience in data engineering and enterprise reporting.
• Experience migrating reports from legacy platforms like SAP BO, Cognos, or Tableau is highly desirable.

Responsibilities

• Lead the architecture and technical strategy for migrating legacy BI to Power BI.
• Analyse existing legacy reports, dashboards, datasets, queries, and security models.
• Define migration patterns and standards for converting legacy reports into Power BI reports.
• Design scalable Power BI semantic models/datasets using star-schema and dimensional modelling.
• Establish enterprise standards for Power BI report development, naming conventions, performance, and deployment.
• Design frameworks to automate Power BI report creation and migration wherever feasible.
• Evaluate Power BI REST APIs, Fabric APIs, XMLA endpoints, TOM, Tabular Editor, PowerShell, Python and/or .NET for automation.
• Define automated report comparison and validation frameworks for parity with legacy reports.
• Provide technical leadership and mentoring to Power BI developers.

Skills

Power BI

Power BI Service

DAX

Power Query

semantic modeling

SQL

data visualization

BI architecture

automation

APIs

XMLA

Tabular Editor

PowerShell

Python

.NET

Tools

Power BI Desktop

Power BI Service

Power BI Report Server

REST APIs

XMLA endpoints

Tabular Object Model

Tabular Editor

Power Shell

Python

.NET

Job description

Kumaran Systems: Engineering Future-Ready Transformations Since 1992, Kumaran Systems has been helping enterprises bridge the past and the future, reimagining legacy systems and embracing AI-led possibilities. With over 34 years of delivery excellence, we specialise in re-engineering core applications, driving cloud transformation, and building automation-first, GenAI-enabled ecosystems across the Banking and Financial Services, Insurance, Telecom, and Automotive sectors. We help organisations not just upgrade their systems but reimagine what’s possible.

Why Kumaran?

We blend engineering discipline with AI innovation, helping clients modernise with confidence, automate with clarity, and scale with purpose. Our global delivery model ensures agility, responsiveness, and seamless collaboration, with clients always at the heart of every engagement. At Kumaran, we don’t just solve problems, we engineer future-ready transformations.

Job Description

Power BI Architect – Reports Migration Expert

We are looking for a highly experienced Power BI Architect to lead the modernization and migration of legacy reporting platforms to Microsoft Power BI .

The ideal candidate should have deep expertise in Power BI , Power BI Service, DAX, Power Query, semantic modeling, SQL, data visualization, and BI architecture, combined with strong experience in automating repetitive report-development and migration activities

• Lead the architecture and technical strategy for migrating legacy BI /reporting platforms to Power BI .
• Analyse existing legacy reports, dashboards, datasets, queries, calculations, filters, prompts, security models, and dependencies.
• Define migration patterns and standards for converting legacy reports into Power BI reports.
• Design scalable Power BI semantic models/datasets using appropriate star-schema and dimensional modeling principles.
• Establish enterprise standards for Power BI report development, modeling, visualization, naming conventions, performance, and deployment.
• Design and implement frameworks to automate Power BI report creation and migration wherever technically feasible.
• Evaluate and leverage Power BI REST APIs, Power BI /Fabric APIs, XMLA endpoints, Tabular Object Model (TOM), Tabular Editor, Power Shell, Python and/or .NET for automation.
• Define automated report comparison and validation frameworks to ensure migrated reports produce results equivalent to legacy reports.
• Provide technical leadership, architecture guidance, and mentoring to Power BI developers.

Required Technical Skills

• 10+ years of experience in Data engineering domain & enterprise reports building with at least 2 projects experience in migration from legacy reporting technologies to Power BI .
• The candidate should have very strong hands-on Power BI expertise, including Power BI Desktop, Power BI Service, Power BI Report Server, Power BI semantic models/datasets, DAX – advanced/expert level, Power Query / M, Data modelling, Star schema / dimensional modelling, Composite models, Import and DirectQuery, Incremental refresh, Aggregations, Calculation groups, Row-Level Security (RLS), Object-Level Security (OLS), Drill-through, Bookmarks, Dynamic measures, Field parameters, Dynamic titles and visualization, Custom visuals, Power BI performance optimization, Deployment pipelines, Workspaces and governance
• Experience migrating reports from one or more legacy platforms is highly desirable, for example SAP BusinessObjects, IBM Cognos, MicroStrategy, Tableau, Qlik, SSRS, Crystal Reports, Oracle BI / OBIEE

Kumaran Systems is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.