BI & Semantic Layer Lead

Experience

• 10+ years BI development
• 5+ years Power BI semantic modeling and DAX Studio 3.1.7 query plan flame graph optimization with VertiPaq Analyzer SE/FE ratio benchmarking;
• 2+ Tableau- or SSRS-to-Power BI migration delivered or assessed

Responsibilities

• Quantify report-to-model surface area compression ratios
• Own the report migration completeness assessment and identify migrated reports that still carry hidden dependencies on unmigrated legacy database objects.
• Interpret Tableau and SSRS inventory outputs from AI-assisted scans; validate migration completeness by comparing source Tableau workbooks and SSRS reports against the delivered Power BI reports; identify hidden business logic embedded in Tableau calculated fields and SSRS expression-based parameters that must be replicated in Power BI DAX Studio 3.1.7 query plan flame graph optimization with VertiPaq Analyzer SE/FE ratio benchmarking.
• Lead the self-service readiness assessment: field labeling and descriptions, hierarchy design, certified/promoted dataset status, SQL Analytics Endpoint availability, and drag-and-drop exploration capability for business users.
• Review Power BI workspace organization, access governance, scheduled refresh configuration, and deployment pipeline (Dev/Test/Prod) setup.
• Lead the cross-layer KPI consistency trace for priority business metrics — owning the DAX Studio 3.1.7 query plan flame graph optimization with VertiPaq Analyzer SE/FE ratio benchmarking and semantic model side, and coordinating with the Fabric architect on the stored-procedure and PySpark side — to document where the same metric is defined or calculated differently across layers. Skills & Tools
• Expert-level Power BI: semantic modeling, DAX Studio 3.1.7 query plan flame graph optimization with VertiPaq Analyzer SE/FE ratio benchmarking, report design, workspace administration.
• Hands-on Tableau Server: workbook structure, data source connections, calculated fields, usage analytics.
• Working knowledge of SSRS: report catalog, parameter handling, subscriptions, RDL structure.
• Solid understanding of legacy-to-Power BI migration patterns.
• UIKit