Our client is a global payment and banking solutions provider serving financial institutions worldwide. We’re transforming their analytics landscape—migrating from legacy BI (WebFOCUS, Yellowbrick) to Microsoft Fabric + Azure Databricks.   

This is a high-visibility project building a state-of-the-art analytics platform that delivers fast, accurate insights at enterprise scale. You’ll be a key technical contributor, not just a ticket-solver.                                    

  What You’ll Do                                                                                                                                                                                                                                  

Migrate & Modernize:                                                                                                                                                                                                                            

Reverse-engineer legacy WebFOCUS reports, extract business logic, and rebuild them in Power BI using Microsoft Fabric + Databricks.                                                                                                             

Architect the Semantic Layer:                                                                                                                                                                                                                   

Design scalable Power BI Semantic Models using Direct Lake architecture as a single source of truth for business users.                                                                                                                         

Own Performance:                                                                                                                                                                                                                                

Optimize dashboards for 100+ concurrent users with complex data models (1,500+ columns, 800+ filters). Write efficient DAX, optimize SQL views in Databricks, and solve real-time reporting challenges.                                         

Build with UX:                                                                                                                                                                                                                                  

Partner with UX designers to transform wireframes into functional, high-performance dashboards.                                                                                                                                                 

Govern & Secure:                                                                                                                                                                                                                                

Implement Row-Level Security (RLS) and workspace governance for enterprise financial services compliance.                                                                                                                                       

What You Bring                                                                                                                                                                                                                                  

Must-Have                                                                                                                                                                                                                                       

• 5+ years Power BI with proven performance optimization expertise (model compression, Direct Query tuning, concurrent user scaling)                                                                                                            
•  Microsoft Fabric / Direct Lake hands on experience (ideally more than 1+ year)
•  Azure Databricks integration knowledge (medallion architecture, SQL optimization)                                                                                                                                                             
•  Large-scale performance optimization: 100+ concurrent users, complex data models                                                                                                                                                              
•  SQL mastery for query optimization in modern data warehouses                                                                                                                                                                                  
• English B2 and strong communication with technical stakeholders                                                                                                                                                                 
• Problem-solver: You fix root causes, not just apply patches. You’re a builder, not just a user.                                                                                                                                               

  Nice-to-Have                                                                                                                                                                                                                                    

•   Databricks Genie or AI-driven analytics                                                                                                                                                                                                       
•    PySpark/Python for data transformations                                                                                                                                                                                                       
•   Real-time/near-real-time reporting (fraud detection, payment processing)                                                                                                                                                                      
•    Enterprise financial services domain knowledge                                                                                                                                                                                                

  The Challenge                                                                                                                                                                                                                                   

  This isn’t typical BI work. You’ll solve:                                                                                                                                                                                                       

  – Massive complexity: 1,500+ columns/table, 800+ dynamic filters                                                                                                                                                                                

  – Performance at scale: Real-time reporting with 100+ concurrent users (scaling to 500+)                                                                                                                                                        

  – Modern architecture: Direct Query optimization (currently 40+ queries/dashboard), Direct Lake migration                                                                                                                                       

  – Legacy migration: WebFOCUS → Fabric while maintaining business logic                                                                                                                                                                          

  Tech Stack: Power BI, DAX, SQL, Microsoft Fabric, Azure Databricks, GIT