Duties and Responsibilities

• Integration of new data sources into company databases so that it can be easily consumed, analysed and included in relevant reports.
• Integration of data into relevant workflow processes, with the specific aim of continuously improving what they do and how they do it.
• Continually searching for new and useful ways to obtain, integrate and analyse data that is relevant to the company’s business model.
• Education of report end-users so as to ensure a maximum spread of expertise around the company and promote “self-help” solutioning.
• Development of new report prototypes, data driven analyses and insights.
• Maintenance and enhancement of existing report prototypes, data driven analyses and insights.
• Distribution of report prototypes, data driven analyses and insights to clients.
• Ensure report prototypes, data driven analyses and insights produced conform to the Data Analytics Life Cycle.
• Analysis of data from various sources in order to ensure that the business acts proactively on the information at its disposal.
• Obtaining, manipulating and analysing business data to derive experience assumptions.
• Trend analysis on historical data and deriving information to drive key business decisions.
• Hypothesizing, testing and comparing projected outcomes of scenarios for the growth of existing business and / or the development of new markets and / or changes to existing business rules.
• Highlighting potentially unprofitable scenarios in order to determine remedial action where possible.
• Monitoring of subsequent actual outcomes relative to model assumptions in order to determine likelihood of goal achievement (particularly in respect of new markets) and / or need for changes in tactics and strategy.
• Work with Product Managers and Product Owners in executing project plans or analytical tasks within assigned schedule and timeline.

 Essential Criteria

• Minimum 5 years working experience in a BI Analysis (or similar) role, including experience in data driven analytics and understanding of database structure design and data extraction principle
• Advanced experience with of relational databases, MySQL, SQL, Microsoft Power Pivot, Power Query, OLAP, reporting tools (e.g. MS-Reporting Services (SSRS), Microsoft BI)
• Undergraduate degree (or substantial progress towards one) with majors in math / stats / economics / engineering / actuarial science or similar.
• Highly Proficient in excel (pivot tables, graphs, ability to pull in data from other sources, formulas, functions) or other statistical/analytical tools.

Advantageous

• Experience with VBA, data mining and statistical software such as R, Matlab, Octave, Python, Statistica, SPSS, STATA, etc. will be a strong plus
• Ability to clean, manage, manipulate and use numerical data
• A relevant post-graduate degree will be a strong plus.

• Data Modelling using the Kimball methodology.