Senior Business Intelligence Analyst

Business Intelligence Analyst - 2

Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.

Job Summary:

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.

Key Responsibilities:

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

Required Skills & Qualifications:

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

The Power BI Intern will assist the analytics team in using Microsoft Power BI to create interactive dashboards and reports. Working with actual datasets to assist well-informed business decision-making, this position provides practical exposure to data analysis, visualization, and business intelligence techniques.

Job Summary

We are seeking a skilled and detail-oriented Power BI Developer to design, develop, and maintain enterprise-level BI solutions. The ideal candidate should have strong expertise in Power BI, DAX, SQL, Data Modeling, and performance optimization tools such as DAX Studio, Tabular Editor, and ALM Toolkit. The candidate will collaborate with business stakeholders to transform data into actionable insights and deliver high-quality dashboards and reports.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Create complex DAX measures, calculated columns, and calculated tables to meet business requirements.
• Develop and optimize SQL queries, stored procedures, views, and ETL processes.
• Design and implement scalable Star Schema and Snowflake Data Models.
• Perform report and model performance tuning using DAX Studio.
• Utilize Tabular Editor for model management, calculation groups, best practice analysis, and metadata enhancements.
• Manage model deployment, comparison, and version control using ALM Toolkit.
• Configure and manage Power BI Workspaces, Apps, Gateways, and Security (RLS/OLS).
• Work extensively with Power BI Service/Web Experience, including dataset refresh schedules, deployment pipelines, subscriptions, and workspace administration.
• Collaborate with business users to gather and analyze reporting requirements.
• Ensure data accuracy, governance, security, and report performance.
• Troubleshoot data-related issues and implement effective solutions.
• Create technical documentation and provide knowledge transfer to support teams.

Required Skills

Technical Skills

• Strong experience in Microsoft Power BI Development.
• Expertise in DAX (Data Analysis Expressions).
• Advanced knowledge of SQL Server/T-SQL and query optimization.
• Strong understanding of Data Modeling concepts (Star Schema, Snowflake Schema, Fact & Dimension Tables).
• Hands-on experience with Tabular Editor.
• Experience using DAX Studio for model and query performance tuning.
• Experience with ALM Toolkit for model comparison and deployment.
• Strong understanding of Power BI Service/Web Experience.
• Knowledge of Power Query (M Language).
• Experience with Row-Level Security (RLS) and data governance.
• Understanding of data warehousing and ETL concepts.

We’re looking for a dynamic and driven Data Analyst to join our team of technology enthusiasts. This role is crucial in transforming data into insights that support strategic decision-making and innovation within the insurance technology (InsurTech) space. If you’re passionate about working with data, understanding systems, and delivering value through analytics, we’d love to hear from you.

What We’re Looking For

• Proven experience working as a Data Analyst or in a similar analytical role
• 5+ Years of experience in the field
• Strong command of SQL for querying and manipulating relational databases
• Experience with Power BI for building impactful dashboards and reports
• Familiarity with QlikView and Qlik Sense is a plus
• Ability to communicate findings clearly to technical and non-technical stakeholders
• Knowledge of Python or R for data manipulation is nice to have
• Bachelor’s degree in Computer Science, Statistics, Mathematics, Economics, or a related field
• Understanding of the insurance industry or InsurTech is a strong advantage

What You’ll Be Doing:

• Delivering timely and insightful reports to support strategic decision-making
• Working extensively with Policy Administration System (PAS) data to uncover patterns and trends
• Ensuring data accuracy and consistency across reports and systems
• Collaborating with clients, underwriters, and brokers to translate business needs into data solutions
• Organizing and structuring datasets, contributing to data engineering workflows and pipelines
• Producing analytics to support business development and market strategy

We are looking for a detail-oriented and analytical Data Analyst to join our team. The ideal candidate will be responsible for collecting, analyzing, and interpreting data to identify trends, generate insights, and support business decision-making.

The candidate should be comfortable working with large datasets, creating reports and dashboards, and communicating findings clearly to business stakeholders.

Key Responsibilities

• Collect, clean, organize, and analyze data from multiple sources.
• Identify trends, patterns, anomalies, and business opportunities from data.
• Create dashboards, reports, and visualizations for business teams.
• Track and report key performance indicators (KPIs).
• Perform ad-hoc analysis to support business and management decisions.
• Develop and maintain automated reports where possible.
• Work with stakeholders to understand reporting and analytical requirements.
• Ensure data accuracy, consistency, and quality.
• Present analytical findings in a clear and actionable manner.
• Maintain documentation for reports, dashboards, and data processes.

About the Role

We are seeking an experienced Power BI Developer to design, develop, and maintain interactive dashboards and reports that drive data-informed decision-making across the business. The ideal candidate will have deep expertise in DAX, Power Query, data modeling, and enterprise data integration, along with strong communication skills to coordinate directly with clients, and the ability to mentor junior team members.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports
• Develop complex DAX measures, calculated columns, and KPIs
• Build and optimize data models using star and snowflake schema design
• Perform data transformation and cleansing using Power Query (M Language)
• Connect Power BI with enterprise data sources including SQL Server, Oracle, PostgreSQL, APIs, Excel, and SharePoint
• Optimize report performance and troubleshoot data/report issues
• Implement Row-Level Security (RLS) and manage Power BI Service workspaces
• Partner with business stakeholders and clients to gather and translate reporting requirements
• Mentor junior developers and contribute to overall BI solution architecture

Required Skills & Experience

• 3-4 years of hands-on Power BI development experience
• Strong proficiency in Power BI Desktop, Power BI Service, DAX, Power Query, SQL, and data modeling
• Experience with relational databases such as SQL Server, Oracle, or PostgreSQL
• Solid understanding of ETL processes and performance tuning
• Excellent analytical, communication, and problem-solving skills, with the ability to coordinate directly with clients and stakeholders
• Basic understanding of Object-Level Security (OLS) in Power BI (not mandatory, but working knowledge is a plus)
• Experience with Incremental Refresh (Incremental Load) and DAX optimization for large datasets
• Hands-on experience handling large datasets (4GB+) in Power BI/Power Query, along with performance and query optimization techniques
• Exposure to big data platforms such as Databricks
• Strong working knowledge of DAX queries and functions
• Familiarity with Power BI MCP Server and AI-driven features (e.g., Copilot in Power BI, natural language querying via MCP)

Preferred / Nice-to-Have Skills

• Experience with Microsoft Fabric
• Knowledge of Azure Data Factory, Azure Synapse, or Azure SQL
• Microsoft Power BI Certification

Eligibility Criteria

• Immediate joiners only — maximum notice period of 15 days
• Must be available to work the 4:00 PM – 11:40 PM IST shift
• Comfortable working in a 100% remote setup
• Excellent communication skills, as the role requires regular coordination with clients

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, 

About VerbaFlo.ai:

VerbaFlo.ai is a fast-growing AI SaaS startup revolutionizing how businesses leverage AI-powered solutions. As a part of our dynamic team, you’ll work alongside industry leaders and visionaries to drive innovation and execution across multiple functions.

Role Overview:

We are seeking a Senior Business Data Analyst with strong experience in analytics, SQL, and dashboarding (preferably Metabase) who can independently lead complex analytical initiatives, translate business problems into scalable data solutions, and mentor junior analysts. This role demands someone who can think strategically, operate with high ownership, and ensure the company runs on accurate, timely, and actionable insights.

Responsibilities:

Strategic & Cross-Functional Ownership

• Partner with leadership (Product, Ops, Growth, Finance) to translate business goals into analytical frameworks, KPIs, and measurable outcomes.
• Influence strategic decisions by providing data-driven recommendations, forecasting, and scenario modeling.
• Drive adoption of data-first practices across teams and proactively identify high-impact opportunity areas.

Analytics & Dashboarding

• Own end-to-end development of dashboards and analytics systems in Metabase (or similar BI tools).
• Build scalable KPI frameworks, business reports, and automated insights to support day-to-day and long-term decision-making.
• Ensure data availability, accuracy, and reliability across reporting layers.

Advanced Data Analysis

• Write, optimize, and review complex SQL queries for deep-dives, cohort analysis, funnel performance, and product/operations diagnostics.
• Conduct root-cause analysis, hypothesis testing, and generate actionable insights with clear recommendations.

Data Infrastructure Collaboration

• Work closely with engineering/data teams to define data requirements, improve data models, and support robust pipelines.
• Identify data quality issues, define fixes, and ensure consistency across systems and sources.

Leadership & Process Excellence

• Mentor junior analysts, review their work, and establish best practices across analytics.
• Standardize reporting processes, create documentation, and improve analytical efficiency.

Core Requirements:

• 5–8 years of experience as a Business Analyst, Data Analyst, Product Analyst, or similar role in a fast-paced environment.
• Strong proficiency in SQL, relational databases, and building scalable dashboards (Metabase preferred)
• Demonstrated experience in converting raw data into structured analysis, insights, and business recommendations.
• Strong understanding of product funnels, operational metrics, and business workflows.
• Ability to communicate complex analytical findings to both technical and non-technical stakeholders.
• Proven track record of independently driving cross-functional initiatives from problem definition to execution.
• Experience with Python, Git, or BI tools like Looker/Power BI/Tableau.
• Hands-on with data warehouses (BigQuery, Redshift, Snowflake).
• Familiarity with product analytics tools (Mixpanel, GA4, Amplitude).
• Exposure to forecasting, financial modeling, or experimentation (A/B testing).

Why Join Us?

• Work directly with top leadership in a high-impact role.
• Be part of an innovative and fast-growing AI startup.
• Opportunity to take ownership of key projects and drive efficiency.
• A collaborative, ambitious, and fast-paced work environment.
• Perks & Benefits: gym membership benefit, workation policy, and company-sponsored lunch.

If you’re looking for an exciting role that combines strategy, execution, and leadership exposure, we’d love to hear from you!

Apply now to join VerbaFlo.AI on this journey.

Strong Data Analyst Profile with advanced Excel and SQL expertise

2

Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst

3

Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots

4

Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts

5

Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)

6

Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy

7

Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)

8

Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.

9

Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person

10

Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts

About the Role

We are looking for an experienced Power BI Architect to lead enterprise-wide BI initiatives. This role will be responsible for designing, implementing, and governing scalable Power BI solutions across the organization. The ideal candidate will play a key role in establishing best practices, driving adoption, and owning the overall BI architecture within the Center of Excellence (CoE).

Key Responsibilities

• Lead end-to-end implementation of Power BI solutions across the enterprise
• Design scalable, secure, and high-performance BI architecture
• Act as the Power BI Architect, providing technical leadership and direction
• Own and drive BI governance, standards, and best practices within the CoE
• Collaborate with business and technology teams to translate requirements into robust BI solutions
• Define data modeling strategies, reporting frameworks, and dashboard standards
• Ensure data accuracy, consistency, and performance optimization across reports
• Support and guide development teams in Power BI implementation
• Enable enterprise-wide adoption of Power BI through training, documentation, and mentorship
• Work closely with IT/technology teams to integrate Power BI with data platforms and enterprise systems

Required Skills & Qualifications

• 10+ years of experience in BI/Data Analytics, with strong focus on Power BI
• Proven experience in enterprise-wide Power BI implementation
• Strong expertise in:
• Power BI (Desktop, Service, Gateway, Dataflows)
• Data Modeling (Star Schema, Snowflake Schema)
• DAX, Power Query (M language)
• Experience in designing and implementing BI architecture at scale
• Strong understanding of data warehousing concepts and ETL processes
• Experience working within a Center of Excellence (CoE) model
• Excellent stakeholder management and communication skills

Preferred Skills

• Experience with Azure (Azure Synapse, Data Factory, Data Lake)
• Knowledge of DevOps practices for Power BI (CI/CD pipelines)
• Exposure to governance tools and security frameworks
• Certification in Power BI / Microsoft Data Platform