:OngoingThe Role The main objective of this role is to actively participate in Treasury innovation and digitalisation programme, through creating and embedding in-house data-driven solutions for stakeholders globally. Our goal is to help influence top-level decision-making process. We aim to achieve that by providing critical, data-driven business insights via developing and introducing advanced analytical tools. This requires combining technical know-how ( systems, data, programming) with a commercial mindset (business opportunities, regulatory constraints). The successful candidate will be part of an agile squad, delivering data modelling and analysis solutions for balance sheet optimisation. The candidate will be responsible for data sourcing, transformation, analysis and architecture, combining all necessary inputs into one aligned and complete data stream needed to deliver all required business views, metrics and simulations. The Responsibility Translate business requirements into data requirement / data model, working with technology Data Engineers to design the relevant data extracts as inputs to models and solutions. Analyse data extracts from source systems and validate if meets business requirements; working with Data Engineers to enhance the extracts. Working with product owner to create business logic / mapping for stitching multiple different sets of data together and / or add business-related attributes. Implement end to end data flow (pipes) in the in-house platform from raw data extract to final results table. This includes ETL, any transformations / stitching of different data set and enrichment with business logic. Working with technology to build and maintain the relevant database / tables based on the agreed architecture. Maintain and update all key tables for business mappings & logics. Excel (VBA) prototyping work on forecasting using the data set. Independently conduct deep-dive data analysis to investigate any issues. Propose, create, and deliver business-oriented MI to share with wider business audiences. Run period process to ensure product of these MI ( monthly). Document all underlying business mapping methodologies, design, assumptions and exceptions. Our Ideal Candidate Requirements (must have) 3-5 years of experience in data analysis, data architecture, data transformations, building end to end inhouse data flows (pipes) from source to output, preferably in a bank environment. Master’s degree in Finance Economics, Engineering, Mathematics or similar, fresh graduates / final year students with relevant major and outstanding academic record will be also considered. Good knowledge of Python, VBA and SQL (other languages advantageous) and Excel. Outstanding analytical and problem-solving skills. Excellent written and verbal communication skills in English. Ability to work in a fast-paced environment, open-minded and willing to learn new skills (both business and technical knowledge). Advantages (good to have) Previous experience in end to end data extraction, ETL, transformation and MI building Previous experience working in an agile environment Understanding and practical experience in liquidity risk, ALM, banking products and/or balance sheet optimization Prior experience with Dataiku data platform or with Balance Sheet Management platforms (Moody's Analytics, RiskPro, QRM, Oracle, etc.) or booking platforms (Murex, Kondor, etc.) Role Specific Competencies Liquidity ratios such as LDR, deposit concentration etc ALM and Commercial Book products Understanding of Bank systems architecture Python/R programming SQL Excel VBA Solution design and validation End User testing / computation Data Analysis Data Design About Standard Chartered We're an international bank, nimble enough to act, big enough for impact. For more than 160 years, we've worked to make a positive difference for our clients, communities, and each other. We question the status quo, love a challenge and enjoy finding new opportunities to grow and do better than before. If you're looking for a career with purpose and you want to work for a bank making a difference, we want to hear from you. You can count on us to celebrate your unique talents. And we can't wait to see the talents you can bring us. Visit our careers website