Senior Power BI Migration Engineer (Tableau to Power BI)
Job Summary
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.
Qualifications :
Must Have:
- 5 years of hands-on experience in Power BI / enterprise BI analytics.
- Advanced Power BI expertise.
- Expert-level DAX and semantic/data modeling skills.
- Strong experience with Power Query/M and SQL.
- Strong experience with Microsoft Fabric.
- Hands-on experience with Databricks.
- Strong Python experience.
- Experience working with APIs particularly Power BI REST APIs and/or Tableau APIs.
- Strong understanding of Power BI performance optimization.
- Experience with Power BI Service workspaces security refresh deployment and governance.
- Experience with RLS/OLS.
- Experience with advanced Power BI development and enterprise-scale semantic models.
- Strong understanding of Tableau including dashboards calculations data sources and performance.
- Hands-on experience with Tableau to Power BI migration or similar BI platform migration.
- Excellent analytical problem-solving communication and stakeholder-management skills.
Additional Information :
Thrive & Grow with Us:
- Competitive Salary: Your skills and contributions are highly valued here and we make sure your salary reflects that rewarding you fairly for the knowledge and experience you bring to the table.
- Dynamic Career Growth: Our vibrant environment offers you the opportunity to grow rapidly providing the right tools mentorship and experiences to fast-track your career.
- Idea Tanks: Innovation lives here. Our Idea Tanks are your playground to pitch experiment and collaborate on ideas that can shape the future.
- Growth Chats: Dive into our casual Growth Chats where you can learn from the bestwhether its over lunch or during a laid-back session with peers its the perfect space to grow your skills.
- Snack Zone: Stay fuelled and inspired! In our Snack Zone youll find a variety of snacks to keep your energy high and ideas flowing.
- Recognition & Rewards: We believe great work deserves to be recognized. Expect regular Hive-Fives shoutouts and the chance to see your ideas come to life as part of our reward program.
- Fuel Your Growth Journey with Certifications: Were all about your growth groove! Level up your skills with our support as we cover the cost of your certifications.
Remote Work :
No
Employment Type :
Full-time
About Company
Blend360 is an award-winning provider of data, analytics, and talent solutions for Fortune 500 companies. The company has made the Inc. 5000 list of Fastest Growing Companies every year they have been in business and has been awarded a world-class ranking in client satisfaction for th ... View more