Website TCS

Data Analyst – Tata Consultancy Services (TCS)

Opportunity Overview

Attribute Details
Organisation Tata Consultancy Services (TCS)
Position Title Data Analyst
Experience Requirement 5 – 10 Years in Data Analytics
Primary Location Gurugram, Haryana, India
Department / Practice Data Science & Analytics / Business Intelligence Practice
Employment Type Full-Time, Permanent
Target Sector IT Services & IT Consulting
Core Technical Stack Power BI, Power Automate, Advanced Excel, VBA (Visual Basic for Applications), Data Analytics

Automation & Business Intelligence Workflow

The Data Analyst at TCS builds automated reporting frameworks, enterprise Power BI dashboards, and custom VBA macros to optimise data processing and workflow efficiency for global clients:

┌───────────────────────────────────────────┐
│ 1. Data Ingestion & Legacy Extraction     │ ➔ Extract raw datasets across enterprise systems using SQL & Advanced Excel modeling
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. Process Automation & VBA Scripting     │ ➔ Automate data formatting, transformation & macro scripts using Excel VBA
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Power Automate Workflow Deployment     │ ➔ Integrate Cloud/Desktop Power Automate flows to schedule report delivery & alerts
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. BI Visualization & Leadership Insights │ ➔ Architect dynamic Power BI dashboards (DAX/Data Modeling) to present executive KPIs
└───────────────────────────────────────────┘

Key Responsibilities

  • Enterprise Dashboarding: Design, construct, and maintain interactive Power BI visual dashboards and executive scorecards to monitor core client KPIs.

  • Workflow Automation: Deploy automated end-to-end reporting solutions using Microsoft Power Automate (Desktop & Cloud flows) to eliminate manual tasks.

  • Advanced Excel & VBA Engineering: Create dynamic financial and operational spreadsheets utilizing complex formulas, dynamic arrays, and custom VBA macros.

  • Data Processing & Analytics: Extract, clean, transform, and validate complex multi-source operational datasets to ensure data hygiene and high integrity.

  • Stakeholder Consultation: Partner with senior leadership and global business clients to translate complex business needs into automated analytical frameworks.

Qualification Matrix & Technical Skill Stack

Core Requirements

Category Specifications
Professional Experience 5 to 10 years of hands-on experience in business intelligence, data analytics, and reporting automation.
Business Intelligence Advanced expertise in Power BI (complex DAX, data modeling, Power Query transformations, row-level security).
Process Automation Hands-on experience building flows in Power Automate and developing VBA scripts for Excel automation.
Spreadsheet Mastery Expert-level proficiency in Advanced Excel (Pivot Tables, INDEX-MATCH, XLOOKUP, dynamic array functions).
Analytical Capabilities Solid background in quantitative analysis, data modeling, metric definition, and data validation routines.

Key Focus Areas for Interview Preparation

  1. Advanced DAX & Power BI Architecture: Prepare for technical deep-dives into complex DAX calculations (e.g., time intelligence functions, context transition, CALCULATE modifier mechanics) and dataset modeling.

  2. Power Automate & VBA Automation Scenarios: Be ready to walk through past projects where you combined VBA macros with Power Automate flows to streamline complex manual workflows.

  3. Data Pipeline Performance: Review techniques for optimizing slow-loading Excel models, refactoring inefficient VBA loops, and optimizing Power Query execution speed.

Upload your CV/resume or any other relevant file. Max. file size: 2 GB.