OUR PLACEMENTS

Placement summary

First Milk Ltd have an outstanding graduate opportunity which would be perfect for someone keen on deploying recently acquired computing science skills on a key business project. The focus will be on reviewing our business-wide reporting with a view to implementing a complete shift in capability, while utilising the advantages offered by modern cloud based solutions. This is a 12 month placement and will be based at our UK head office in Paisley.

Job description

Project Description

Following a period of business change, it has been identified that the reporting and Business Intelligence capabilities are deficient and do not currently satisfy the requirements of the business from operational through to management level.

Phase one will build a suitable data access layer, which will be constructed to consolidate the various data sources identified for reporting. This will be a common dimensional data model suitable for use on a variety of technologies.  Following the construction of this model, phase two will require evaluation of suitable business intelligence and reporting platforms spanning our existing platform to the newer and more advanced cloud based offerings.  Once evaluated, it will extend to a re-development and implementation of new (and existing) reporting dashboards/reports on this new platform.

This project aligns to our newly proposed IT strategy which governs the stability of software platforms used within the business to ensure future capability and support, while exploiting cloud based technologies. The introduction of an effective business reporting solution will greatly aid the capabilities of management decision making.

The overall aim of this project is to enable the provision of ‘one-touch’ availability of highly complex data in the form of a multi-tier reporting suite. There will also be significant efficiency gains, as existing reporting is a slow and inaccurate process with a heavy reliance on manual reporting based on data extraction.

The new technology also offers additional benefit to be explored around the real-time analytics domain which could be used to report on real time telemetry from factory equipment – thus improving overall equipment effectiveness.

Placement Objectives

This placement will provide support on a business-wide reporting refresh project. This will cover data analysis and design of First Milk data assets and will also involve building common data models which can be used as a single point of reporting across our business at various levels of management.

Role Description

Main Tasks:

Data Modeling:

• Construct and populate data models based on business functional areas
• Deliver data models according to agreed business standards

Business Intelligence Design:

• Build dashboards showing key business reporting metrics

Data Extraction:

• Extract data accurately from multiple lines of business systems

Technical:

• Extract data from Oracle databases

Project Management:

• Provide updates to project stakeholders relating to progress versus plan

Qualifications

Degree qualified in Computing Science would be ideal for this role.

Skills / Experience

Essential Skills

• Proficient in database design and dimensional modeling concepts
• Exposure to Oracle technology stack
• Able to work on own initiative, following basic direction and specifications
• Exposure to analytical processing

Expected behavioural competencies:

• Driven: Focused and determined to achieve successful outcomes. Is a self-starter and takes initiative in situations
• Smart: Goes beyond professional knowledge to demonstrate sound commercial judgement. Generates creative innovative sustainable business solutions
• Influential: Wins hearts and minds to gain commitment to act, is respected by colleagues and seen as role models by others. Is tactful and diplomatic, ensures culture of confidentiality and trust is maintained
• Agile: Adapts style and behaviours to business demands, learns quickly and is energised by change – demonstrated can do will do attitude
• Customer Orientated: Dedicates self to meet customers’ expectations, proactively seeks feedback and uses it to continuously improve service and support. Takes ownership for building and maintaining effective working relationships
• Communication: Makes communication a priority to ensure no surprises. Clearly communicates and seeks inputs regarding ideas, plans and priorities.
• Collaborative: Proactively builds knowledge capability through sharing knowledge, ideas and expertise with colleagues and wider business. Works for the benefit of customers, suppliers and stakeholders
• Operational Excellence: Identifies and implements opportunities to maximise efficiencies and outputs, seeks to deliver consistent results through focusing on continuous improvement and bottom line results

Desirable Skills

• Knowledge of business process management in a large organisational environment
• Ability to deliver technical information to non-technical audience
• Can identify and challenge inefficiencies with a view to providing a technical solution
• Keen to develop knowledge of new and emerging technologies

Benefits

Placement benefits

As part of the ScotGrad Graduate Placement Programme, you may have access to a tailored graduate business skills training course. ScotGrad placements also offer a unique opportunity to connect with a vast network of graduates and ScotGrad alumni. All graduates appointed through the programme are encouraged to make use of the ScotGrad LinkedIn group to communicate with other ScotGrad participants, learn about any professional development opportunities and build up a professional network.

Additional information

Location: Paisley

Planned interview date: TBC

Preferred start date: 25th July 2016

Company information

First Milk Ltd is the UK's only major dairy company, owned by British family farms.

We supply the retail, foodservice and milk markets with a wide range of dairy products and ingredients, in the UK and internationally.

Company website: http://www.firstmilk.co.uk