Silverstone Developer/Senior Consultant Specialist

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

• We are MSS IT - MSS Operations Technology - Global Reconciliations Team. We are currently working on multiple deliveries, including building new reconciliations, multi-year, multimillion program to replace existing legacy applications, along with multiple operational enhancements, infrastructure enhancements, SSP, production stability, etc on the ground.
• We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist in Global Reconciliations.

In this role, you will:

• Play the role of individual contributor as Senior ETL developer involved to create a reporting database which is a trusted source of Post Trade data from which to produce normalised, cross product MI
• Reduce the risk associated with current MI production by ensuring data integrity and traceability and removing the need for manual enrichment where possible.
• Contributing to Production Support / Stability / maintenance as required / rotational basis / as per DevOps model.
• Contribute to design and strategy in ETL builds.

Requirements

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

• Data Modeling and Design:
• Design and develop the structure of data warehouses, including defining dimensions, facts, and relationships between data elements.
• ETL Process Development:
• Create, implement, and maintain ETL pipelines to extract data from various sources, transform it into a usable format, and load it into the data warehouse or target systems.
• Data Quality and Integrity:
• Ensure data accuracy, consistency, and completeness by implementing data validation rules, cleansing procedures, and monitoring data quality metrics.
• Performance Optimization:
• Identify and address performance bottlenecks in ETL processes and data warehouse systems, optimizing query execution and data loading times.
• Collaboration and Communication:
• Work closely with business analysts, data scientists, and other developers to understand requirements, troubleshoot issues, and ensure seamless data integration.
• Mentorship and Guidance:
• Mentor junior developers, sharing best practices, providing technical guidance, and fostering a collaborative team environment.
• Technical Leadership:
• Provide technical leadership on ETL projects, guiding the team on architectural decisions, technology choices, and development standards.
• Troubleshooting and Issue Resolution:
• Investigate and resolve complex data-related issues, including data inconsistencies, performance problems, and system errors.

• Documentation:

• Create and maintain comprehensive documentation for ETL processes, data models, and system configurations.

Non-technical / General:
- Previous experience in Banking and Finance domain
- Experience in agile delivery mechanism.
- Any DevOps tooling experience, CI/CD pipeline, automation would be an added advantage.
- Strong communication skills - experience of interfacing with IT Lead/Delivery Manager, Architect, business Product Owners and IT offshore teams

Interpersonal Skills
- Ability to deal with frequent changes.
- Ability to work with Global stakeholders, vendors.
- Must be able to work independently with minimum guidance.
- Model - Strive to be Role Model for the peers.

You'll achieve more when you join HSBC.

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