Senior Business Intelligence Expert

Job Summary The Senior Business Intelligence Expert specializing in report development is responsible for designing creating and maintaining reports that communicate data insights effectively to Business This includes gathering and integrating data querying and manipulating data designing visualizations and dashboards optimizing performance and providing user training Their goal is to deliver actionable information to Business through welldesigned dashboards reports Key Accountabilities Developing and maintaining the reporting framework which includes defining metrics and data models to support reporting needsDeveloping BI Dashboards for various Business Units including Senior ManagementBeing able to quickly grasp and understand main concepts of different Subject Matters across the Bank Retail and Wholesale banking Risk Finance Ops etcCollaborating closely with business users to understand their requirements and translating those requirements into report logicDesigning reports to effectively communicate data insights including selecting appropriate visualizations and layout for maximum clarity and impactOptimizing report performance by finetuning queries implementing caching mechanisms and ensuring timely data refreshesMonitoring and maintaining existing reports making necessary enhancements based on user feedback and ensuring the accuracy and availability of reports If report has issue then work on that manually until its fixedDocumenting report specifications data sources and report design guidelines in Data Catalogue for future reference and to facilitate knowledge sharingConducting training sessions to educate users on report navigation filtering and interpretation of report data ensuring that the reports are effectively utilized for decisionmakingPromoting overall Data Literacy and DataDriven approach in the BankExtracting Data from DWH and various other sources for Ad Hoc requests Other Accountabilities Agile methodologies Kanban Scrum Strong problemsolving skills Software and Tools knowledge BI Tools Power BI SSRS Cognos and related BI toolsPython for automationRDBMS MS SQL Server PostgreSQL OracleExperience with S3 BLOB Storage SQL Advanced user Stored Procedures Window functions Temp Tables Recursive Queries Familiar with following concepts Data LiteracyData Visualization PrinciplesData Warehousing Star Snowflake schemas Data Lake