Job Summary

•    Responsible for the design and development analytical data model,  reports and dashboards
•    Provide design specifications to both onsite & offshore teams
•    Develop functional specifications and document the requirements clearly
•    Develop ETL, Reports, data mapping documents and technical design specifications for the project deliverables.
•    Analyse the business requirements and come up with the end-to-end design including technical implementation. 
 

Key Responsibilities

Strategy

•    Responsible for the design and development analytical data model,  reports and dashboards
•    Provide design specifications to both onsite & offshore teams
•    Develop functional specifications and document the requirements clearly
•    Develop data mapping documents and technical design specifications for the project deliverables.
•    Analyse the business requirements and come up with the end-to-end design including technical implementation. 
•    Expert in Power BI, MSTR, Informatica, Hadoop Platform Ecosystem, SQL, Java, R, Python, Java Script, Hive, Spark, Linux Scripts
•    Good knowledge on to Install, upgrade, administration, and troubleshooting of ETL & Reporting tools such as Power BI, MSTR, Informatica, Oracle and Hadoop
•    Implement performance tuning techniques for Reports, ETL and data Migration
•    Develop ETL procedures to ensure conformity, compliance with standards and translate business rules and functionality requirements into ETL procedures.
•    Assess and review the report performance, come up with performance optimization techniques using VLDB settings and explain plan.
•    Develop scripts to automate the production deployments. 
•    Conduct product demonstrations and user training sessions to business users
•    Work with testing teams to improve the quality of the testing in adopting the automated testing tools and management of the application environments.

Business
•    Collaborate and partner with product owner,  business users and senior business stakeholders to understand the data and reporting requirements of the business and clearly document it for further analysis 
•    Work closely  with architects and infrastructure teams and review the  solutions 
•    Interact with support teams periodically and get input on the various business users’ needs
•    Provide all the required input and assistance to the business users in performing the data validation and ensure that the data and reporting delivered with accurate numbers. 

Processes
•    Process oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices
•    Well versed with agile based project delivery methodology.
•    Should have successfully implemented or delivered projects using best practices on technology delivery and project release automation in banking and financing industry
•    Deployment automation for Oracle Databse and Hadoop , Informatica workflow WorkFlow, Integration, BI layer including MicroStrategy and PBI components to the feasible extent
•    Actively participate in discussions with business users and seek endorsements and approvals wherever necessary w.r.t technology project delivery.
 

People & Talent
•    Minimum 7 years of experience in the business intelligence and data warehouse domain.
•    Create project estimations, solution and design documentation, operational guidelines and production handover documentation
•    Should have excellent technical, analytical, interpersonal and delivery capabilities in the areas of complex reporting for banking domain, especially in the area of Client Analytics and CRM.
•    Full Life-cycle Business Intelligence (BI) and Data Warehousing project experience, starting with requirements analysis, proof-of-concepts, design, development, testing, deployment and administration
•    Shall be a good team player with excellent written and verbal communications. 
•    Process oriented and experienced in onsite-offshore project delivery, using agile methodology and best practices
•    Should be able play an Individual Contributor role

Risk Management

•    Assess and evaluate the risks that are related to the project delivery and update the stakeholders with appropriate remediation and mitigation approach.
•    Review the technical solutions and deliverables with architects and key technology stakeholders and ensure that the deliverables are adhering to the risk governance rules 

Governance

•    Work with Technology Governance and support teams and establish standards for simplifying the existing Microstrategy reports and Informatica batch programs

•    Take end to end ownership of managing and administering the Informatica & Hadoop , MSTR and Power BI.

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.
•    [Fill in for  regulated roles] 
•    Lead the [country / business unit / function/XXX [team] to achieve the outcomes set out in the Bank’s Conduct Principles: [Fair Outcomes for Clients; Effective Financial Markets; Financial Crime Compliance; The Right Environment.] * 
•    [Insert local regulator e.g. PRA/FCA prescribed responsibilities and Rationale for allocation].
[Where relevant - Additionally, for subsidiaries or relevant non -subsidiaries]
•    Serve as a Director of the Board of [insert name of entities]
•    Exercise authorities delegated by the Board of Directors and act in accordance with Articles of Association (or equivalent) 
Key stakeholders

•    Business and Operations (Product Owners)
•    Sales Enablement Client Coverage Reporting
•    Technology Services Teams
•    Production Support Teams

Skills and Experience

•    Design, development of ETL procedures using Informatica PowerCenter
•    Performance tuning of star schemas to optimize load and query performance of SQL queries.
•    Hive, HiveQL, HDFS, Scala, Spark, Sqoop, HBase, YARN, Presto , Dremio
•    Experience in Oracle 11g, 19c. Strong knowledge and understanding of SQL and ability to write SQL, PL/SQL

BI and analytical dashboards , reporting design and development using PBI tools  and MicroStrategy Business Intelligence product suite (MicroStrategy Intelligence Server, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect, MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Integrity Manager, MicroStrategy Office, Visual Insight, Mobile Development
Design of dimensional modelling like star and snowflake schema
Setting up connections to Hadoop big data (data lake) cluster through Kerberos authentication mechanisms
Banking and Finance specific to financial market, Collateral, Trade Life Cycle , Operational CRM, Analytical CRM and client related reporting
Design and implementation of Azure Data Solution  and  Microsoft Azure Cloud
 

Qualifications

<Add relevant qualifications, if required for the role.>

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.