Data AnalystBroll

• A successful Insurance Data Analyst will possess excellent technical and mathematical skills, to manipulate data and derive analyses. Most importantly the ideal candidate will possess a sense of inquisitiveness about data, and the ability not just to find patterns in data, but to also understand what they mean.
• You will work directly with our Personal Insurance lines of business, reporting into Head –Accident & Health – Sub Saharan Africa. 

ESSENTIAL FUNCTIONS AND BASIC DUTIES

• Use computer software to evaluate insurance policies to determine the risks for a policyholder and AIG.
• Understand the structure of insurance datasets and be able to analyse and manipulate Insurance data.
• Calculate persistency and loss ratios and other key performance indicators of the insurance portfolio.
• Understand, create, modify, and execute computer programs to extract, transform and summarize data, as input to derive analyses and reports.
• Review the quality of data, both in transactional detail and in aggregate, and correct errors.
• Understand and take ownership of our business processes, and recommend improvements in data management, error identification, quality control, process automation, or analytic techniques.
• Create clear and easy to understand reports. Present your analyses, ideas, progress and results to internal manager and colleagues.
• Write SQL scripts to provide accurate and timely system reports to clients, colleagues, management on an ongoing basis. Identify and correct discrepancies on such reports.
• Extract various marketing data from the data warehouse when required also using SQL scripts.
• Submit and follow-up on change requests to IT, including testing of such changes to ensure correct implementation.
• Automate current manual processes to ensure consistent and timely processing and reporting.
• Ensure timelines and service levels are maintained.
• Assist with administration of database and operating systems.
• Assist with the development and implementation of automated processes to replace the current manual marketing campaign set-up and associated operations.
• Assist with the development and implementation of automated reports.
• Carry out ad-hoc data extractions when necessary for reinsurers. reporting, analysis, and campaign purposes.
• Assist with warehousing of data in SQL server and engaging with Barnowl.
• Regular analysis and testing of data in QuickStart for consistency and accuracy, as well as assisting with the correction and prevention of inconsistencies found.
• Supplying Direct Marketing with leads/data/records for campaigns including post campaign business mix reporting, propensity to buy models and target market sets per product
• Cleaning data supplied by sponsors and using de-duping rules and requirements processes.
• Facilitating the process (from request to delivery) when reports are required from and run for business lines
• Overall MIS technical systems support to the Personal Insurance business.

QUALIFICATIONS & EXPERIENCE

• Graduate or bachelor’s degree with a major in Mathematics, Data Science, Statistics, Economics, Risk Management, Operational Research or related discipline, or equivalent professional experience.
• Fluency in English is required.
• Knowledge of Insurance Industry concepts and experience working in the Insurance Industry
• Practical experience in quantitative and qualitative data analysis, using tools such as SQL, Python, R or SAS.
• Technical background should include a working knowledge of MS Office applications (Word, Excel, Access, Powerpoint) and understanding of computer programming concepts.
• Other advantageous experience:
• Experience with large (>100,000 row) datasets or datasets of mixed quality.
• Data visualization software such as Tableau, Spotfire or COGNOS.
• Familiarity with Personal Insurance coverages and data
• Using VBA to automate tasks in Microsoft Office
• Ability to work independently and as part of a team.
• Strong verbal and written communications skills, listening and teamwork skills, and effective summarization skills.
• Detail-oriented technical aptitude with strong logical, problem solving, and decision-making skills.
• Excellent organization/planning skills and talent for managing many large and complex datasets.
• Aptitude in performing multiple tasks and dealing with changing deadline requirements. This includes knowing when to escalate issues. Maintains a focused, flexible, organized, and proactive manner. ?
• Minimum 2-3 years working experience (minimum 1 year as a Business Analyst) preferably within the financial services environment.
• Practical experience on working with Salesforce.com.
• CRM Application Basic Salesforce.com configuration expertise.
• Any project management experience is a plus.
• Ability to generate reports using any Business Intelligence Tools.