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, 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 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
Skills Required
- 10+ years of experience in data engineering and enterprise report development
- Experience with at least two projects involving migration from legacy reporting technologies to Power BI
- Expert hands-on experience with Power BI Desktop, Power BI Service, Power BI Report Server, and Power BI semantic models or datasets
- Advanced or expert-level DAX expertise
- Experience with Power Query/M, data modeling, star schema, dimensional modeling, composite models, Import, DirectQuery, incremental refresh, and aggregations
- Experience with calculation groups, row-level security, object-level security, drill-through, bookmarks, dynamic measures, field parameters, dynamic titles, custom visuals, and visualization
- Experience with Power BI performance optimization, deployment pipelines, workspaces, and governance
- Experience automating report creation and migration using Power BI APIs, XMLA, TOM, Tabular Editor, PowerShell, Python, or .NET
- Experience migrating reports from legacy platforms such as SAP BusinessObjects, IBM Cognos, MicroStrategy, Tableau, Qlik, SSRS, Crystal Reports, or Oracle BI/OBIEE
What We Do
Kumaran Systems is an IT Services Company with imprints in three countries. The past two decades has seen us provide our global clientele with high-end IT services that include migration support, system integration and infrastructure management solutions, providing one-stop-solution to all your IT demands. Our expertise and in-depth knowledge of businesses help us cater to a variety of industries. Our team strives to know your industry better, by observing current trends and the way it works, to tailor-make our solutions to your needs.With over 20 years of customer orientation, over 2000 engagements across Telecom, Education and Banking & Financial services spread across the globe, Kumaran stands as a key advisor to some of the largest Fortune 500 companies in their business driven technology enablement drive. Kumaran System's Customer Orientation is driven by a global delivery business model giving its customers to choose between an Onshore-Offshore mix. The delivery models enable multilevel touch points between the client, partner networks and Kumaran thereby enabling business driven customer sensitivity and agility. ENGAGE, EMERGE AND EXCEL Involving ourselves in a purposeful action, using our abilities to its maximum, helps us feel positive about ourselves. Such positivity gives raise to positive thinking and positive ideas. Ideas evolve into vision and set our aim! Our aspirations engage us with the incentive of sweet success! Every endeavor has its own pitfalls. Perseverance helps us emerge a successful entrepreneur after any deterrent. In our attempt to achieve our aim, we keep upgrading our knowledge and skill, to surface successful! A genius mind does not work to excel, but excels in work! We challenge ourselves with every next step! We change every deterrent to a stepping stone to success. We essentially, engage, emerge and excel
