Business Intelligence Analyst II

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. Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst - 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.

Responsibilities:

• Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behaviour, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.
• Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimisation, stored procedures, views, and complex queries.
• Support, develop, maintain, and optimise 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.
• Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.
• Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.
• Analyse and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.
• Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.
• Perform end-to-end root-cause analysis and performance optimisation across the BI technology stack.
• Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.
• Provide technical guidance and mentoring to BI Analyst 1 team members and contribute to BI best practices and documentation.

Requirements:

• 5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.
• Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modelling.
• Advanced knowledge of SQL Server and T-SQL, including query optimisation and performance tuning.
• Strong experience with SSRS and enterprise reporting.
• Experience with SSAS Tabular and/or Multidimensional models.
• Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.
• Experience working with OData and enterprise data integration.
• Strong understanding of data warehousing, Data Marts, ETL/ELT, and data modelling.
• Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.
• Strong analytical, troubleshooting, and root-cause analysis skills.
• Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.
• Experience with tools such as DAX Studio, Tabular Editor, Performance Analyser, Query Store, or SQL Profiler is an advantage.
• Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.