Job Description

Job description

Some careers shine brighter than others.

If you\xe2\x80\x99re 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.

In IT we provide HSBC with a genuine competitive advantage across the globe. In particular, Global Business Insights (GBI) provide critical metrics and reports to Markets and Securities Services Operations to enable them to monitor the health of their business and make data-driven decisions.

The GBI Transformation is a large and complex data integration program spanning all of MSS Ops globally. We serve a diverse audience of users and data visualisation requirements from Exco down, and over 80 data sources in multiple time-zones across Middle Office, Post-Trade and Securities Services IT and elsewhere. We are a critical enabler for the Rubix 2025 Strategy and the MSS control agenda, providing operational KPI and KRI metrics which allow senior management to measure the success of their BAU and CTB investment dollars.

We are currently seeking an experienced professional to join our team in the role of GCP Data Engineer.

In this role, you will:

\xc2\xb7 Design, build, test and deploy Google Cloud data models and transformations in BigQuery, Datafusion environment (e.g. SQL, stored procedures, indexes, clusters, partitions, triggers, etc.)

\xc2\xb7 Optimize data views for specific visualization use cases making use of schema design partitions, indexes, down-sampling, archiving, etc. to manage trade-offs such as performance and flexibility

\xc2\xb7 Review and refine, interpret and implement business and technical requirements

\xc2\xb7 Ensure you are part of the on-going productivity and priorities by refining User Stories, Epics and Backlogs in Jira

\xc2\xb7 Onboarding new data sources, design, build, test and deploy Cloud data ingest, pipelines, warehouse and data models/products (GCP DataFusion, Spark and etc.)

\xc2\xb7 Manage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc.

\xc2\xb7 Estimate, commit and deliver requirements to scope, quality, and time expectations

\xc2\xb7 Protect the solution with appropriate Authorization and Authentication models, data encryption and other security components

\xc2\xb7 Optimize data view for specific visualization use cases making use of schema design partitions, indexes, down-sampling, archiving, etc. to manage trade-offs such as performance and flexibility

\xc2\xb7 Deliver non-functional requirements, IT standards and developer and support tools to ensure our applications are a secure, compliant, scalable, reliable and cost effective

\xc2\xb7 Ensure a consistent approach to logging, monitoring, error handling and automated recovery as per HSBC standards

\xc2\xb7 Write automated unit and regression tests as part of a test-centric development approach

\xc2\xb7 Write well-commented, maintainable and self-documenting code

\xc2\xb7 Deliver a data warehouse and pipelines which follow API, abstraction and \xe2\x80\x98database refactoring\xe2\x80\x99 best practice in order to support evolutionary development and continual change

\xc2\xb7 Develop procedures and scripts for data migration, back-population and initialization

\xc2\xb7 Fix defects and provide enhancements during the development period and hand-over knowledge, expertise, code and support responsibilities to support team

\xc2\xb7 Protect the solution with relevant Data Governance, Security, Sovereignty, Masking and Lineage capabilities

\xc2\xb7 Maintain good quality and up to date knowledge base, wiki and admin pages of the solution

\xc2\xb7 Peer review of colleague\xe2\x80\x99s changes

\xc2\xb7 Speak up and help shape how we do things better

Requirements

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

\xc2\xb7 Proven experience / expertise in database design, development and administration of Traditional/Cloud Databases & Data Warehouses / Procedures / Products (4+ years)

\xc2\xb7 1+ years of proven recent experience in developing, refactoring, optimization of SQL/T-SQL procedures in BigQuery or equivalent Cloud Databases

\xc2\xb7 Good understanding of GCP Core and Data Products, Architecting and Designs/Patterns

\xc2\xb7 Data preparation, wrangling and refactoring skills, for example as part of a Data Science pipelines

\xc2\xb7 Expert in the preparation, usage, visualization and editing of data in web, dashboard or other user interfaces (3-tier architecture, CRUD procedures, etc.)

\xc2\xb7 IT methodology/practices knowledge and solid experience in Agile/Scrum

\xc2\xb7 Experience in Collaboration tools usage such as JIRA/Confluence/Various board types

\xc2\xb7 BS/MS degree in Computer/Data Science, Engineering, Data or a related subject

\xc2\xb7 Excellent communication and interpersonal skills in English. Proficiency in verbal, listening and written English is crucial.

\xc2\xb7 Enthusiastic willingness to rapidly and independently learn and develop technical and soft skills as needs require.

\xc2\xb7 Strong organisational and multi-tasking skills.

\xc2\xb7 Good team player who embraces teamwork and mutual support.

\xc2\xb7 Interested in working in a fast-paced environment

Ideal Experience (following skills/experiences would be an added advantage):

\xc2\xb7 Experience developing BI/MI reports and dashboards in a popular tool like Qlik (VizLib Library, VizLib Collaboration, Mashups, etc.), Tableau, Looker etc.

\xc2\xb7 Experience in GCP based big data / ETL solutions DevOps / DataOps model

\xc2\xb7 Experience of deploying and operating Datafusion/CDAP based solutions

\xc2\xb7 Experience in building and operating CI/CD life-cycle management Git, Jenkins, Groovy, Checkmarx, Nexus, Sonar IQ

\xc2\xb7 Expertise of Java, Python, DataFlow

\xc2\xb7 Broad experience with IT development and collaboration tools.

\xc2\xb7 An understanding of IT Security and Application Development best practice.

\xc2\xb7 Understanding of and interest in various investment products and life cycle and the nature of the investment banking business.

\xc2\xb7 Experience of working with infrastructure teams to deliver the best architecture for applications.

\xc2\xb7 Working in a global team with different cultures.

\xc2\xb7 HSBC working previous experience

You\xe2\x80\x99ll 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 \xe2\x80\x93 HSBC Software Development India

HSBC