Systems Integration, Workflow Audit & Management Information Project

About The Business: Frameline Ltd is a UK manufacturer and supplier of aluminium windows, doors and glazing systems for the construction sector. The business supports a range of commercial and residential projects and uses systems including Sage 50 and Business Micros to manage sales, purchasing, production and finance activities. As the company continues to grow, it is looking to improve operational visibility, data management and reporting to support more effective decision-making and future digital transformation.

Overview: Frameline currently uses a combination of business systems, spreadsheets and manual processes to manage key operational activities. The business has identified opportunities to improve data visibility, streamline processes and enhance management reporting. Before investing in major system changes, Frameline wants to better understand how information flows through the organisation and identify practical opportunities for improvement. This internship will focus on reviewing workflows, assessing system usage and data quality, and supporting future digital transformation initiatives

Desirable Skills: Strong analytical and problem-solving skills. and the ability to work confidently with data and spreadsheets.

Job Description:

This internship will focus on understanding existing workflows, assessing system usage and data quality, and developing practical reporting tools that improve operational visibility and support future investment decisions. 

This project focuses on understanding and improving the flow of information between business processes, people and systems to support better decision-making and future digital transformation initiatives.

Project Goals and Objectives

Objective 1: Document the current workflow and information flow across sales, purchasing, stock management, production and finance activities within the first three weeks of the internship.

Objective 2: Assess the quality, accessibility and usage of operational data across key business systems and produce a data improvement report by Week 5.

Objective 3: Identify and evaluate opportunities to improve the flow of information between systems, departments and business processes, producing a prioritised improvement register by Week 6. 

Objective 4: Design and develop one to two prototype management dashboards that provide visibility of agreed operational KPIs by Week 7.

Objective 5: Produce a 12-18 month Digital Systems Improvement Roadmap outlining prioritised recommendations to improve reporting, data management and system integration by the completion of the project.

Scope of Work, Methods, and Tools

1. Workflow Audit and Process Mapping
The intern will:

  • Engage with key stakeholders across the business.
  • Map current processes across:
    • Sales, Purchasing
    • Stock control
    • Production administration
    • Finance
  • Identify: 
    • Manual activities
    • Duplicate data entry
    • Information bottlenecks
    • Areas where information is difficult to access
    • Reliance on spreadsheets or workarounds

Output: Current-state workflow maps. Workflow improvement observations.

2. Systems and Data Review 
The intern will review how key business systems are currently used and how data is managed.
Activities will include:

  • Reviewing operational data sources.
  • Assessing data quality and consistency.
  • Identifying duplicate, missing or obsolete records.
  • Understanding how information is shared across departments.
  • Identifying opportunities to improve data governance and ownership.

Output: Data quality assessment report. Data improvement recommendations.

3. Information Flow and Integration Assessment

The intern will:

  • Document how information currently moves between systems and departments.
  • Assess opportunities to reduce manual handling of information.
  • Identify where automation or better integration could improve efficiency.
  • Evaluate potential future integration opportunities.
  • Note: The internship will assess and recommend improvements but will not implement system integrations.

Output: Information flow map. Prioritised systems improvement register.

4. Management Information Dashboard Development

The intern will work with management to identify key performance measures and reporting requirements. Potential dashboard areas may include:

  • Inventory visibility
  • Purchasing activity
  • Sales performance
  • Production throughput
  • Delivery performance.
  • Using available reporting tools such as Power BI or Excel, the intern will create one to two prototype dashboards to demonstrate improved operational visibility.

Output: Prototype management dashboards. Dashboard user guide and recommendations.

5. Digital Systems Improvement Roadmap

Drawing on the findings from the project, the intern will develop a practical roadmap covering the next 12-18 months.

The roadmap will:

  • Prioritise quick-win improvements.
  • Identify medium-term opportunities.
  • Highlight future integration requirements.
  • Recommend actions to improve reporting and data quality.
  • Support future technology investment decisions.

Output: 12-18 month Digital Systems Improvement Roadmap.

Timeline with Milestones

Week Activity Output

Week 1 
Project initiation and stakeholder engagement 
Project plan and stakeholder map

Weeks 2-3 
Workflow audit and process mapping 
Current-state workflow maps

Weeks 4-5
Systems review and data assessment
Data quality assessment report

Wekk 6
Information flow and integration assessment 
Systems improvement register

Week 7
Dashboard development and testing
Prototype dashboards

Week 8
Roadmap development and final presentation
Final report, roadmap and presentation

Intern Roles and Responsibilities

The intern will:

  • Engage with stakeholders to understand current processes.
  • Document workflows and information flows.
  • Review data quality and system usage.
  • Analyse operational reporting requirements.
  • Identify opportunities for process and systems improvement.
  • Design and test dashboard prototypes.
  • Produce recommendations and future roadmap documentation.
  • Present findings and recommendations to management.

Intern Skills Required

Essential

  • Strong analytical and problem-solving skills.
  • Excellent communication and stakeholder engagement abilities.
  • Ability to work confidently with data and spreadsheets.
  • Strong organisational and documentation skills.
  • Attention to detail.
  • Ability to present findings clearly and professionally.

Desirable

  • Experience with Power BI or similar reporting tools.
  • Knowledge of process mapping techniques.
  • Understanding of business systems or ERP software.
  • Interest in manufacturing operations and digital transformation.
  • Basic data analysis skills.

Expected Outcomes and Success Metrics

 Business Outcomes

  • Improved understanding of how information flows through the business.
  • Greater visibility of operational data.
  • Identification of opportunities to reduce inefficiencies and duplication.
  • Better understanding of future system integration requirements.
  • Improved management reporting capability.
  • Clear evidence to support future digital investment decisions.

Success Metrics

  • Completion of workflow maps covering core business processes.
  • Completion of a systems and data quality assessment.
  • Identification of priority improvement opportunities.
  • Delivery of one to two operational dashboard prototypes.
  • Production of a prioritised 12-18 month Digital Systems Improvement Roadmap.
  • Final presentation delivered to management team.

Key Deliverables

  • Workflow Audit and Process Maps.
  • Systems and Data Quality Assessment Report.
  • Information Flow and Systems
  • Improvement Register.
  • One to Two Prototype Management Dashboards.
  • Dashboard Guidance and Recommendations.
  • 12-18 Month Digital Systems Improvement Roadmap.
  • Final Presentation and Handover Report

 

Active
Details

Location: Liverpool

Duration: 300 Hours

Salary: £13.45

Start Date: 02/Nov/2026