BI Lead-Semantic Layer

BI Lead-Semantic Layer Dallas, TX

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