AI-Data and Analytics Lead(Python, SQL, LLM, Cloud)/Associate Director (Pune, MH, IN, 411006)

HSBC
Pune
Workplace: OnsiteFull timeFunction: Data Analytics & Business IntelligenceSkills: []

Lead enterprise finance MI and conversational analytics by owning analytics serving layers, curated datasets/views/APIs, and scalable data models across TM1 cycles. Partner with data engineering to deliver TM1→GCP batch and near real-time pipelines, including orchestration, monitoring, and operational readiness. Drive a finance semantic layer for consistent metrics, implement fine-grained security/entitlements, and enable governed text-to-query and AI/RAG readiness.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
HSBC
HSBC
1 day ago

AI-Data and Analytics Lead(Python, SQL, LLM, Cloud)/Associate Director (Pune, MH, IN, 411006)

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 2 hours agoStatus: Live

Job Summary

Lead enterprise finance MI and conversational analytics by owning analytics serving layers, curated datasets/views/APIs, and scalable data models across TM1 cycles. Partner with data engineering to deliver TM1→GCP batch and near real-time pipelines, including orchestration, monitoring, and operational readiness. Drive a finance semantic layer for consistent metrics, implement fine-grained security/entitlements, and enable governed text-to-query and AI/RAG readiness.
Location: Pune
Workplace: Onsite
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Director level

Key Responsibilities

  • •Own the serving layer for Enterprise Finance value stream MI and conversational analytics, defining curated datasets/views/APIs with clear SLAs/SLOs and performance/cost targets.
  • •Lead end-to-end data model development across TM1-sourced actuals/forecasts/FRP cycles, optimized for analytics consumption and scalable serving patterns.
  • •Partner to deliver a department-wide semantic layer to standardize finance metrics, dimensions, and calculation logic for consistent MI and AI outputs.
  • •Build and operate TM1 → GCP pipelines (scheduled + near real-time), including orchestration, reconciliation, monitoring, and runbooks.
  • •Implement fine-grained security and entitlements in the serving layer (row/column security, hierarchy-based access, auditing) and enable governed text-to-query and AI/RAG readiness for curated finance artefacts.

Key Requirements

  • •Deep hands-on experience designing analytics serving layers on cloud warehouses (preferably BigQuery), including curated datasets/views, performant materialisations, partitioning/clustering, and cost optimization.
  • •Strong expertise in dimensional modelling and analytical data design (star/snowflake schemas, conformed dimensions, SCD patterns, hierarchies, and time/scenario/version modelling).
  • •Proven experience building a metrics/semantic layer using modern approaches (e.g., dbt models/metrics, LookML-style modelling, Cube/MetricFlow-like patterns), including metric versioning, validation, and lineage/metadata management.
  • •Solid data engineering capability for batch and near real-time pipelines, including orchestration (e.g., Airflow/Composer), reconciliation/quality frameworks, and monitoring/alerting with operational readiness.
  • •Strong SQL and optimization skills plus working proficiency in Python for analytics engineering, automation, validations, and integration tooling.
Experience:BankingFinancial services
Tech Stack:PythonSQLLLMRAGBigQueryGCPCloudTM1AirflowComposerDbtLookMLCubeMetricFlowEmbeddingsVector searchText-to-SQLRBACABACRow/column security

Company Brief

HSBC
Global banking and financial services organisation offering retail, commercial, corporate and investment banking, wealth management, and global markets services across Europe, Asia, the Americas and the Middle East.
Industry: Banking
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: London, United Kingdom
Founded: 1865
Glassdoor
Glassdoor: 3.6
WebsiteLinkedIn