Senior Power BI Migration Engineer

Job Description

We are looking for a highly skilled Senior Power BI Migration Engineer to support an enterprise-scale Tableau to Power BI migration initiative.

The role will be primarily focused on Power BI (approximately 70%), with Tableau (approximately 25%) involvement. The ideal candidate will have deep hands-on expertise in Power BI, advanced DAX, data modeling, Microsoft Fabric, Python, Databricks, APIs, and performance optimization, along with strong working knowledge of Tableau.

You will be responsible for analyzing existing Tableau dashboards, reports, calculations, data sources, and business logic and translating them into scalable, high-performance Power BI solutions. The role requires someone who can independently troubleshoot complex BI challenges, make technical decisions, and establish migration and development best practices.

Key Responsibilities

1. Tableau to Power BI Migration

• Analyze existing Tableau dashboards, workbooks, data sources, calculations, filters, parameters, LOD expressions, and business logic.
• Design and implement equivalent or improved solutions in Power BI.
• Translate Tableau calculations, LOD expressions, table calculations, parameters, and sets into appropriate Power BI/DAX implementations.
• Assess Tableau dashboards and determine the appropriate Power BI architecture and visualization approach.
• Identify gaps or functional differences between Tableau and Power BI and develop suitable solutions.
• Perform migration validation, including data accuracy, calculations, filters, visualizations, performance, and business functionality.
• Support migration of enterprise-scale Tableau reporting environments to Power BI.
• Help establish reusable migration patterns, frameworks, standards, and best practices.

2. Power BI Design & Development

• Design and develop enterprise-grade Power BI reports and semantic models.
• Build scalable star-schema data models and implement advanced DAX.
• Develop complex DAX solutions including:
  • Time intelligence
  • Calculation groups
  • Field parameters
  • Dynamic formatting
  • Complex measures and business calculations
• Develop intuitive dashboards with strong UX, drill-through, bookmarks, tooltips, and custom visuals.
• Use Power Query/M and SQL for data preparation and transformation.
• Select appropriate Power BI storage modes including Import, DirectQuery, and Composite models.
• Develop solutions that meet requirements for scalability, performance, security, and maintainability.

3. Microsoft Fabric & Data Engineering

• Develop and support Power BI solutions leveraging Microsoft Fabric.
• Work with Fabric components including:
  • OneLake
  • Lakehouse
  • Warehouse
  • Data Pipelines
  • Dataflows Gen2
  • Notebooks
  • Direct Lake
• Integrate Power BI with Databricks and other enterprise data platforms.
• Work with Python/PySpark for data preparation, automation, and analytics use cases.
• Collaborate with data engineering teams to optimize upstream data structures for BI consumption.
• Understand Fabric capacity, workspace architecture, Git integration, and deployment practices.

4. Performance Optimization

• Diagnose and resolve performance issues across Power BI reports and semantic models.
• Optimize DAX, data models, queries, relationships, calculations, and visualizations.
• Use tools such as:
  • DAX Studio
  • Tabular Editor
  • VertiPaq Analyzer
  • Power BI Performance Analyzer
• Implement incremental refresh, aggregations, partitioning, and appropriate storage strategies.
• Optimize migrated reports to ensure performance is equal to or better than the legacy Tableau implementation.

5. APIs & Automation

• Develop automation using Power BI REST APIs and/or PowerShell.
• Work with Tableau REST/Metadata APIs where required during the migration.
• Use Python for automation, migration support, data processing, or API integrations.
• Automate repetitive deployment, validation, reporting, or administrative activities where appropriate.
• Experience with Power BI Embedded and paginated reports is desirable.

6. Security, Governance & Administration

• Implement Power BI security including Row-Level Security (RLS) and Object-Level Security (OLS).
• Establish appropriate workspace and access-control strategies.
• Manage Power BI Service capabilities including:
  • Workspaces
  • Apps
  • Gateways
  • Scheduled refresh
  • Deployment pipelines
  • Sensitivity labels
  • Lineage
  • Endorsement
• Support Power BI development standards, governance, and lifecycle management.
• Work with PBIP/TMDL, source control, and deployment processes where applicable.

7. Tableau Responsibilities

• Work with existing Tableau environments to understand the architecture and business logic being migrated.
• Review Tableau Desktop workbooks, dashboards, data sources, calculations, and extracts.
• Understand advanced Tableau concepts including:
  • LOD expressions
  • Table calculations
  • Parameters
  • Set actions
  • Relationships/joins/blends
  • Hyper extracts
• Support Tableau Server/Tableau Cloud analysis during migration.
• Understand Tableau performance optimization and security concepts.
• Use Tableau REST/Metadata APIs or related tools when required for migration activities.

8. Technical Leadership & Stakeholder Management

• Act as a technical SME for Power BI migration initiatives.
• Provide technical guidance to BI developers and data teams.
• Review Power BI solutions and migrated dashboards for quality, performance, and adherence to standards.
• Troubleshoot complex migration and reporting issues.
• Work closely with business stakeholders to understand existing Tableau functionality and translate requirements into Power BI solutions.
• Communicate technical concepts clearly to both technical and non-technical stakeholders.
• Mentor developers and contribute to BI development standards and best practices.