The role of Business Intelligence Lead is pivotal to the development of the Business Intelligence (BI) capability of the group. Ensuring BI is developed and delivered from a Group perspective, maximising the value from, and ensuring the quality of all BI dashboards and reports.Working closely with the Group IT Team, Senior Finance Team, and other Support functions such as HR, as well as operational managers to ensure that it is possible to track and then present KPIs effectively across the Group.• Operational ownership and design input for the Group analytics data warehouse.• Group BI platform owner, developing connections to new systems as required including associated updates to the Group data warehouse.• Working alongside the Finance Business Partners, HR team along with Senior Operational managers, to automate the production of key reports and KPIs displaying these in interactive dashboards.• Visible within the business to build a profile of support and understanding.• Ensuring the dashboard, reporting and design process uses the most appropriate formats to gain maximum user engagement and insight.• Ensuring the data integrity of all reports, dashboards, and analysis.• Actively seeking opportunities to add value where possible.• Maintaining a strong relationship with our Support Partner’s through quarterly review meetings.• Sharing knowledge to those using reports, enabling them to self-serve and develop ad hoc reports confidently where relevant.

• Work closely with Business Partners and Stakeholders, helping to establish requirements• Migration of existing Excel reports to PowerBI and fully automate datasets using Azure• Statistical Forecasting predictions using R for individual channel owners• Assess requirements, designing solutions with reference to the strategic objectives of the Marketing Team• Deliver into UAT, supporting Business Partners with roll-out, including end user training, testing and sign-off• Creation of the new Live Operating Plan (LOP), this enables Budget/forecasting analysis across the company• Commercial decision proposal and budget allocation based on insight trends• Assisting reports for customer profiling | training to use Fast Stats• Training, mentoring, supervising members of the BI team• Full responsibility of the BI team for design, development and management• Utilising the latest technologies available, designing and building data solutions to meet business needs• Constantly seek out better ways to do things, new tools, new technologies, new processes• Continue on improving ETL processes and establish a new methodology where required• Working closely with IT to identify SQL issues and performances within the Marketing Databases, use of SQL Management Studio and SolarWinds

• Business Intelligence – the development and distribution of all marketing reports and dashboards across the Marketing sub-divisions (PR, Communications, Web Digital);• Being proactive in identifying opportunities to improve the business intelligence service, and contribute to the staff development initiatives;• PowerBI presentations deployment to the heads of dept;• Extracting, preparing and analysing large data sets via hands-on SQL querying and ETL Tools to validate campaign selection and post campaign evaluation, customer segmentation/profiling and Marketing performance;• Utilising querying and analysis to create practical customer segments, introducing customer strategies to move customers up through segments;• Manage data processing, analysis and delivery via 3rd Parties (e.g. Google Analytics);• Implementing statistical analysis and forecasting analysis on post-performance data;• Designing and maintaining analytical and reporting tools to audit and maximise utilisation of available data;• Assisting the Data Planning Manager in the reviewing and development of the contact strategy for all customer touch points (using SQL and ETL tools);• Work with IT to optimise data quality and management and ensure relevant data quality measures and processes are in place.

• Support delivery of insurance & client management services to internal & external clients;• Creation of Business Intelligence reports for various different NCC departments;• Use of SharePoint to migrate existing data/documents from FigDocs;• Rework legacy spreadsheets for consistencies;• Using MS Excel to manipulate and analyse data – including reporting;• Regularly creating and altering PivotTable tables presenting various data insights;• Developing procedures for cleaning data and ensuring data quality;• To assist and support the Insurance and Client Officer and Insurance Manager with all aspects of the insurance renewals process that takes place annually.

• Implementing network security measures to protect data, software and hardware;• Extensively using SQL to query large datasets and developing efficient SQL queries as well as query templates to perform complex calculations and produce reports;• Loaded data into the data warehouses using the ETL Tool, SQL scripts and complex Excel formatting;• Organising SQL data warehouse tables and mapping;• Used statistical analysis to identify failure points and data errors;• Update PC/Servers hardware, SQL server & SSRS;• Resolving data latency issues on server;• Training up end users at their place of work;• Investigating problems and then making technical/financial recommendations;• Providing phone/Remote Desktop Support.

Project managed a new Statistical/financial database. This involves forecast modelling of Sales/NSV SKUs. Creation of forecast models using various data sources and analysed current source codes used.Duties:• Exceeded expectations of creating a statistical/financial database – Project managed entire range of products (approx. 850 SKU);• Designing and generating weekly statistical forecast reports, KPI’s & Dashboards;• Establish and utilise best methods (statistical models and software tools) in creating forecasts and respective inventory targets;• Analyse SQL queries to make extractions more efficient;• Manipulating, cleansing & processing data using Excel, Access and SQL;• Prepare, report, and communicate forecast and inventory measurements to management (forecast accuracy, inventory plan vs. targets);• Performing daily system checks;• Supplying qualitative and quantitative data to colleagues & clients using COGNOS;• Relating and measuring the impact of forecast accuracy;• Evolving and maintaining documentation and standard operating procedures for demand planning processes and systems;• Assemble and analyse all data pertinent to creating the sales forecast (historical sales, market trends, seasonality and promotions);• Make recommended adjustments to forecast and inventory targets based on changes in demand and market trends.

Provided statistical expertise on various funded/unfunded projects, as well as the design of presentations for clients.Duties:• Carry out complex statistical analyses of study outcomes (SAS/SPSS) and assist in the interpretation of results;• Co-author of published papers;• Statistical modelling skills and the ability to interpret and communicate analysis results;• Project reports for world leading pharmaceutical companies;• Statistical Analysis Plan (SAP) for the upcoming short projects;• SQL extractions from CPRD (Clinical Practitioner Research datalink) & OPCRD (Optimum Patient care research database);• Involved in over 20 different observational database studies, primarily using data from the CPRD (formerly GPRD);• The ability to work in a multidisciplinary team;• Statistics reporting process through the specification and review of tables, writing and review of derived datasets;• Developments of larger studies to compare the effectiveness, cost-effectiveness and direct healthcare costs of managing COPD in patients with evidence of COPD;• Maintaining knowledge in design consultancy and analysis methodology, statistical software packages and regulatory guidance documents;• Make statistical contributions to manuscripts for publication / presentation.

Designing, developing, testing, implementing and maintaining database systems, and for working closely with other IT professional’s to diagnose and troubleshoot applications and database-related issues.Duties:• Database application development;• Writing T-SQL scripts to manipulate data for data loads and extracts;• Distribution statistics for third party companies;• Creation of Pack Redemption reports via the use of Viper (Database);• Anecdotal Stats progression to coincide with Bounty UK’s monthly performance;• Project work for the integration of database management into Bounty’s internal Intranet system;• Ad-Hoc queries including one off stats report, development of small apps requested by other team members;• Regular development of Delphi application (training).

• Rate review including Product Writer building and monthly analysis;• Involvement in statistical analysis of the volume of commercial businesses which comes through market standard I-market portal and creation of business forecast;• Delivery of performance status information and reporting packages to various departments for analysis;• Error resolution of XML data and VB codes including Product building in Product Writer®;• External testing at Software Houses (SWH) for Commercial, Household & Motor;• Part of the training team, I train colleagues in MS® Excel, Product Writer® and Templator®;• Consultation/Project Management on projects between different departments e.g. Pace 5 and Geolf;• Delivery of Test packs internally within EDD & Externally to DP, Underwriters and Pricing;• Assist daily in ECF errors and SWH issues relating to the product I’m assigned to;• Creating and rebuilding commercial Test packs in MS® Excel for I-market electronic trading.