Power BI DAX Tech Lead

Job Title BI Tech Lead Power BI

Experience 10-15 Years

Mandatory Skills

Strong handson experience with Power BI DAX Performance Analyzer semanticmodel design

Advanced expertise in DAX Power Query and Data Modeling

Strong SQL development and query optimization skills

Azure Analysis Services Tabular modeling VertiPaq capacityQPU analysis

SQL Server views SPs indexingquery tuning ETLmaterialization design

Experience building interactive dashboards reports and scorecards

split across report remediation and visual redesign

Knowledge of Power BI Security RowLevel Security RLS Gateways and Deployment Processes

Experience in Power BI performance tuning and optimization

DAXrelationship optimization

SQL Server viewSPtoflattenedtable refactoring workstreams

Secondary Skills

working familiarity with Databricks

Experience gathering business requirements and translating them into reporting solutions

Knowledge of data pipelines and dataset management

Report enhancement defect resolution and change management

Production support and troubleshooting of reporting issues

Documentation of technical specifications and knowledge repositories

User training knowledge transfer and adoption support

Experience conducting workshops discovery sessions and solution demos

Soft Skills

Excellent verbal and written communication skills

Strong stakeholder management and client facing skills

Ability to engage with senior business leaders and executives

Strong presentation and facilitation skills

Analytical and problem solving mindset

Ability to manage multiple priorities in a client environment

Self driven and capable of working independently onsite

3 Qualifying Questions

Can you describe a Power BI solution you developed end to end including data modeling DAX calculations and performance optimization techniques used

How have you implemented Row Level Security RLS Gateway configuration and deployment strategies in Power BI environments

Provide an example where you worked directly with business stakeholders to gather requirements and translate them into a dashboard report that drove business decisions