RESPONSIBILITIES
The ETL Design and Development  will be responsible for CCIB DCDA BI Reporting projects on-premises & on-cloud with good technical knowledge on big data and Tools. Good exposure in problem solving & stakeholder management skills. This role will report into the Lead for ETL  Reporting and product development team in CCIB DCDA
•    8 to 12 years Experience of working in data analytical ETL Design & Development projects 
•    Expertise in tools like Informatica, Talend, SSIS, DataStage, and custom Python-based ETL frameworks
•    Must know Programming skills like ETL using Hadoop, Python, SQL, Shell scripting, PySpark, Scoop, Scala
•    SQL Expertise in writing complex queries, performance tuning, query optimization
•    Data Modelling of Star/Snowflake schema, slowly changing dimensions, normalization/denormalization
•    Expertise in the Big Data Ecosystem like Hive, Spark, HDFS, or working knowledge of Hadoop-based environments
•    Soft Skills like Strong communication and stakeholder management

Strategy
The ideal candidate is highly organized, action-oriented, hands on and accomplished in the development and deployment of BI tools solutions using multiple BI tools. Candidate must have a result-oriented approach towards problem solving. Candidate must be hands on experience with Tableau topology design and deployment. conversant with application architecture for embedding Tableau in external applications, application integration and use of BI and Data processing tools in a complex environment with Data Security, User Access Managed, Authorization and tightly controlled environment which deploys modern authentication mechanisms used in large organizations. Candidates should have a basic understanding of the networking and application deployment criteria associated with deployment of web based and mobile applications. Candidate should be flexible to work on various areas in BI Tools/ Data Management Platforms within BICOE remit on Premises & on Cloud stack. In this role, he/she will be expected to acquire a deep technical understanding of the BI Tools stack (MicroStrategy/Tableau etc) . Any knowledge and hands on capabilities with scripting languages like Python, Java, Linux/Windows scripting or hands on knowledge of application monitoring tools will be a plus point. Any previous experience of developing products or applications based on integration with BI Tools like MicroStrategy will be a plus point.  

Regulatory & Business Conduct 
•    Display exemplary conduct and live by the Group’s Values and Code of Conduct. 
•    Take personal responsibility for embedding the highest standards of ethics, including regulatory and business conduct, across Standard Chartered Bank. This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct.
•    Lead to achieve the outcomes set out in the Bank’s Conduct Principles
•    Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters.

Other Responsibilities

•    BI Tools like MicroStrategy, Power BI, Tableau 
•    Programming skills like Python, Scala, or Java for custom ETL and automation
•    Good to know Cloud Platforms like AWS (Glue, Redshift, S3, Lambda), Azure (Data Factory, Synapse), or GCP (Dataflow, BigQuery)
•    Data Visualization/Reporting like Tableau, Power BI, Looker
•    Workflow Orchestration like Apache Airflow, Control-M, or similar schedulers
•    API Integration like REST/SOAP APIs for ingesting or pushing data
•    Very good verbal and written communication skills 
•    Hands-on experience in API testing & developing automation test script for mobile or tablet devices using Appium.
•    Good understanding of Linux operating system and hands on work experience in Linux operating system is desirable
•    Ability to identify new testing techniques and tools.
•    Excellent problem-solving skills.

•    Excellent team player and exhibit a positive attitude
•    Strong collaboration, oral and written skills.
•    Good exposure to migration from MSTR to Tableau or working with data accelerations tools like Dremio/Exasol  or Data processing tools like DataIku
•    Upgrade of tools to latest version for maximum business impact 
•    Tools Usability Tracking & Reporting

Skills /Abilities and Knowledge
•    Strong analytical and problem-solving skills
•    Ability to communicate orally and in writing in a clear and straightforward manner with a broad range of technical and non-technical users and stakeholders
•    Proactive and focused on results and success; conveys a sense of urgency and drives issues to closure
•    Should be a team player and leader, flexible, hardworking, and self-motivated and have a positive outlook with the ability to take on difficult initiatives and challenges
•    Ability to handle multiple concurrent projects

About Standard Chartered

We're an international bank, nimble enough to act, big enough for impact. For more than 170 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.

Our purpose, to drive commerce and prosperity through our unique diversity, together with our brand promise, to be here for good are achieved by how we each live our valued behaviours. When you work with us, you'll see how we value difference and advocate inclusion.

Together we:

• Do the right thing and are assertive, challenge one another, and live with integrity, while putting the client at the heart of what we do
• Never settle, continuously striving to improve and innovate, keeping things simple and learning from doing well, and not so well
• Are better together, we can be ourselves, be inclusive, see more good in others, and work collectively to build for the long term

What we offer

In line with our Fair Pay Charter, we offer a competitive salary and benefits to support your mental, physical, financial and social wellbeing.

• Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations.
• Time-off including annual leave, parental/maternity (20 weeks), sabbatical (12 months maximum) and volunteering leave (3 days), along with minimum global standards for annual and public holiday, which is combined to 30 days minimum.
• Flexible working options based around home and office locations, with flexible working patterns.
• Proactive wellbeing support through Unmind, a market-leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first-aiders and all sorts of self-help toolkits
• A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning.
• Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies - everyone feels respected and can realise their full potential.