Blend360—Senior Power BI Migration Engineer (Tableau to Power BI)

Job description

Description: Blend is a premier AI services provider, committed to co-creating meaningful impact for its clients through the power of data science, AI, technology, and people. With a mission to fuel bold visions, Blend tackles significant challenges by seamlessly aligning human expertise with artificial intelligence. The company is dedicated to unlocking value and fostering innovation for its clients by harnessing world-class people and data-driven strategy. We believe that the power of people and AI can have a meaningful impact on your world, creating more fulfilling work and projects for our people and clients. For more information, visit www.blend360.com. 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. 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. 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 best—whether it's over lunch or during a laid-back session with peers, it's the perfect space to grow your skills. - Snack Zone: Stay fuelled and inspired! In our Snack Zone, you'll 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: We’re all about your growth groove! Level up your skills with our support as we cover the cost of your certifications.