•Design, develop, test, deploy, and maintain interactive Power BI dashboards and reports.
•Gathering and documenting requirements with business requestors (KPIs, filters, security, refresh needs)
•Designing and building Power BI reports and dashboards
•Building and modifying semantic models: star-schema modeling, DAX measures, calculation groups, row-level security (RLS)
•Data preparation in Fabric: Lakehouse and Warehouse tables, Dataflows Gen2, Data Pipelines and notebooks (PySpark/SQL) as needed for a report
•Power Query (M) transformations and connections through approved on-premises data gateways
•Performance tuning of existing reports and models (Performance Analyzer, DAX Studio, VertiPaq Analyzer)
•Enhancements and defect fixes on existing team-owned reports
•Report documentation, data dictionaries and end-user handoff notes
•Gather and analyze business requirements and translate them into effective reporting and analytics solutions.
•Develop complex calculations, KPIs, and business logic using DAX.
•Build efficient data transformation and cleansing processes using Power Query and M language.
•Design dimensional data models using star schema and snowflake schema concepts.
•Create calculated columns, measures, drill-through reports, bookmarks, tooltips, and intuitive report navigation.
•Optimize Power BI reports, semantic models, DAX queries, and datasets for performance and usability.
•Develop and troubleshoot complex SQL queries, stored procedures, views, and data transformations.
•Provide production support, root-cause analysis, and timely resolution of reporting issues.
Required Technical Skills
•5+ years building enterprise Power BI reports and semantic models
•Advanced DAX and data modeling (star schema, RLS, calculation groups, composite models)
•Power Query (M) and SQL (T-SQL and Fabric Warehouse / SQL endpoint)
•Hands-on Microsoft Fabric: Lakehouse, Warehouse, Dataflows Gen2, Data Pipelines, notebooks
•Performance tuning with DAX Studio, Tabular Editor and VertiPaq Analyzer
•Direct experience gathering requirements with business stakeholders
Performance and Optimization Experience
•Identify and resolve slow-performing reports and visuals.
•Optimize complex DAX measures and data-model relationships.
•Reduce unnecessary model size and high-cardinality columns.
•Understand relationship direction, filter propagation, and query behavior.
•Select appropriate Import, DirectQuery, or composite-model approaches.
•Optimize report visuals, SQL queries, semantic models, and refresh performance.
