Business Intelligence Analyst

Analyse large amounts of raw information to independently undertake various analytics exercises. We will rely on the resource to build data products to extract valuable business insights. In this role, the candidate should have high analytical skills and high proficiency in BI tools. Critical thinking and problem-solving skills are essential for interpreting data. The candidate is expected to design, implement and maintain efficient BI solutions to enable the business groups to derive insights and make better decisions.Key Tasks & Duties Principal Accountabilities:Designing and implementing data model, database structures for building BI reports and dashboardsSQL programming, data modeling, ETL (Extract, Transform, Load) processes using SAP Data ServicesCreating and optimizing SQL queries, stored procedures, and functionsDesigning and building interactive reports, dashboards, and visualizations using BI ToolsCollaborating with business users to understand requirements and deliver BI solutionsMonitoring and optimizing the performance of databases and BI solutionsEnsuring data security and implementing access controlsTroubleshooting data-related issues and providing timely resolutionsResponsible for data retrieval and analysisDocumenting technical specifications, data processes, and solutionsKeeping up-to-date with industry trends and emerging technologies in BITeamwork: Work collaboratively with own immediate team. Establish trust and confidence with the business partner teams. Liaise with key stakeholders on MIS related activities and deliverables.Communication: Work with the team to communicate the reports/outputs to the business teams effectivelyKnowledge, Skills & Competencies Required:Expertise in SQL programming, data modeling, ETL (Extract, Transform, Load) processes, using SAP Data ServicesProficiency in data visualization tools (SAP BO, Qlikview etc.) in an enterprise environment is critical to develop insightful reports and dashboardsProficiency in data modelling and data schemasUnderstanding of performance tuning, indexing, and data security for optimizing BI solutionsProficiency in concepts like database design and data warehousing conceptsUnderstanding database operations and optimization for Oracle DB, Microsoft SQL Server etc.Understanding data and query optimization, query profiling, and query performance monitoring tools and techniquesCreating and maintaining business requirements and other technical documentationAbility to analyze data trends, patterns, and anomalies to provide actionable insightsUnderstanding of data security practices and implementation of role-based access controlsFunctional:Ability to understand and translate business requirements into effective BI solutionsStrong communication skills to collaborate with business users, data analysts, and other stakeholders to gather requirements and present findingsSkill in identifying data-related problems, troubleshooting issues, and devising effective solutionsUnderstanding of the banking sector domain knowledge, especially retail banking (customer, transactions, network and e-channels) is a must. Exposure to corporate banking, Islamic banking and other institutional business will be an added advantage.Capability to document data processes, data dictionaries, and technical specifications for BI solutionsBasic skills to plan, prioritize tasks, and meet project deadlines