Senior Data Analyst/Lead Consultant Specialist

Job description

Job description

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 Lead Consultant Specialist

  In this role, you will:

·  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
·  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, standardise and automate processes
·  Communication Language - English is mandatory as team is spread globally. (UK, India, Poland, China) 

Requirements

  To be successful in this role, you should meet the following requirements:

·  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. 
·  Previous experience on Data Modelling of Trade, Position, Product, Cashflow, Valuation, Risk, Collateral, Accounting, Client, Reference and Market Data 
·  Hands on Technical and Data Analysis skills on Spark SQL, Git, XML/XSD, JSON/Protobuf , REST APIs, CICD Pipelines, Data processing pipelines.
·  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 technical skills, especially in both writing and interpreting SQL
·  Hands-on experience on Python and Airflow.
·  A proven track record in delivery of large-scale data centric projects in previous domains to tight deadlines
·  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.
·  Broad experience of ETL type processes, data warehouse type systems and associated database technologies (e.g. SQL Server, Oracle)
·  Strong working knowledge of SDLC tools including JIRA, Jenkins and Git.
·  Working experience on Front-to-Back Trade lifecycle, Booking Models and FO-BO-GL Recs
·  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)
·  Exposure to FpML
·  Ability to independently manage issues when they arise.
·  Strong diagram & documentation skills, adherence to quality standards
·  Ability to discuss issues and influence outcomes with Finance business contacts at all levels of seniority and document decisions effectively.
·  Behavioral Driven Development experience
·  Ability to report progress upwards and provide a level of project management expertise including input into project plans, status reporting and risk/issue logs.  

  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