Business Intelligence Analyst I

The Planview BI Team is seeking an experienced Business Intelligence Analyst 1 to support, troubleshoot, optimise, 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. 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:

• 2-4 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, OLAP, 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.

Skills

Azure, Microsoft Fabric, Power BI, SQL Server, SSAS, SSRS, T-SQL