SQL Developer

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.

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.

🚨 Hiring: MicroStrategy Developer

We are looking for an experienced MicroStrategy Developer for a 6-month contract opportunity.

📌 Role: MicroStrategy Developer

💼 Experience: 5+ Years

📍 Location: Bangalore / Hyderabad / Mumbai / Delhi

🏢 Work Mode: Onsite

📅 Contract: 6 Months

Key Requirements:

• 5+ years of hands-on MicroStrategy experience

• Strong experience in MicroStrategy development

• Strong SQL skills

• Experience in BI reporting and dashboard development

• Experience with data warehousing and analytics

• Ability to understand business requirements and develop reporting solutions

• Experience in troubleshooting and supporting MicroStrategy applications

Interested candidates can apply with their updated resume.

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.

Title: Tableau Developer

Experience: 5+ Years

Location: Remote

Employment Type: Full-Time

Notice period: Immediate Joiner

Role Overview

We are looking for an experienced Tableau Developer with strong expertise in Tableau dashboard development and exposure to Tableau Next. The ideal candidate should have hands-on experience designing interactive dashboards, developing data visualizations, optimizing reports, and translating business requirements into actionable insights. Experience with Tableau Next and modern analytics capabilities is essential for this role.

Key Responsibilities

• Design, develop, and maintain interactive dashboards, reports, and visualizations using Tableau.
• Work with business stakeholders to understand reporting requirements and translate them into effective BI solutions.
• Develop complex calculated fields, parameters, filters, sets, table calculations, and Level of Detail (LOD) expressions.
• Connect and integrate data from multiple sources, including databases, data warehouses, and cloud platforms.
• Write and optimize SQL queries to support reporting and analytical requirements.
• Develop, maintain, and troubleshoot Tableau workbooks, published data sources, extracts, and refresh schedules.
• Optimize dashboard performance, data retrieval, and visualization usability.
• Work with Tableau Next capabilities to support modern analytics workflows and business intelligence use cases.
• Support data preparation, data modeling, and data quality validation.

• Collaborate with cross-functional teams to deliver reliable and scalable analytics solutions.
• Provide documentation, end-user training, and ongoing dashboard support.

Required Skills

• Overall 5+ years of hands-on Tableau development experience.
• At least 6+ months of hands-on experience with Tableau Next.
• Strong proficiency in Tableau Desktop and dashboard development.
• Advanced knowledge of Tableau calculations, LOD expressions, parameters, filters, and table calculations.
• Strong SQL skills, including joins, subqueries, aggregations, and query optimization.
• Experience with data integration, data modeling, and data visualization best practices.
• Knowledge of dashboard performance optimization and data refresh management.
• Strong analytical, troubleshooting, and stakeholder communication skills.

Preferred Candidate Profile

• Strong Tableau development experience with the ability to independently deliver end-to-end BI solutions.
• Practical exposure to Tableau Next beyond theoretical knowledge.
• Ability to understand business requirements and convert them into scalable, user-friendly dashboards.
• Experience supporting enterprise reporting and working with business stakeholders.

We are looking for a dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.

Qualifications and Skills:

• Minimum 5 years of experience as a Data Engineer
• Hands-on experience with Azure cloud-based data solutions
• Expertise in database design and management, including SQL databases such as SQL Server
• Proficient in ETL (Extract, Transform, Load) design for data integration and processing
• Strong knowledge of data modeling principles and techniques
• Ability to analyze and translate data into actionable insights, reports, and visualizations
• Proficiency in Power BI for reporting and data visualization

Desirable Skills:

• Experience with Power BI Report Builder / Reporting Services
• Knowledge of statistical analysis or Data Science
• Experience within the UK Insurance industry is a plus
• Python or R coding skills

Responsibilities:

• Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
• Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
• Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
• Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
• Implement different methods of streaming data and create reconciliations for datasets
• Build analytical models to support reporting and analytics
• Collaborate with an agile delivery team to work on the backlog of specified work

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.

Position : SQL Database Developer

Experience : 10+ Years

Domain : Mutual Fund / Capital Markets

Location : Noida

Work Mode : Hybrid

Role Overview :

We are looking for a Senior SQL Developer with 10+ years of experience in SQL Server and T-SQL development, preferably with experience in the Mutual Fund / Capital Markets / Financial Services domain.

Mandatory Skills :

• SQL Server & T-SQL
• Stored Procedures, Functions, Triggers, Views & SQL Jobs
• Complex SQL Queries & Data Manipulation
• Query Performance Tuning & Optimization
• Indexing, Execution Plans & Partitioning
• Data Migration, Porting, Transformation & Validation
• Database Troubleshooting
• SQL Server Performance Monitoring
• Version Control / Git
• Database Security & Data Integrity

Domain Knowledge :

• Mutual Fund / Capital Markets experience preferred.
• Understanding of financial transactions, reporting, reconciliation, and business processes.

Key Responsibilities :

• Develop and optimize T-SQL queries, stored procedures, views, functions, and triggers.
• Perform query tuning, indexing, execution plan analysis, and performance optimization.
• Handle data migration, transformation, porting, validation, and reconciliation.
• Troubleshoot database and production/UAT issues.
• Ensure data accuracy, integrity, consistency, and security.
• Work with developers, BAs, QA teams, and business stakeholders.
• Independently own database development and optimization activities.
• Education: Bachelor's degree in Computer Science, IT, Engineering, or related field.

We are looking for a Lead – Information Systems who can combine strong Salesforce/CRM expertise, advanced Excel skills, MIS reporting and business analytics to support data-driven decision-making.

🔹 What We’re Looking For

• Minimum 4 years of hands-on experience with CRM systems, preferably Salesforce

• Minimum 3 years of practical Salesforce experience preferred

• Advanced proficiency in Microsoft Excel, including:

Advanced formulas, Pivot Tables, Power Query, Data analysis, Automation

• Strong experience in MIS reporting, data validation, analysis and presentation of insights

• Proven experience creating and maintaining dashboards, KPI reports and management reports

• Good technical aptitude with the ability to understand business processes and convert them into effective reporting solutions

• Basic to intermediate understanding of finance and business metrics, including revenue, costs, budgeting and financial reporting concepts

• Strong analytical and problem-solving skills

• Excellent stakeholder management and communication skills

• Ability to work independently and convert data into actionable business insights

🔹 Key Responsibilities

• Manage and analyze data from Salesforce/CRM and other business systems

• Develop and maintain MIS reports, dashboards and KPI trackers

• Ensure data accuracy, validation and consistency across reports

• Analyze business data and identify trends, gaps and opportunities

• Translate business requirements into meaningful reports and dashboards

• Work closely with business and functional stakeholders to understand reporting requirements

• Support management with timely and accurate business insights and performance reports

• Identify opportunities to improve reporting processes through Excel, Power Query and automation

• Support CRM-related reporting and process improvements

🎯 Ideal Candidate

Someone who is comfortable working at the intersection of CRM + MIS + Excel + Business Analytics, and can go beyond preparing reports to explain what the data means and what action the business should take.

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.