Senior Technical Lead

HCL Technologies Limited; Chennai District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

HCLTech is seeking a seasoned Data & Analytics Developer in Chennai to design and maintain data warehouses, ETL pipelines and dashboards that power BCM reporting. You will work in an agile, collaborative team delivering scalable analytics with governance alignment.

Role emphasizes expert Tableau development, advanced SQL, and Enterprise data modelling for regulatory and management reporting across global teams.

Qualifications

• Minimum 5 - 8 years of experience in data warehouse development, BI reporting, and dashboard creation.
• Proficiency in Tableau Desktop & Server/Cloud, including advanced features.
• Strong SQL with data modelling knowledge and performance tuning.
• Experience with ETL/ELT tools and multiple RDBMS platforms.
• Familiarity with CI/CD and version control practices.

Responsibilities

• Design, develop, and maintain enterprise-grade data warehouse models and semantic layers.
• Build and optimise ETL/ELT processes for consolidating data from multiple sources.
• Develop high-performance dashboards in Tableau translating business requirements into reports.
• Write advanced SQL queries and procedures for data extraction and validation.
• Collaborate with analysts and stakeholders to define KPIs and drill-down logic.
• Ensure integration between backend data systems and visualization tools, including security.
• Govern Tableau Server/Cloud environments, and optimise performance.
• Contribute to data governance, auditing, and regulatory reporting needs.

Skills

Tableau

SQL

Data warehouse

ETL/ELT

Tableau Server/Cloud

Git/GitLab

CI/CD

Dimensional modelling

Kimball/Inmon

Metadata management

SCD

Query tuning

Snowflake

Azure Synapse

Collibra

Redshift

BigQuery

Python

REST APIs

JSON/XML

Shell/PowerShell

Private Banking domain

Tools

Oracle

MS SQL Server

PostgreSQL

Informatica

Talend

SSIS

Job description

Join growing Global Delivery Services (GDS) team in Chennai as a skilled Data & Analytics Developer, playing a pivotal role in shaping the future of data-driven decision-making across our Banking & Capital Markets (BCM) division. Embedded within a centralised Reporting & Insights Hub, you will design, develop, and maintain robust data warehousing solutions, ETL pipelines, and interactive dashboards that empower stakeholders with timely, accurate, and actionable insights.

We are seeking a technically adept developer with strong expertise in Tableau, SQL, and data warehouse architectures, who thrives in an agile, collaborative environment and is passionate about delivering high-quality analytics at scale.

This position supports global regulatory, management, and client-facing reporting needs, requiring precision, performance optimisation, and alignment with enterprise data governance principles.

Key Responsibilities

• Design, develop, and maintain enterprise-grade data warehouse models and semantic layers using dimensional modelling techniques.
• Build and optimise ETL/ELT processes for ingesting, transforming, and harmonising data from multiple sources into consolidated data marts and warehouses.
• Develop intuitive, high-performance interactive dashboards and visualisations in Tableau, translating complex business requirements into insightful reports.
• Write advanced SQL queries, stored procedures, and functions for data extraction, aggregation, and validation across relational databases (e.g., Oracle, SQL).
• Collaborate with business analysts, data stewards, and project teams to gather reporting requirements and define KPIs, metrics, and drill-down logic.
• Ensure seamless integration between backend data systems and front-end visualisation tools, including parameterisation, filtering strategies, and row-level security in Tableau.
• Administer and govern Tableau Server/Cloud environments, managing workbooks, data sources, permissions, scheduling, and performance tuning.
• Support regulatory and management reporting initiatives, ensuring outputs comply with audit, control, and timeliness requirements.
• Optimise query performance through proper indexing, partitioning, materialised views, and efficient join logic.
• Document data lineage, report specifications, metadata definitions, and refresh mechanisms to ensure transparency and sustainability.
• Participate in Agile ceremonies — including sprint planning, backlog refinement, demos, and retrospectives — as part of a cross-functional delivery team.
• Uphold best practices in version control (Git/GitLab), CI/CD pipelines, automated testing, and change management throughout the development lifecycle.
• Stay current with advancements in data analytics, visualisation techniques and governance standards.

Skill Requirements

Minimum 5 - 8 years of experience in data warehouse development, BI reporting, and dashboard creation.

Proficiency in:

• Tableau Desktop & Server/Cloud (including calculated fields, LOD expressions, parameters, dashboard actions)
• Advanced SQL programming (CTEs, window functions, recursive queries, query optimisation)
• Relational database management systems (RDBMS) such as Oracle, Microsoft SQL Server, or PostgreSQL
• ETL tools (e.g., Informatica, Talend, SSIS, or equivalent)
• Version control using Git/GitLab and familiarity with CI/CD practices
• Solid understanding of:
• Dimensional modelling and data warehouse architecture (Kimball/Inmon)
• Metadata management, slowly changing dimensions (SCD), and fact table types
• Performance tuning of large datasets and complex visualisations
• Experience working in regulated financial environments with sensitivity to data confidentiality and integrity.

Exposure to cloud data platforms such as Snowflake, Azure Synapse, Collibra, Amazon Redshift, or Google BigQuery

• Familiarity with Python or other tools for data manipulation and automation
• Knowledge of REST APIs, JSON/XML parsing, or integration with external systems
• Basic scripting in Shell, PowerShell, or Python for workflow automation
• Functional understanding of Private Banking or Wealth Management domains, particularly around:
• Securities Transactions (Equities, Bonds, Funds)
• Treasury Operations
• Fees & Commission Calculations
• Regulatory Reporting (e.g., MiFID II, FATCA, CRS)

Personal Attributes

• Strong analytical mindset with keen attention to data accuracy and visual storytelling.
• Passion for creating clean, user-friendly, and impactful dashboards that drive business decisions.
• Ability to work independently and collaboratively in fast-paced, agile delivery cycles.
• Excellent written and verbal communication skills — able to explain technical concepts to non-technical users.
• Committed to high standards of code quality, documentation, and data governance.
• Curious and proactive learner, eager to adopt new tools and improve existing processes.

Preferred Qualifications

• Certification in Tableau Desktop/Server, Microsoft Power Platform, or related data analytics credentials.
• Previous experience in financial services, asset management, or private banking sectors.
• Involvement in large-scale data migration, system consolidation, or digital transformation projects.

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 223,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending June 2026totaled $14.8billion.