Data Analyst - SHE
Posted a day ago
- Kings Hedges, Cambridgeshire
- Permanent
- Sponsored
- Expires In a month
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
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