Data Analyst at AB Microfinance Bank

Main Responsibilities:

• Responsible for the usage of statistical methods to analyze data and generate useful business reports using Microsoft office tools
• Scorecard Data Monitoring and reporting
• Analyze data in support of business cases and proposed projects by departmental managers.
• Identify and interpret patterns and trends, assess data quality and eliminate irrelevant data.
• Communicates the results of the analysis as a comprehensive report to decision makers and others affected by the results.
• Designs the report and includes tools that can help those involved easily digest the data, such as statistics, graphs, images and lists.
• Advice on the best methods to collect, analyze and manage data to improve data quality and the efficiency of data systems.
• Analyze data for customer segmentation
• Perform Gap Analysis on a quarterly basis on business processes which is has a great influence on data.
• Prepare, deliver reports, and provide recommendations of alternatives that address existing or potential trouble arears in the business.
• Contribute in diverse ways to the improvement and growth of the Company. Collaborate with departmental managers to outline the specific data needs for each business method analysis project

Necessary experience and knowledge:

• Minimum education qualification of  B.Sc. / HND in Statistics or Mathematics
• Minimum of 2 years data mining experience
• Expert Knowledge of Microsoft Office especially with R – Programming, Excel, power point, Power BI, SPSS etc.
• Excellent Analytical Skills
• Communication Skills
• Attention to details
• Good presentation skills

Desired Technical Skills:

• Advanced knowledge of Microsoft Excel with emphasis on:
• Functions and Formulas (including V-look up, H-look up, Sum IF etc.)
• Extensive practical knowledge of Pivot Tables to analyse big data
• Data Validation
• Data Storage and Security
• Dash Board Creation
• Presenting bulk data in graphs and charts in a clear manner
• Excellent analytical capabilities , ability to draw conclusions from analysed data
• Knowledge of SQL
• Ability to write basic SQL queue
• Knowledge of Common Data Sources
• Knowledge of SQL Server Databases
• Knowledge of SQL Server OLAP, dimensions, Fact Tables etc.
• ·Advanced Power Point knowledge (transparent illustration of quantified data)