Business Intelligence Analyst II

Company Overview

Planview has one mission: to close the gap between strategic intent and business outcome, providing the intelligence organizations need to act decisively.

As the global leader in Strategic Portfolio Management, Planview helps organizations of all sizes achieve their business goals, faster and smarter. Our comprehensive platform bring initiatives, investments, and resources into a continuous, connected model of the business: the actionable understanding leaders need to move decisively, keep teams and AI in lockstep, and know how their initiatives are performing.—now powered by Planview Anvi, our next-generation enterprise AI that delivers expert guidance, intelligent recommendations, and actionable insights, turning complex data into decisive action from strategy through execution.

Recognized as a Leader in the 2026 Gartner Magic Quadrant for Strategic Portfolio Management for the fifth consecutive year, we proudly serve more than 3,000 customers globally, including 45% of the Fortune 100—and more than 3 million users worldwide.

Why Join Planview?

At Planview, our people’s connections drive our innovation and success. Our global team of 1,500+ employees work remotely and across offices in Austin, Vancouver, Hod HaSharon, Bangalore, Sydney, and Stockholm. We've built a world-class, connected culture rooted in shared values that empowers our teams to thrive and succeed from anywhere. When you join Planview, you're not just joining a company, you're joining a movement to transform how the world works.

Discover more about our portfolio at planview.com, and connect with us on LinkedIn, Instagram, and X.

The Opportunity

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

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, SQL Server, OData, and Data warehousing layers.
• 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.
• 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.
• Analyze 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 optimization 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.

What You'll Bring

• 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 modeling.
• Advanced knowledge of SQL Server and T-SQL, including query optimization 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, Datamarts, Automart, ETL/ELT, and data modeling.
• 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 Analyzer, Query Store, or SQL Profiler is an advantage.
• Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.

Benefits At Planview

At Planview, you’ll join our global team and culture which reflects the vibrant communities in which our employees live and work. To support you at Planview, you will enjoy:

• Unplugged Days: 4 company-wide paid days off per year to recharge and relax.
• Generous PTO offerings (region dependent).
• Region specific competitive benefit plans to support you at any life stage including parental leave, retirement, medical plans, wellness support, and remote work support.
• Paid time to volunteer through Planview’s Force for Good Week.
• Employee Referral bonus program.
• Weekly office lunches for hybrid team members and social events.
• Flexible work hours/environment.

Now is a great time to join our team. If you are looking for a place to grow your career, innovate with best-in-class solutions, and build the future of connected work, Planview is the right place for you!