Business Intelligence Analyst II

About the role

The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products. This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models.

What you'll do

• Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS
• Perform advanced T-SQL development and performance tuning , including execution plans, indexing, query optimization, stored procedures, views, and complex queries
• Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security
• Support and troubleshoot SSAS Tabular and Multidimensional models , including processing, calculations, relationships, security, and performance
• Develop and troubleshoot advanced SSRS/paginated reports , including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats

What you need

• 5–9 yrs of experience
• Power BI
• SQL
• ETL
• Data warehousing
• DAX
• Power Query
• Any graduate

Good to have

• Data modelling
• SQL Server
• Root cause analysis