Business Analyst

HCLTech; Dadri; On-site; INR 900,000 - 1,300,000; Full time

Job summary

HCLTech is seeking a Power BI Analyst at Team Lead level to design, develop, and maintain dashboards that drive operational and strategic decisions. The role requires hands-on Power BI expertise, with exposure to Tableau or AWS QuickSight as needed.

Key duties include building DAX measures, data modeling, and automated reports, while collaborating with stakeholders to translate reporting needs into scalable solutions. Strong SQL and Power Automate skills are essential.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Statistics, Mathematics, or related discipline.
• 3+ years of experience in MIS, BI, reporting, data analytics, or similar roles.
• 2+ years of hands-on Power BI development experience.

Responsibilities

• Design, develop, and maintain interactive dashboards and reports using Power BI.
• Create operational, MIS, KPI, and executive-level reporting solutions.
• Develop visualizations using BI tools (Power BI, Tableau, AWS QuickSight) as required.
• Build DAX measures, Power Query transformations, and optimized data models.

Skills

Power BI

DAX

Power Query

SQL

Data Modeling

Tableau

Python

Power Automate

Excel

Data Governance

Education

Bachelor's degree in CS/IT/Engineering

Tools

Tableau

AWS QuickSight

Power Platform

Job description

HCL Tech Hiring for Power BI Analyst at Team Lead position in Noida

Role Summary

The Power BI Analyst will be responsible for developing, maintaining, and enhancing business intelligence solutions to support operational and strategic decision-making. The role requires hands-on expertise in Microsoft Power BI, with the ability to work on similar analytical platforms such as Tableau, AWS QuickSight, or other Business Intelligence tools as required.

The candidate will partner with business stakeholders to convert reporting requirements into automated dashboards, actionable insights, and scalable reporting solutions. Strong SQL skills and Power Automate experience are required. Python knowledge for ETL, data preparation, and automation will be an added advantage.

Key Responsibilities

• Design, develop, and maintain interactive dashboards and reports primarily using Microsoft Power BI.
• Create operational, WFM, MIS, KPI, and executive-level reporting solutions.
• Develop visualizations using BI tools such as Power BI, Tableau, AWS QuickSight, or equivalent platforms when required.
• Build DAX measures, Power Query transformations, and optimized data models.

Data Management & Analysis

• Extract, transform, and analyze data from SQL databases, Excel files, flat files, cloud applications, and other source systems.
• Write and optimize SQL queries including joins, CTEs, views, stored procedures, and aggregations.
• Perform trend analysis, variance analysis, and root-cause analysis to generate actionable business insights.
• Ensure accuracy, consistency, and completeness of data across reports and dashboards.

Automation & Process Improvement

• Automate recurring reporting activities using Power Automate and related Microsoft Power Platform capabilities.
• Identify opportunities to reduce manual effort and improve reporting turnaround time.
• Support development of reusable datasets, templates, and standardized reporting processes.

Stakeholder Management & Support

• Gather and clarify reporting requirements from WFM, operations, leadership, and client-facing teams.
• Provide report walkthroughs, user support, and troubleshooting for existing dashboards.
• Maintain documentation for datasets, logic, refresh schedules, and report governance.

Governance & Data Security

• Apply data governance practices and ensure controlled access to reports and datasets.
• Implement Row-Level Security or access-based views where applicable.
• Follow organizational standards for report development, validation, and publishing.

Required Skills

Must Have

• Microsoft Power BI Desktop and Service
• DAX and Power Query
• Data Modeling and Report Optimization
• SQL: Joins, CTEs, Views, Stored Procedures
• Power Automate
• Advanced Excel
• Data Validation and Documentation

Preferred Tools / Platforms

• Tableau
• AWS QuickSight
• Other Business Intelligence / analytical tools
• Power Platform ecosystem
• Cloud or SaaS reporting environments

Good to Know

• Python for ETL and automation
• Python-based data preparation
• Basic API / data extraction understanding
• Power Apps or SSIS exposure

Education & Experience

• Bachelor's degree preferred in Computer Science, Information Systems, Engineering, Statistics, Mathematics, or related discipline.
• 3+ years of experience in MIS, BI, reporting, data analytics, or similar roles.
• 2+ years of hands-on Power BI development experience.
• Must have ITES / WFM experience preferred.
• Experience in operational reporting, workforce management reporting, or business analytics environments is highly desirable.
• Strong analytical mindset with attention to detail and data accuracy.
• Ability to communicate insights clearly to technical and non-technical stakeholders.
• Ownership-driven approach with ability to manage multiple priorities.
• Problem-solving mindset with focus on automation and continuous improvement.
• Ability to work independently and collaborate with cross-functional teams.

Preferred Certifications

• Tableau Desktop Specialist or AWS QuickSight certification, if applicable.

Success Criteria

• Accurate and timely delivery of dashboards, reports, and MIS outputs.
• Reduction of manual reporting effort through automation and improved reporting workflows.
• High stakeholder satisfaction through actionable insights and reliable reporting support.
• Improved reporting governance, data quality, and dataset documentation.