*Fully office based in Chelmsford, Essex*
Job description:
Due to continued growth, Award Winning Commercial MGA, Direct Commercial Ltd has an exciting new opportunity for a MI Analyst to join the IT team based in Chelmsford.
As our Data Analyst, your role will be key in supporting the Business by providing timely and regular reports crucial in making data-driven decisions at all levels of the organisation: at Team Leader level to Managers and all the way to senior executive Management layer. You’ll be required to provide insight to the senior management team and analyse data that feeds into our various re-insurance partners.
Due to the diverse group of stakeholders who will be consuming your reports, the expectation is that you have outstanding verbal and writing skills in translating complex data and insights to a non-tech audience.
You will report to the Data & Analytics manager team in supporting them directly on their analysis and report generation across the business.
The role is wide ranging as you will be responsible for diverse areas such as trend analysis based on historical claims and underwriting data, forecasting development of claims spend and future incurred positions, building and maintaining multiple internal and external reports capable of identifying leakage and exerting controls across all areas of the organisation.
The role will be office based in Chelmsford.
Key duties include, but are not limited to:
Develop reporting material for stakeholders including the Senior Management Team, maintaining a database of MI to ensure consistency of reporting.
* Maintain the integrity of the MI Process with detailed review and data cleansing to ensure all data and reports are accurate, current, complete and consistent.
* Handle and maintain existing monthly suite of reports, looking for improvements where necessary.
* Have great adaptability in handling data of either internal or external sourced views where extra cleansing / manipulation is needed for data preparation on analysis projects.
* Review data processes, suggest and implement improvements and solutions.
* Extract bespoke data queries/ extracts via SQL to provide stakeholders with key data requests and KPIs.
* Pro-actively support the senior management team to reach defined performance targets.
* Prioritisition of regular and ad hoc reporting to satisfy external and internal needs.
* As and when required be prepared to be involved in data related projects that will contribute to the overall improvement changes within the business.
* Identifying own development area’s and increasing your knowledge and capability standards for succession.
* Identifying trends and key focus areas on historic claims data, forecasting development of claims spend and future incurred positions
* Input performance forecasts and targets through scenario modelling and trend analysis.
Essential skills
* Expert knowledge of MS SQL or other data analysis/mining tools.
* High degree of IT literacy, specifically around Microsoft Excel, Power Pivot & Power BI.
* Ability to interpret patterns in data and articulate insights to others.
* SSRS reports.
* VBA and Macros via Excel.
* Experience working with a variety of analytical tools and methodologies.
* Degree educated or lengthy experience in the required field.
* Power BI, dashboard experience.
* Microsoft SQL experience 3-4 years minimum.
Desirable skills
* General understanding of Insurance industry practices & principles.
* Python
A successful candidate must have / be:
A proactive self-motivated, logical and organised team player with the ability to work independently with minimal supervision, manage a high personal workload under pressure of deadlines whilst continually strive for improvements in quality, efficiency, and presentation.
Excellent analytical and problem-solving skills.
Experience interpreting and manipulating data and large volume data sets.
Excellent verbal and written communication skills, particularly in the presentation of complex data and analytical findings to non-technical audiences.
Highly numerate & analytical with excellent attention to detail.
Understanding of the constraints of using sensitive and confidential data.
Actively exhibit and develop professionalism at all times and respect confidentiality where required by the business and others.
Have a can-do attitude, attention to detail, able to spot irregularities and challenge them.
Pre-employment checks:
Any employment with Direct Commercial Ltd will be subject to background screening checks prior to a start date.