
Technical Subject Matter Expert / Senior Consultant Specialist
at HSBC
Posted 9 hours ago
No clicks
- Compensation
- Not specified
- City
- Not specified
- Country
- India
Currency: Not specified
We are seeking an experienced Technical Subject Matter Expert / Senior Consultant Specialist to own production support, incident management, and root cause analysis for the RDH platform. You will oversee data ingestion and integration, optimize Dataflow/Airflow pipelines, and ensure data quality and consistency across ingestion and distribution channels. You will manage data exposure to downstream applications via APIs, SFTP, and BigQuery auth views, collaborating with engineering, governance, and business teams to deliver platform enhancements and maintain runbooks and knowledge articles. The role requires strong SQL (BigQuery), solid GCP knowledge, experience with data pipelines and automation, and a commitment to continuous improvement and data security.
Some careers shine brighter than others.
If you’re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further.
HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions.
We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist
In this role, you will:
- Production Support & Incident Management
- Serve as the primary escalation point for production issues, ensuring timely resolution and minimal business impact.
- Monitor RDH platform health, proactively identify potential issues, and implement preventive measures.
- Lead root cause analysis (RCA) for incidents and drive continuous improvement initiatives. - Data Ingestion & Integration
- Oversee and optimize Dataflow pipeline operations for ingesting internal and external reference data.
- Ensure data quality, consistency, and integrity across all ingestion and distribution channels. - Data Exposure & Consumption
- Manage and support data delivery to downstream applications via APIs, SFTP, BigQuery Auth Views, and other supported patterns.
- Collaborate with consumers to understand requirements and troubleshoot integration issues. - SQL & Data Analysis
- Write, optimize, and review complex SQL queries for data validation, troubleshooting, and reporting.
- Perform data profiling, cleansing, and transformation as needed to support business and technical requirements. - Collaboration & Stakeholder Management
- Work closely with engineering, data governance, and business teams to deliver platform enhancements and resolve issues.
- Document technical processes, support runbooks, and knowledge articles for wider team adoption. - Continuous Improvement
- Identify opportunities for automation and process optimization within the RDH ecosystem.
- Stay abreast of GCP advancements and recommend adoption of relevant tools and best practices.
To be successful in this role, you should meet the following requirements:
- Technical Expertise
- Strong hands-on experience with SQL (BigQuery preferred), including writing and optimizing complex queries.
- Solid understanding of GCP services, especially BigQuery, Cloud Storage, Pub/Sub, and IAM.
- Experience with data pipeline orchestration tools (e.g., Dataflow, Apache Airflow, Dataflow). - Production Support
- Proven track record in L2/L3 production support roles for data platforms or similar environments.
- Familiarity with incident management, monitoring, and alerting tools. - Integration & Data Delivery
- Experience supporting data delivery via APIs, SFTP, and secure data sharing mechanisms.
- Understanding of authentication, authorization, and data security best practices. - Soft Skills
- Excellent problem-solving and analytical skills.
- Strong communication and stakeholder management abilities.
- Ability to work independently and as part of a cross-functional team. - Desirable Skills
- Experience with Python or other scripting languages for automation.
- Knowledge of data governance, metadata management, and data quality frameworks.
- Familiarity with Agile methodology and DevOps practices.
You’ll achieve more when you join HSBC.
www.hsbc.com/careers
HSBC is committed to building a culture where all employees are valued, respected and opinions count. We take pride in providing a workplace that fosters continuous professional development, flexible working and opportunities to grow within an inclusive and diverse environment. Personal data held by the Bank relating to employment applications will be used in accordance with our Privacy Statement, which is available on our website.
Issued by – HSBC Software Development India

