Finance Data Analyst - AFR Consulting : Job Details

Our client is seeking a meticulous and proactive Finance Data Analyst to join the team and play a key role in delivering actionable insights through robust sales, customer, and stock reporting. You will be joining a well-established retail and distribution business with a highly successful e-commerce model.

Applicants must live within a commutable distance to attend their offices in Preston, once up and running you will be able to work from home 2-3 days a week.

This position is essential for maintaining data integrity, optimising operational efficiency, and supporting strategic decision-making. The ideal candidate will possess strong technical skills and analytical expertise, with the ability to manage and enhance reporting systems.

Key Responsibilities:

• Prepare weekly sales reports for the management team, ensuring accuracy and timeliness.
• Generate detailed sales and contribution reports to calculate commissions payable.
• Collaborate with the IT team on transitioning from QlikView to a new reporting platform, ensuring a seamless migration and continued functionality.
• Provide ad hoc sales reports and analysis to address specific business needs.
• Track and analyse customer KPI metrics, including lifetime value, conversion rates, trade rates, and lapsed rates, to support management decision-making.
• Monitor and report trends in active customers to inform strategic planning.
• Perform daily stock movement reconciliations using data from warehouse management systems, ensuring accuracy for duty payments and management accounts.
• Produce stock ageing reports to identify and address issues with slow-moving stock.
• Support warehouse operational efficiency through ad hoc stock reporting.
• Manage bi-annual packaging waste levy reporting, staying updated on legislative changes and adapting processes as needed.
• Ensure overall data integrity and maintain alignment of reporting systems with evolving business needs.
• Specify design changes to the data warehouse and accounting system database in collaboration with the IT team

Suitable candidates would ideally have the following skills:

• Proficient in MySQL database administration and SQL Server report writing.
• Expertise in Microsoft Excel, including advanced functions and data analysis.
• Competence in VBA for automating and optimising Excel tasks.
• Strong attention to detail and the ability to work independently or as part of a team.
• Proven capability to manage complex and dynamic data requirements.
• Familiarity with QlikView or Qlik Sense for data visualisation and reporting.