Trainee Data Analyst

Description of the Business Line or Department

The role is within the Client Lifecycle Management (“CLM”) IT Feature team who support business applications covering Marketing, Client Onboarding, Client Relationship Management, AML, KYC, Document Management & Compliance.

The CLM team liaise with stakeholders across the business to prioritise future enhancements using an Agile development framework for the applications within their scope.

The team are also collectively responsible for third line Application support, including data analysis, reporting, investigation of issues, liaison with internal developers/software suppliers on fixes, and involvement in the testing and promotion of IT changes.

Summary of the key purposes of the role

• Complex analysis of and in-depth understanding of functional business processes and the underlying data that enable the Bank’s business to be executed successfully.
• Understanding the database design (logical/physical) of in-scope applications that support the business processes.
• Authoring SQL to effectively query and navigate across multiple data domains to produce data analysis findings.
• Collaborate with team members and other internal stakeholders to identify data insights and to understand the root cause of data issues.
• This position also participates marketing initiatives, supporting the market strategy of the firm through data analysis and reporting.

Perform all duties in accordance with the principles outlined in the KH Code of Conduct, as well as the policies and procedures relevant to your responsibilities, to ensure that you adhere to a culture that treats clients fairly and focuses on the long-term sustainability of client relationships.

Summary of responsibilities

1. Proactively manage assigned third line support tickets and incidents.

2. Data analysis.

3. Author data queries & reporting.

4. Liaise with stakeholders across the Bank and external software vendors.

5. Understand the technical architecture of the relevant IT systems.

6. Assist with application change/upgrade projects.

7. Identify where improvements and efficiencies can be introduced.

Competencies

• Behavioural
• I make cooperation with colleagues in and outside my team a priority
• I propose new ideas and solutions
• I contribute to the Group’s societal and environmental performance
• I am able to work with colleagues from different background and culture
• I promote simplicity over complexity and I favour simple solutions
• Skills
• Ability to communicate effectively with team, end users and third-party suppliers
• Good understanding of SQL. Able to use joins, subqueries, analytical functions to return clean, comprehensive, and relevant datasets
• Basic understanding of Data Modelling techniques.
• Technical Knowledge
• Awareness of overall Finance IT Industry
• Understanding of the various stages of the Agile project management framework (SCRUM, Kanban, etc)
• Understanding of the key elements needed to provide a high-quality application support service
• Understanding of industry standard ITIL processes, including Incident and Change/ Release Management Processes

People join for the impact they can have on us. They stay for the impact we have on them. A flatter structure offers visibility and exposure beyond that of our competitors, so you know our names, and we know yours. It's personable, human, and inspires success through passion. By encouraging open mindedness and a willingness to share ideas, we have adapted to market changes and thrived through innovation. Bringing words like “hard work” and “dedication” together with “community” and “respect” has enabled us to work collaboratively and build our future together. We call this Team Spirit and it's what makes us different. It's what makes you different.

If you feel you have the required experience and qualifications, then please apply to the SG Resourcing Team, and we will manage your application. At Société Générale, we believe our people are our strength and are core to the success of our business. As such, we search for, recruit and appoint the best available person on the basis of aptitude and ability, regardless of sex, marital or civil partnership status, race, colour, nationality, ethnic or national origins, pregnancy, disability, age, sexual orientation, religion, belief or gender identity.