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:
- Design Pega NBA source datasets for customer profile, interaction history, offers/eligibility, and outcomes—optimised for low-latency decisioning and explainability.
- Define canonical data models (facts/dimensions) for interactions and responses, including event taxonomy, identifiers, and channel standardisation.
- Implement history/auditability patterns (SCD Type 2, bitemporal where needed) to support regulatory traceability and “why did we decide X?” replay.
- Build near-real-time ingestion pipelines (CDC/streaming/micro-batch) with deterministic ordering, idempotency, and deduplication for event feeds.
- Establish data quality controls (completeness, validity, timeliness, consistency) with automated checks, thresholds, and exception workflows.
- Set up monitoring & observability for SLAs/SLOs (freshness, lag, volume anomalies), lineage, and alerting integrated with incident management.
- Partner with stakeholders (Pega decisioning, product, risk/compliance, analytics, engineering) to align eligibility rules, consent, and governance.
- Drive continuous improvement on performance, cost, and reliability—capacity planning, schema evolution, and controlled releases with rollback plans.
To be successful in this role, you should meet the following requirements:
- Strong experience designing decisioning/marketing/next-best-action datasets (customer, interactions, offers, outcomes) for operational use.
- Proven dimensional modelling skills (star schemas, conformed dimensions) plus event modelling for high-volume interaction data.
- Hands-on expertise with SCD Type 2 and audit patterns (effective dating, versioning, bitemporal concepts) for traceability.
- Experience delivering near-real-time data feeds (Kafka/Kinesis/PubSub, CDC tools, micro-batching) with exactly-once/at-least-once handling strategies.
- Strong data quality engineering background: automated validation frameworks, anomaly detection, reconciliation, and data contracts.
- Solid understanding of data governance: consent/permissions, PII handling, retention, and access controls in regulated environments.
- Proficiency in SQL and data engineering tooling (ETL/ELT, orchestration, CI/CD, schema registry, metadata/lineage).
- Ability to communicate clearly with technical and non-technical teams; comfortable translating business rules into data requirements and SLAs.
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
hackajob is partnering with HSBC to fill this position. Create a profile to be automatically considered for this role—and others that match your experience.
