Power BI Architect – Reports Migration Expert

Kumaran Systems; Chennai District; On-site; INR 3,500,000 - 6,000,000; Full time

Job summary

Kumaran Systems in India seeks a Power BI Architect to lead modernization and migration of legacy reporting platforms to Microsoft Power BI. Deep expertise in Power BI, DAX, Power Query, semantic modelling, SQL, and BI architecture is required, with emphasis on automation of report development and migration.

The role involves architecting scalable semantic models, defining migration standards, governance, and mentoring Power BI developers while leveraging APIs and automation tools.

Qualifications

• 10+ years in data engineering and enterprise reports with 2 migration projects to Power BI.
• Strong hands-on Power BI: Desktop, Service, Report Server, semantic models, DAX, and data modelling.
• Experience migrating reports from legacy platforms like SAP BO, Cognos, Tableau, SSRS.

Responsibilities

• Lead architecture and strategy for migrating legacy BI to Power BI.
• Analyze legacy reports, dashboards, datasets, queries, and security models.
• Define migration patterns and standards for converting reports to Power BI.
• Design scalable semantic models/datasets using star-schema principles.
• Establish enterprise standards for report development, naming, performance, and deployment.
• Design and implement automation frameworks for report creation and migration.
• Use Power BI REST APIs, XMLA, TOM, Tabular Editor, PowerShell, Python/.NET for automation.
• Provide technical leadership, architecture guidance, and mentoring to developers.

Skills

Power BI

DAX

Power Query

Data modelling

SQL

BI architecture

ETL

Tools

Tabular Editor

XMLA endpoints

PowerShell

Power BI REST APIs

Fabric APIs

.NET

Python

Job description

Job Title: Power BI Architect – Reports Migration Expert

Work Mode: Work from office

Interview: F2F (L2)

Job Description:

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 modelling, 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.
• Analyze 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, PowerShell, 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 Direct Query, 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