Location: Cambridge (CB4)
Duration: Permanent
Hours: 9am until 5:30pm (Monday to Friday)
Salary: Competitive
Job Reference: 35559

Polytec are looking for a highly skilled Data Analyst to join our Cambridge based client's SHE department. The successful candidate will have excellent attention to detail with strong data analysis / manipulation skills. This role will offer a good level of autonomy although you will also be collaborating closely with both the SHE and QA departments.

Responsibilities:

• Gather and check raw data from internal and external digital repositories / portals as well as accounts systems
  
• Update and maintain Excel spreadsheets of Environmental, Safety and QA performance data on a routine basis
  
• Create pivot tables and charts in Excel to analyse and present data and report on observed data findings and associated trends
  
• Update monthly performance dashboards for key performance indicators that are visible to the whole of the company
  
• Create new performance dashboards and supporting Excel spreadsheets
  
• Gather and collate Environmental data for external reports e.g. SECR and ESOS
  
• Create monthly and quarterly MAAR and other performance reports
  
• Work with IT to help enable transfer of existing Excel systems and data to Power BI
  
• Evaluate current processes and improve data analysis and performance monitoring, embracing new approaches to ways of working and reporting, as required, to meet the needs of the business
  
• Ability to create and implement extensive test plans to ensure any new systems or enhancements to existing systems are thoroughly tested
  
  Requirements:
  
  
• Advanced Excel Skills, including capabilities in Power Pivot, Power Query, Pivot Tables, VBA macros, complex formula construction, and dynamic data visualization through charts
  
• Good understanding of Statistical analysis techniques and presentation of data
  
• Excellent attention to detail resulting in rigorous and robust data analysis
  
• Ability and desire to learn new systems
  
• Able to deliver results to required timescales and strive for continuous improvement
  
• Power BI experience would be beneficial
  
  Please contact us as soon as possible for more details or apply below