About You
• Experience in working with targets and tight deadlines and must be able to manage multiple projects and priorities
• Outstanding Excel skills- comfortable using formulae, pivots, charts and Advance Excel
• Analyses structured data sets from multiple data sources including reviewing data for completeness and consistency and make recommendation
• Strong system analysis skills – data interpretation and explanation of condition, trends etc.
• Ability to create and maintain conceptual/business, logical and physical data models
• Working knowledge on supporting stakeholders through strong communication skills to understand needs and convey responses.
• Knowledge of basic accounting concept
Nice to Have:
• Typically requires a university degree or equivalent work experience. Bachelor’s degree (Finance, Economics, Accounting, Engineering, Business, Mathematics, Statistics, MBA, Computer Science) Have knowledge of data modeling principles including conceptual and logical data models and have the ability to utilize BI tools to represent insights
• Financial modelling experience
• Knowledge of financial theory
Key Experiences and Qualifications
Knowing how to use the Microsoft excel makes it easier to analyze data and find errors.
Fundamental skill set:
o Creating dynamic reports with PivotTables
o Building formulas
o Cell formatting
o Managing large datasets with functions: IF, SUM, INDEX, MATCH, VLOOKUP
o Manipulate date, time, text, and arrays
o Building charts and graphs
o Pivot tables and reporting
o Data recording
o VLOOKUP and XLOOKUP
o INDEX MATCH
o Advanced conditional formatting
o Data simulations / Data validation
o Charts and graphs creation
o Task automation using macros and VBA (Good to have)
o Financial modelling experience
Typically requires a university degree or equivalent work experience. Bachelor’s degree (Finance, Economics, Accounting, Engineering, Business, Mathematics, Statistics, MBA, Computer Science)