Data Engineer, GSC's

Job description

GCB 5

Some Careers grow faster than others.

If you're looking for further opportunities to develop your career, take the next step in fulfilling your potential right here at HSBC.

Global Service Centres

Our Global Service Centres are an integral part of Global Operations. Employees based there manage day-to-day customer transactions and processes for the global businesses. This may include transactions for our retail bank such as processing loans, credit cards, insurance and mortgage applications, opening new accounts, and managing customer enquiries through contact centres and digital platforms.

Employees in the Global Service Centres also run and manage operations for commercial bank customers. This includes processing credit applications, facilitating payments and managing the import and export transactions that enable customers to protect and grow their businesses through international trade.

Role Purpose (overall high level summary of the role)

·
Responsible for all activities related to development, upgrade, enhancement and support of Enterprise Data Warehouse, Data Marts, Extract-Transform-Load (ETL) batch processes and other data services and analytics applications.

·
Lead the design, architecture, documentation, development, deployment and support of Data Warehouse, Data Marts and ETL Solutions

·
Develop deliverables through a variety of development methodologies (waterfall, agile, RAD) and support the ongoing development of junior team members with these approaches.

·
L3 support for bug fixing and troubleshooting

·
Support the implementation and ongoing development of the Data Strategy

·
Ensure all designs and developments adhere to Data Governance and Data Management standards

·
Ensure all changes adhere to the Change Control Process (SDLC) and follow the approved Release Management process.

·
Review and sign off deliverables across the MI and Analytics teams

·
Work closely with the business analyst's and stakeholders to gather, analyze, and document the data requirements for projects of medium to high complexity

·
Communicate proactively with team members, managers, and project managers on issues and risks that may arise during the project life cycle. Develop and execute action plans to mitigate risks.

·
Define and document standards, guidelines and processes for Data Warehouse, ETL and Database development; Ensure that the guidelines and processes are followed

·
Developing and enforcing the Data integration processes, templates, design patterns, frameworks, best practices and technical standards.

·
Advise and implement Data ingestion techniques for real time and batch processes for a variety of sources into a variety of systems. Ensuring scalability and high availability, fault tolerance and elasticity within the Data and analytics systems

·
Oversee quality, testing and implementation of data acquisition, migration and information delivery

·
Carry out detailed technical architecture and system design reviews, ensuring the documentation of requirements and designs as appropriate

·
Complete all service desks calls within agreed SLA

·
Proactively drive workload and CI opportunities through the conversion of existing MI to BI functionality

We are currently seeking an ambitious individual to join this team in “Data Engineer, GSC's”. In this role, you will:

Principal Accountabilities: Key activities and decision making areas

Impact on the Business/Function

·

·
Work closely with Group Procurement stakeholders and GB/GF Data teams to ensure business requirements are understood, translated and delivered as tooling capabilities

·
Coordinate delivery and dependencies between other Data Management projects and other relevant programs/initiatives

·
Interfaces with the business, ensuring full understanding of requirements and ability to translate technical and non-technical requirements for the appropriate user group

·
Ensuring compliance with HSBC Group company policies and procedures, including regulatory requirements.

·
Validate and monitor the success of new developments and changes to support analysis of business benefits

·
Manage all risks ensuring the appropriate recording and monitoring of risk mitigation

Customers / Stakeholders

·
Translate communications and stakeholder management strategy and plans into executable actions

·
Support users in ensuring correct requirements are recorded, impact assessed and developed to specification

·
Co-ordinate communications between the data team and all stakeholders

·
Effective communication with other Procurement teams, local Senior management to ensure alignment of objectives and requirements

·
Recommend new or improved processes or systems which support HSBC's strategic pillars

·
Proactively identify problem situations and resolve to give maximum customer satisfaction. Escalation used only where necessary.

·
Establish and maintain effective high-level relationship with customer business areas and identify areas of service improvements.

·
Represent data teams in governance forums as required

Leadership & Teamwork

·
Develop and enhance the Data Team understanding of Data Modelling/Data Warehouse methodologies and ensure Knowledge Transfer

·
Inspire trust & credibility among team members, business clients and other stakeholders through highest level of personal integrity, and ethical behavior

·
Manages and strengthens on-going relationships with current and potential customers/clients/team - develops a connection built on trust

·
Supports diversity and adapts style and language according to the demands of the situation.

·
Collaborate effectiveness and efficiency within operations for better leverage and best practice.

·
Drives a performance and collaboration culture through own behavior.

·
Encourages sharing of knowledge and information across teams and leverages from experience and learning from others; Challenges behavior/attitudes that undermine working collectively

·
Promotes the teamwork and collaboration across the analytical centers. Adopts global standards and best practices to drive business results.

·
Support strategic direction and improve delivery on agreed service level agreements.

·
Ensure effective mechanism is in place and implemented to identify and achieve individual potential at all levels to meet business objectives.

·
Regularly and effectively communicate Groups initiative, policies and other activities to the teams.

·
Provide coaching and mentoring to junior members of the team

Operational Effectiveness & Control

·
Ensure releases adhere to Change Management and Release management standards

·
Continuously review key risks and proactively institute controls in place to address the same.

·
Continually assess the operational and data risks associated with the role and inherent in the business and its processes.

·
Ensure that issues/problems are fully analyzed and resolved within reasonable time scales. Appropriate action is taken to prevent recurrence where necessary. Major issues identified and recorded / reported appropriately.

·
Procedural changes / new initiatives are fully communicated to and implemented by the teams under control.

Desired profile

Qualifications :

Knowledge & Experience / Qualifications (For the role – not the role holder. Minimum requirements of the role.)

EDUCATION

E=ESSENTIAL / P=PREFERRED

Secondary Education

University Degree

E

Advanced Degree (Masters, Phd)

P

Function specific certification or degree

CAPABILITIES AND SKILLS

(B)asic = General awareness, understands basic principles

(C)ompetent = Detailed knowledge of principles and applications

(E)xpert + Complete knowledge, expertise acknowledged by peers

Professional

Teamwork

E

Customer focused

E

Appropriate Managerial Experience

E

Analytical Reasoning

E

Motivation

E

Influence and Persuasion

C

Organizational Awareness

E

Communication

E

Change and Innovation

C

Cultural Appreciation

C

Building trusting relationships

E

Planning

E

Project Management

C

Desktop Systems / Technology

Standard office software

E

Procurement Systems

B

Project Management (JIRA, Visio etc.)

C

SQL Server

E

SSIS

E

SSRS

C

SSAS

E

Erwin

C

Python

C

Tableau

B

SQL / T-SQL

E

Functional knowledge / technical experience

Category/ Commodity Knowledge

B

General Procurement Process

B

Enterprise ETL Tools

E

Data Modelling

E

Data Warehousing

E

Data Architecture

E

Data Management

E

Project Management

C

Process Analysis / Improvement

C

Big data technologies

B

Programming / Software development (PROG)

Level 5

Sets local or team-based standards for programming tools and techniques, including security guidelines, and the selection of appropriate development methods.

Advises on application of standards and methods and ensures compliance.

Drives a flexible approach to development including all methodologies (Waterfall, Agile, RAD)

Takes technical responsibility for all stages and/or iterations in a software development project, providing method specific technical advice and guidance to project stakeholders.

Assigns work packages, monitors performance and manages change control dynamically, to optimize productivity.

Provides advice, guidance and assistance to less experienced colleagues as required.

Testing (TEST)

Level 4

Accepts responsibility for creation of test cases using own in-depth technical analysis of both functional and non-functional specifications (such as reliability, efficiency, usability, maintainability and portability).

Creates traceability records, from test cases back to requirements. Produces test scripts, materials and regression test packs to test new and amended software or services.

Specifies requirements for environment, data, resources and tools.

Interprets, executes and documents complex test scripts using agreed methods and standards.

Records and analyses actions and results, and maintains a defect register.

Reviews test results and modifies tests if necessary.

Provides reports on progress, anomalies, risks and issues associated with the overall project.

Reports on system quality and collects metrics on test cases.

Provides specialist advice to support others.

Release and deployment (RELM)

Level 5

Leads the assessment, analysis, planning and design of release packages, including assessment of risk.

Liaises with business and IT partners on release scheduling and communication of progress. Conducts post release reviews. Ensures release processes and procedures are applied.

Information management IRMG

Level 4

Understands and complies with relevant organizational policies and procedures, taking responsibility for assessing and managing risks around the use of information.

Ensures that information is presented effectively.

Ensures that effective controls are in place for internal delegation, audit and control and that the board receives timely reports and advice that will inform their decisions.

Requirements definition and management REQM

Level 5

Facilitates scoping and business priority setting for large or complex changes, engaging senior stakeholders as required. Selects the most appropriate means of representing business requirements in the context of a specific change initiative.

Drives the requirements elicitation process where necessary, identifying what stakeholder input is required.

Obtains formal agreement from a large and diverse range of potentially senior stakeholders and recipients to the scope and requirements, plus the establishment of a base-line on which delivery of a solution can commence.

Takes responsibility for the investigation and application of changes to program scope.

Identifies the impact on business requirements of external impacts affecting a program or project.

Database design DBDS

Level 5

Maintains and applies up to date, specialist knowledge of database concepts, object and data modelling techniques and design principles, and a detailed knowledge of the full range of database architectures, software and facilities available.

Analyses data requirements, to establish, modify or maintain a data model.

Takes account of specialist requirements (e.g. geocoding, for geographic information systems). Interprets the model into an appropriate database schema within set policies.

Demonstrates, installs and commissions selected products.

Quality standards QUST

Level 4

Controls, updates and distributes new and revised quality standards, including technical changes.

Relationship management RLMT

Level 5

Identifies the communications needs of each stakeholder group in conjunction with business owners and subject matter experts.

Translates communications / stakeholder engagement strategies into specific tasks.

Facilitates open communication and discussion between stakeholders, acting as a single point of contact by developing, maintaining and working to stakeholder engagement strategies and plans

Negotiates with stakeholders at senior levels, ensuring that organizational policy and strategies are adhered to.

Provides informed feedback to assess and promote understanding.

Information assurance INAS

Level 5

Interprets information assurance and security policies and applies these in order to manage risks.

Provides advice and guidance to ensure adoption of and adherence to information assurance architectures, strategies, policies, standards and guidelines.

Uses testing to support information assurance.

Contributes to the development of policies, standards and guidelines.

Project management PRMG

Level 5

Takes full responsibility for the definition, approach, facilitation and satisfactory completion of medium scale projects (typically with direct business impact and firm deadlines).

Identifies, assesses and manages risks to the success of the project. Ensures that realistic project plans are maintained and ensures regular and accurate communication to stakeholders, consistent with the methods in use (agile, waterfall, etc).

Ensures Quality reviews occur on schedule and according to procedure. Manages the change control Skills procedure, and ensures that project deliverables are completed within agreed cost, timescale and resource budgets, and are signed off.

Provides effective leadership to the project team, and takes appropriate action where team performance deviates from agreed tolerances.

The number of position for this job is 1.

Additional Information

· 
All applicants must have successfully completed their probation period.

· 
Employees must meet performance and behavioral standards as defined in the policy.

· 
All L6 & L5 applicants should have served at least 24 months and should have successfully completed respective learning curve tenure, in their current role as on closing date.

· 
Applicant should not be on a corrective action plan/ disciplinary action in the last 6 months or any other performance action as on the date of application.

· 
Application form should be submitted along with the current CV.

· 
All applicants should inform their respective Line Managers of their application.

· 
All the completed applications should be submitted on or before the closing date.

· 
Applicant should not be on a corrective action plan/ disciplinary action in the last 6 months or any other performance action as on the date of application.

· 
The Company reserves the right to change any terms and conditions related to employment, mentioned in the Offer Letter and the Rules and Regulations governing the conduct of the employee in the Company. Such change would be intimated by the Company through an internal communication to the employees at large.

· 
Right to work is required. Local employment rulings and restrictions will apply.

You'll achieve more at 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.

HSBC is an equal opportunity employer 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. We encourage applications from all suitably qualified persons irrespective of, but not limited to, their gender or genetic information, sexual orientation, ethnicity, religion, social status, medical care leave requirements, political affiliation, people with disabilities, color, national origin, veteran status, etc., We consider all applications based on merit and suitability to the role.”

***Issued By HSBC Electronic Data Processing (India) Private LTD***