Deloitte - Senior Consultant - Data Analyst

Data Analyst

- Effectively able to engage with various Levels of Stakeholders and understand the Business Requirement.

- Define and obtain source data required to successfully deliver insights and use cases.

- Create methods to highlight and report data inconsistencies, allowing users to review and provide feedback on.

- Propose suitable data migration sets to the relevant stakeholders

- Assist teams with processing the data migration sets as required

- Determine the data mapping required to join multiple data sets together across multiple sources

- Technically able to validate, analyze, data model and write the clear use stories to Data Engineers.

- Define the Data Asset Generation Design with Best Practices in various Data Work flow.

- Continuously able to support Data engineers throughout the complete SDLC.

- Able to be innovative in providing the best data design solutions and suggestions to achieve the business expectations.

- Able to support the SIT, UAT and Production Support.

- Assist with the planning, tracking and coordination of the data migration team and with the migration run-book and the scope for each cutover.

- Able to document the data design and solutions to the high end for future reference.

- Understand the Data Definition Tagging processes like Logical to Physical Mapping, Data Processing Flow to measure the consistency etc.,

- Co-ordinate with CDO (Chief Data Office) for Trusted Source validation and data modelling.

- Able to understand the Data Governance Processes to monitor and deliver the data solutions with compliance in place.

Customers / Stakeholders:

- Wholesale, Global Markets, CMB and Global Banking business lines

- Global and Regional Heads of business

- Distribution Platforms IT

- Internal clients to facilitate effective data analysis/migration and process change and ensure expectations are effectively managed

Leadership & Teamwork:

- Lead and work closely with all teams (including virtual teams based in non UK locations), creating a strong culture of transparency and collaboration

- Senior Data Analysts must be able to lead the smaller data analyst team to set the standards of best practice and mentor throughout the deliveries.

Operational Effectiveness & Control

- Adhere strictly to compliance and operational risk controls in accordance with HSBC and regulatory standards, policies and practices; report concerns or observations in terms of control weaknesses, compliance breaches and operational risk impact.

- Ensure all due diligence is performed to prevent adverse impact to Payments FX customers and business operations

- Maintain RAID log for allocated projects, and ensure that these are fed into the programme effectively

Major Challenges (The challenges inherent in the role that require a continual test of the role holder's abilities)

- Demonstrate a continual desire to implement "strategic" or "optimal" solutions and where possible, avoid workarounds or short term tactical solutions.

- Working with stakeholders to ensure that negative customer and business impacts are avoided.

- Understand all changes in the wider context of the business lines/ areas we support and the programme has an impact, including Regulatory and Global Standards projects.

- Manage stakeholder expectations and ensure that robust communication and escalation mechanisms are in place across the project portfolio.

Role Context (The environment and operating conditions of the role including the extent of guidance and authority)

- This change-the-bank (CTB) role requires a strong self-starter with strong change delivery skills who enjoys the challenge of delivering change within tight deadlines

- Structured and organised leader with strong project management, data and business analysis skills, and the ability to manage multiple priorities

Management of Risk (Operational Risk / FIM requirements)

- A good understanding of the control requirement surrounding data handling will be advantageous in this role

- Assess the operational risks as part of the analysis and implementation planning and execution in conjunction with business heads

Knowledge & Experience / Qualifications:

- Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context. Knowledge of Trade Finance or Securities Services particularly useful.

- Knowledge of one or more of the following domains (including market data vendors):

o Party/Client

o Trade (Financial Instruments)

o GTRF (Global Trade and Receivable Finance)

o Settlements (Trade Settlements)

o Payments (SWIFT, Local clearing, International and Domestic Payments)

o Instrument and pricing

o Market and/or Credit Risk

o Lending.

o Global Liquidity, HSS and other banking products.

- Preferable knowledge and experience in Data Quality & Governance.

- Can write SQL queries, Python, Scala. Spark knowledge preferable and navigate data bases especially Hive, Hadoop, CMD, Putty.

- Experience of using and flattening XML, FPML, JSON.

- Experience of big data programmes preferable

- Enthusiastic and energetic problem solver to join an ambitious team

- Business analysis skills, defining and understanding requirements.

- Extra-ordinary Attention to detail

- Good knowledge of SDLC and formal Agile processes, a bias towards TDD and a willingness to test products as part of the delivery cycle SIT, UAT and Production Support.

- Ability to communicate effectively in a multi-programme environment across a range of stakeholders

- Proven track record of managing small delivery-focused data teams