ETL, Data Modeler, Advanced SQLSenior Consultant Specialist

Some careers have more impact than others.

If youre looking for a career where you can make a real impression join HSBC and discover how valued youll be.

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 an Senior Consultant Specialist.

In this role you will:

• Data integration for Pega Decisioning Design and build ETL/ELT pipelines to ingest data from core systems (customer product channels CRM digital campaign consent) into the decisioning data layer.
• Deliver curated datasets for Pega components such as customer profile interaction history propositions/offers eligibility contact policies and response/outcome near-real-time or micro-batch patterns whererequiredto support decisioning latency and manage data interfaces/data contracts between upstream systems the data platform and modelling (decisioning analytics)
• Create conceptual/logical/physical models to support decision strategies propensity models segmentation and performance reporting.
• Build dimensional models (facts/dimensions) for interaction response offer channel and customer behaviour for slowly changing dimensions (SCD) history tracking and auditability to support explainability and regulatory needs.
• Maintain business definitions metric logic and conformed dimensions across quality controls and governance. Implement automated data quality checks (completeness accuracy timeliness reconciliation) and monitoring/alerting.
• Ensure lineage metadata and documentation aremaintained(data dictionary model diagrams pipeline runbooks).Apply secure data handling access controls and masking/tokenisation where needed for sensitive data.
• Support incident management root-cause analysis and continuous improvement of data excellence and delivery leadership. Lead technical design code reviews and standards for ETL and modelling within the CI/CD for data pipelines and infrastructure-as-code where applicable.
• Partner with Pega architects decisioning SMEs data scientists and business stakeholders to translate requirements into engineers and help uplift team capability in data engineering and modelling best practices.

To be successful you will:

• Significant experienceas a Senior ETL/ELT Engineer delivering production-grade pipelines and data SQL(complex transformations optimisation performance tuning).
• Strong data modellingexpertise(dimensional modelling SCD types normalisation trade-offs conformed dimensions).
• Proven experience integrating data for decisioning/personalisation platforms (Pega Decisioning preferred).
• Experience withorchestration and scheduling tools(e.g. Airflow Control-M Azure Data Factory Informaticadbt).Strong programming skills in Python/Scala/Java for data processing and automation.
• Hands-on experience with data warehouses/lakes (e.g. SnowflakeBigQuery Redshift Synapse Teradata) and distributed processing (e.g. Spark).
• Solid understanding of data governance metadata and data quality frameworks. Experience with Git CI/CD and DevOps ways of working.
• Direct experience with Pega Customer Decision Hub / Next-Best-Action including interaction history and outcome capture with real-time integration patterns (Kafka event streaming APIs) and CDC ().
• Familiarity with consent/contact policy data and suppression logic for compliant of model monitoring and decision performance reporting (champion/challenger A/B testing uplift).Experience with data catalogue tools (e.g. Collibra Alation Purview).

Youll achieve more when you join 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