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

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

Location: Wakad, Pune

No of position: 1

Shift- 2PM to 11PM; (post 6pm can work from home when visiting office)

Mode of work: Hybrid (3 days from office)

Job Summary

We are looking for a skilled Power BI Developer with 3–5 years of experience in developing interactive dashboards, reports, and business intelligence solutions. The candidate should have strong expertise in Power BI, DAX, Power Query, data modeling, and SQL, with the ability to translate business requirements into actionable insights.

Key Responsibilities

• Design, develop, and maintain interactive dashboards and reports using Microsoft Power BI.
• Develop complex DAX measures, calculated columns, and KPIs to meet business reporting requirements.
• Perform data extraction, transformation, and loading using Power Query (M language).
• Design and optimize data models, including star and snowflake schemas and relationships.
• Write and optimize SQL queries to retrieve and validate data from relational databases.
• Configure Power BI Service workspaces, scheduled refreshes, gateways, and report access.
• Implement Row-Level Security (RLS) and appropriate data access controls.
• Optimize report performance, DAX calculations, and data models.
• Collaborate with business stakeholders, business analysts, and data engineering teams to understand reporting requirements.
• Perform data validation, troubleshoot reporting issues, and ensure data accuracy.
• Support report deployments, enhancements, and production issues.
• Maintain technical documentation and follow BI development best practices.

Required Technical Skills

• 3–5 years of hands-on experience in Power BI development.
• Strong proficiency in Power BI Desktop and Power BI Service.
• Good experience with DAX, including measures, filter context, and time intelligence.
• Strong knowledge of Power Query and M language.
• Experience in data modeling, relationships, calculated tables, and star schema design.
• Proficiency in SQL, including joins, subqueries, aggregations, and query optimization.
• Experience with report publishing, scheduled refreshes, gateways, and workspace management.
• Knowledge of Row-Level Security (RLS) and report performance optimization.
• Experience integrating data from SQL databases, Excel, and other business data sources.

Good to Have

• Exposure to Microsoft Fabric, Azure Data Services, or Azure SQL.
• Knowledge of ETL/ELT concepts and data warehouse fundamentals.
• Experience with Power BI deployment pipelines and version control.
• Familiarity with incremental refresh and large dataset optimization.
• Experience working in Agile/Scrum environments.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• Strong analytical, problem-solving, and communication skills.
• Ability to work independently and collaborate effectively with cross-functional teams.

Selection Criteria

Candidates should demonstrate practical experience in building Power BI reports, writing DAX measures, transforming data using Power Query, designing data models, and troubleshooting report performance issues.

NOTE: Technical rounds are mandatory to be taken F2F from Pune office on the same day.

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.

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

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.

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

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!

Hiring: Technical Project Manager / Risk Business Analyst

Location: Bangalore / Mumbai

Experience: 8–10 Years

Employment Type: Full-Time

Job Description:

We are looking for an experienced Technical Project Manager / Risk Business Analyst to manage the ORS roadmap, backlog prioritization, project delivery, and risk-related business requirements. The role involves collaborating with business, risk, trading, and technology teams, managing dependencies, tracking KPIs, preparing business cases, and presenting updates to senior stakeholders.

Must-Have Skills:

• Project Management
• Risk Management
• Business Analysis
• JIRA / JIRA Cloud
• SQL
• Roadmap Planning

Good-to-Have Skills:

Front-to-Back Risk, FRTB, Stress Testing, ETL Tools, Excel, PowerPoint, Dataiku, Big Data, Data Analytics, and Data Governance.

Role Overview

We are looking for an experienced Marketing Analytics Specialist to derive actionable commercial insights from Reckitt’s cross-channel e-commerce sales data. The role involves integrating data from multiple, inconsistently structured sources, developing scalable data pipelines and data models, creating business intelligence dashboards, and analyzing the impact of media platform spending on sales performance across various retailer platforms.

Key Responsibilities

• Commercial Analytics: Analyze cross-channel e-commerce sales data to identify trends, performance drivers, and actionable commercial insights.
• Business Requirements: Collaborate with business stakeholders to understand reporting requirements and translate them into analytical solutions.
• Data Architecture: Design and implement efficient data storage, retrieval, and processing architectures.
• ETL Development: Build and maintain robust, scalable ETL pipelines to integrate data from multiple source systems into data warehouses or other storage solutions.
• Data Modelling: Develop and maintain data models aligned with business reporting and analytical requirements.
• Data Quality: Implement data quality checks, validation, and reconciliation processes to ensure data accuracy, completeness, and consistency.
• BI Dashboards & Reporting: Design and develop interactive dashboards and reports that communicate business performance and insights effectively.
• Media Spend Analysis: Analyze the impact of media platform spending on sales performance across multiple retailer platforms and identify opportunities to improve marketing effectiveness.
• End-User Training: Provide training, documentation, and ongoing support to enable business users to use BI tools effectively.

Required Skills

• 5+ years of experience in Marketing Analytics, Data Analytics, Business Intelligence, or a related field.
• Strong SQL skills for data extraction, transformation, and analysis.
• Hands-on experience with ETL/ELT pipelines and data integration from multiple sources.
• Experience with data warehousing concepts and data modeling.
• Proficiency in Power BI, Tableau, or other BI visualization tools.
• Experience analyzing e-commerce sales, marketing performance, media spending, or retailer data.
• Knowledge of data quality, data validation, and reconciliation techniques.
• Strong analytical, problem-solving, and stakeholder communication skills.

Good to Have

• Experience in FMCG, retail, consumer goods, or e-commerce analytics.
• Understanding of digital marketing metrics such as ROI, ROAS, and campaign performance.
• Exposure to marketing attribution or Marketing Mix Modeling (MMM).
• Experience with cloud data warehouses such as Snowflake, BigQuery, Redshift, or Azure Synapse.
• Knowledge of Python or data transformation tools such as dbt.