Job Summary

RESPONSIBILITIES
The MSTR Development will be responsible for CCIB DCDA BI Tools Consolidation and 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 BI Reporting and product development team in CCIB DCDA
•    6-9 years experience in designing and developing complex integrated applications using BI Tools like MicroStrategy visualisation tools 
•    Advanced SQL skills in tuning, window functions, complex joins
•    Database development and optimization skills to perform in SQL Server, Oracle, PostgreSQL
•    Soft Skills like Strong communication and stakeholder management
•    Supporting analytics teams with well-modelled, performant datasets
•    Strong Technical skills Designing and Developing complex integrated applications using MicroStrategy,  additional in depth knowledge of Tableau will be plus point
•    Good exposure to migration from MSTR to Tableau or working with data accelerations tools like Dremio/Exasol  or Data processing tools like DataIku
•    Good knowledge on features / capabilities in MSTR, Tableau.
•    Serve validate application design and best practises in implementation of BI Tools development. Work with Tools Technical support to resolve issues requiring vendor assistance.
•    Govern the BI environment and continuously optimize the environment via governing settings, security settings, and other mechanisms. 
•    Upgrade of tools to latest version for maximum business impact 
•    Tools Usability Tracking & Reporting

Key Responsibilities

ETL knowledge of Data Engineering/ETL using Hadoop, SQL, Scala or Scoop
•    Experience with cloud BI ecosystems Azure, AWS, Azure (Data Factory, Synapse, Power BI Service)
•    AWS (Redshift, Glue, QuickSight)
•    Google Cloud (BigQuery, Looker)
•    Big Data Technologies (if applicable):
•    Spark, Hadoop, Hive, Kafka for large-scale data processing
•    Experience with Delta Lake, Databricks, etc
•    BI Tools or Data Acceleration/Data Processing deployment and administration
•    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

Processes
Availability/Reliability
•    Take responsibility for meeting SLA/XLA expectations around the operability and reliability of our critical user service journeys, where our customers expect a 24x7 digital service offering. Examples of “always on” techniques to be used include caching, circuit breakers, dark and canary releases, store and service patterns and alternate user experience flows.
•    Lead, own, manage, monitor and optimize the reliability and health of all environments
•    Design, code, implement break fixes to improve service availability based on outcomes from thematic reviews

Latency & Performance
•    Drive conversation around development velocity using SLIs/SLOs data to ensure development velocity vs. service reliability is optimized in partnership with Product Teams
•    Iteratively review SLI/SLO/Error Budget policy to ensure the quantitative indicators of customer experience are accurate
•    Where an increased focus on reliability is required influence senior stakeholders to ensure resourcing / effort is made available

Governance 
•    Responsible for assessing the effectiveness of the governance, oversight and controls and, if necessary, oversee changes in these areas
•    Awareness and understanding of the regulatory framework, in which the Group operates, and the regulatory requirements and expectations relevant to the role.

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.
•    Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters.

Our Ideal Candidate

ETL knowledge of Data Engineering/ETL using Hadoop, SQL, Scala or Scoop
•    Experience with cloud BI ecosystems Azure, AWS, Azure (Data Factory, Synapse, Power BI Service)
•    AWS (Redshift, Glue, QuickSight)
•    Google Cloud (BigQuery, Looker)
•    Big Data Technologies (if applicable):
•    Spark, Hadoop, Hive, Kafka for large-scale data processing
•    Experience with Delta Lake, Databricks, etc
•    BI Tools or Data Acceleration/Data Processing deployment and administration
•    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.