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 a Consultant Specialist.
- Ensure HSBC standards and procedures are applied throughout to ensure a high-quality delivery.
- Working within a DevOps Pod with the focus on modelling data into a new Big Data platform and producing extracts for Finance and Regulatory Reporting systems.
- Analyzing and capturing functional & non-functional requirements
- Writing data mapping specifications using SQL
- Modelling trade, risk, accounting and underlying reference data from a variety of source systems covering all asset classes.
- Role has a cross-functional aspect, with focus on analysis, though testing and support activities may also be undertaken in line with DevOps principles.
- Taking ownership of tasks that will be delivered in bi-weekly sprint cycles.
- Participation in Daily Stands-ups, Backlog Refinement and Iteration Planning meetings
- Collaborating closely with Finance Change, upstream providers and downstream data consumers to ensure data requirements are fully understood and expectations are met.
- Ensuring that defects, data quality and data modelling issues are quickly resolved.
- Adhering to architecture principles and data modelling standards
- Seeks opportunities to document, standardize and automate processes.
- Oversee and support the execution of production batches, ensuring they are processed efficiently to ensure timely completion. Also, to ensure proper documentation and reporting of batch performance and any incidents.
To be successful in this role, you should meet the following requirements:
- Hands on Technical and Data Analysis skills on Spark SQL, XML/XSD, JSON/Protobuf, CICD Pipelines, Data processing pipelines.
- Strong technical skills, especially in both writing and interpreting SQL
- Python to develop, test and automate processes.
- Hands-on experience on Airflow as to build data pipelines.
- Experience of analysis techniques / methodology.
- Excellent interpersonal skills, with ability to collaborate and communicate effectively with teammates or with senior stakeholders.
- Experience of an Agile/Scrum/DevOps delivery environment
- High levels of enthusiasm and a desire to deliver the best quality products possible along with maintaining very high service levels.
- Demonstrable experience of data sourcing and data analysis skills including liaising with upstream systems and ensuring end-to-end clarity of requirements across multiple teams
- Strong working knowledge of SDLC tools including JIRA, Jenkins and Git.
Good to have:
- Finance background with knowledge of financial instruments, including OTCs, Credit Derivatives, Interest Rate Derivatives, Securities Financing Transactions inc. Repos and Stock Borrow Lending, ETDs, FX, Equities and ETDs.
- Experience on Data Modelling of Trade, Position, Product, Cashflow, Valuation, Risk, Collateral, Accounting, Client, Reference and Market Data.
- Cross-functional business function knowledge on Front Office, Middle Office, BackOffice, Finance (Product Control, Accounting), Risk and Reg Reporting
- Working knowledge on capital markets cross-asset (FX, EQ, FI, Rates, Credit, Commodity) Products (Cash and Derives including Listed, OTC, Structured and Exotics)
- Understanding of the full trade lifecycle, including front to back data flows
- Previous experience of working on Big Data environments including knowledge of associated technologies (e.g. Hadoop, Spark)
You’ll achieve more when you join HSBC.
www.hsbc.com/careers