Data Analyst

The role

The client in question has its technical centre in Leeds which acts as an administrative hub to the two sales areas of North and South, these regions are supported by home workers to provide geographical coverage across the UK regional market. Renewal business is transacted via underwriting teams in Leeds.

The client writes business across three business lines of professional and management risks, life sciences and social welfare. Whilst liability led all of these lines include property cover. The successful candidate will work in conjunction with the Senior Business Analyst to manage and support the business with its data requirements.

Key accountabilities

• Monitor, audit data quality & integrity whilst delivering the required data confidence
• Provide consultative advice on all aspects of data and databases to optimise data efficiency
• Mine and analyse large datasets to interpret trends or patterns and present them to management using an appropriate reporting tool
• Liaise with internal and external stakeholders to fully understand data content
• Understand and document detailed business requirements using appropriate tools and techniques to deliver required outcomes
• Create spreadsheets, data dashboards, graphs and visualisations to convey a data-lead story
• Locate and define new process improvement opportunities (automation and simplification) in order to increase reporting efficiency

Skills & experience

Skills

• Have a strong knowledge of SQL queries, data extraction, collation and analysis
• Manage data extraction, collation and analysis generally
• Able to problem solve and have analytical skills able to drive insights out of data
• Be able to communicate clearly around data, with the ability to take complex data and turning this into easily used and understood information for colleagues and other stakeholders
• Be able to manage a number of projects at one time ensuring all are delivered to the required timescales
• Able to communicate and build relationships by telephone, email or video conferencing

Experience is required in

• T-SQL and Sequel Server Management Studio (SSMS)
• Working in a SQL Data Analyst or SQL BI related role
• Using data analysis and dashboarding tools at an advanced level, such as Excel and QlikSense
• Database design / utilisation