Data Analyst SQL

Allegis Global Solutions Limited ,
London, Greater London

Overview

Data Analyst London, EC3M 3BD QBE’s European Operations, which accounts for over 27% of QBE Group turnover, is a leading specialist in London market and European commercial lines business. Active in both the Lloyd’s and company market, QBE offers considerable diversity to the broking community. We are a socially responsible company and give our customers the ability to invest a portion of their premiums in environmentally and socially beneficial projects. The Opportunity Our small and growing analyst team are looking for a highly motivated versatile data analyst to join our Automotive Protection department. We specialise in developing affinity insurance solutions to the global automotive sector. You will be helping to support us, leveraging the rich data on our global portfolio to continue to enhance our MI Platform, analytics, forecasting, pricing and data science capability. You will be expected to get involved in the full end-to-end business data processes , along with a variety of projects that enhance our product offering. The individual will need to demonstrate excellent data mining abilities, analytical skills and very good knowledge of Microsoft applications, particularly MS Access, Excel and SQL Server . You need to be adaptable, enthusiastic and have a strong ability to learn and problem solve. Your Responsibilities For This Role May Include, But Are Not Limited To: Monitoring internationally received data checking for accuracy and reporting exceptions Preparation of monthly statistical key performance indicator reports Designing, developing and enhancing analytics reporting that generates valuable business insights and drives key business decisions Communicating and presenting data derived insights to business stakeholders Supporting the team in migrating our management information platform from MS Access to SQL Server Analysing existing claims and projecting future claims using actuarial forecasting techniques Analysing and reporting on quote conversions on our digital business Forecasting performance and supporting underwriters in pricing Building and documenting regular processes to be handed to the operations team Collaboratively working across the business functions.Liaising with clients, senior stakeholders, IT developers, underwriters, account managers, claims, finance and actuaries Due to the uniqueness of the Automotive Protection account, a definitive role cannot be scheduled. You will therefore need to be versatile, having the ability to adapt to any eventuality that might come about. You should have the ability to think for yourself and act when confronted with unique situations. You will need to be able to display you have the following qualifications and experience: A minimum of a 2:1 in Mathematics, Statistics, Economics or an analytical related degree Excellent knowledge of MS Excel Very good knowledge of MS SQL Server and Access (strong understanding of relational databases and ability to write SQL queries, create reports, forms and macros is a must) Good knowledge of Word and PowerPoint Strong analytical skills - methodical, logical and rational approach to problem solving High attention to detail with the ability to work quickly and accurately Comfortable with interpreting and producing numerical data Excellent written and communication skills.Having the ability to present findings to key stakeholders and clients Ability to operate sensitively in multinational environment and build effective working relationships with clients and key stakeholders across the business Highly organised and efficient. Able to manage own work load, and to deliver high quality outputs within tight deadlines Experience in the insurance industry, particularly the automotive sector will be an advantage Experience with generalized linear modelling techniques and the Emblem software package will be an advantage Experience with other programming languages and tools such as R, Python, Tableau and Power BI will be an advantage At QBE, we view our people as our most precious asset. We understand the importance of fostering a work environment that is responsive to the changing needs of today's workforce. QBE aims to build a workplace that is fair and inclusive because we want to attract and retain the best people to do the job. Search for QBE on Vercida to learn more about our Diversity and Inclusion programmes and policies. This job was originally posted as www.totaljobs.com/job/89409039