Data Analyst

William Huston Photography; Exeter; On-site; GBP 30,000 - 50,000

Job description

We are searching for a Commercial Reporting Analyst / Commercial Data Analyst for an exciting and very secure business based near to Exeter.

The position is initially offered as an office-based role.

This is a key support role in which you will be delivering accurate reporting and data to help drive the business forward.

The successful candidate will be responsible for understanding our client's product portfolio, calculating pricing, and reviewing margins.

You will also look after data management for key systems across the group, helping to develop dashboards as well as taking a lead in the projects assigned to you.

In this role you will be responsible for reviewing, developing, and delivering reporting and dashboards using SQL, VBA, Power Query, Power Pivot and any other available forms of data extraction, data modelling and data/reporting platforms.

You are going to be involved in projects which aim to streamline all reporting around the business, helping to generate improvement opportunities which will benefit stakeholders globally.

The senior management team is keen to expand data-driven performance analytics and by improving the reporting processes and capability of all departments it will assist in developing a factually based, scientific approach to continuous improvement.

Main Duties:

• Build, develop and maintain data models, reporting systems, data automation systems, dashboards and performance metrics that support key business decision-making.
• Manage and optimise processes for data intake, data validation, data modelling, data visualisations, whilst communicating deliverables to all involved.
• Project management, tracking the development of projects and delivering results on time as outlined in project proposals.
• Management of price lists and pricing analysis. To apply pricing increases and create new product price lists for internal and external distribution.
• Management and review of Product Lifecycle in accordance with obsolescence process, and stock write off procedures.
• Ad-Hoc internal process review management to streamline business practices and improve accuracy and efficiency for wider business roll out.

To be a success in this role you require the following:

• Excellent written and verbal communication skills.
• Advanced level knowledge of Excel (used extensively).
• Good knowledge of Power Query and Power Pivot.
• Comfortable working with SQL & VBA.
• Ability to work under pressure and meet tight deadlines.
• Numerate & Analytical - experience of working with costing, turnover & margins.
• A dynamic and proactive self-starter.
• Highly organised.

Desirable Skills:

• Experience in the use of Content Management Systems.
• Knowledge of CRM Systems.
• Knowledge of SOP Systems.
• Knowledge of Warehouse Management systems.

Please note, to be considered for this role you MUST have the Right to Work in the UK without Company Sponsorship.

You will also need to be located within a commutable distance of Exeter Airport / Sowton as the role is 100% office-based throughout probation.

KEYWORDS:

Commercial Reporting Analyst, Commercial Data Analyst, Business Analyst, Reporting Analyst, Pricing Analyst, Excel, SQL, VBA, Power Query, Power Pivot, Dashboards, Reporting.

Please note that due to a high level of applications, we can only respond to applicants whose skills and qualifications are suitable for this position.

No terminology in this advert is intended to discriminate against any of the protected characteristics that fall under the Equality Act 2010.

Bowerford Associates Ltd is acting as an Employment Agency in relation to this vacancy.