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. 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.