Spl'st, Development

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 28021