
Business Intelligence Analyst II
Planview · Posted 1 month ago
- Bengaluru, Karnataka, India (On-site)
- On-site
- Full-time
- 5+ yrs
About the role
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!
Skills
Quark9 guide
How to land this Business Intelligence Analyst II role
Our notes for applicants, based on how data and AI hiring usually works and on 12 similar open jobs on Quark9.
Resume checklist for this job
Most companies screen resumes with an ATS before a person reads them. Make sure each skill you genuinely have appears in your resume in the same words the job uses.
Must have
- Power BI
- DAX
- SQL Server
- T-SQL
- SSRS
- SSAS Tabular
- SSAS Multidimensional
- Microsoft Fabric
- OData
- Data Warehousing
- Lead each project with the business result (revenue, cost, time saved), then the method
- List the stack precisely: SQL dialect, Python libraries, BI tool, cloud platform
- Link a portfolio or GitHub with one or two well-documented projects
What interviewers expect: experienced
Interviewers want depth and judgement: trade-offs you made, people you guided and results across a team. Prepare two or three stories with clear impact.
How data and AI interviews usually run
- A screening call on your projects and the size of data you have worked with
- A SQL round, usually joins, window functions and aggregations on a sample schema
- A case or modelling round: frame a business problem, choose metrics, explain trade-offs
- A take-home or live exercise in Python, then a final round with the hiring manager
Questions worth preparing
- Write a query for the second-highest salary in each department.
- How would you measure whether a new feature improved retention?
- Explain overfitting to a non-technical stakeholder and how you guard against it.
- Walk through a project end to end: the question, the data, the method and the impact.
Every company runs its own process, so treat this as a likely shape, not a promise. Practise a mock interview on Quark9 and get scored feedback before the real one.
The market for Business Intelligence Analyst roles right now
- Most openings are in Bengaluru, Greater Hyderabad, Chennai, Noida, and 2 of the 11 we looked at offer remote work.
- The skills these jobs ask for most:
From open jobs on Quark9 matching “Business Intelligence Analyst”, updated every few minutes.
Similar jobs
- Data AnalystWebkit24 · India (Remote)
- Data Analyst Demand PlanningIFF · Greater Hyderabad Area (Remote)
- Data & Business Intelligence AnalystUPS · Chennai, Tamil Nadu, India (On-site)
- CSIRT Analyst_Security TechnicianFujitsu · Noida, Uttar Pradesh, India (Remote)
- Senior Business Intelligence AnalystWorkday · Atlanta