BI and Data Engineer

James Cropper PLC is a world-renowned specialist manufacturer of distinctive and technically advanced materials and products. Based in north-west England with locations around the world, we use materials from cotton and wood to carbon fibre to develop innovative and ground breaking solutions for a diverse customer base. We are renowned globally for colour expertise, dedicated responses to challenging custom projects and an award-winning commitment to the highest standards of sustainability.

This is a fantastic opportunity to join a rapidly-growing listed company with more than 175 years of heritage that thrives on innovation. An international business of over £100 million across its three divisions of Paper, Technical Fibre Products and Colourform, it serves markets in over 50 countries.

The BI & Data Engineer will liaise closely with internal customers across all functional areas to deliver data and data analysis solutions. They will be passionate about data and the value great data brings. They will have a good understanding of the entire data environment and processes, ensure that databases perform to their maximum capability and provide the highest levels of availability & data integrity.

The role will also assist with creating dashboards & data sources with our business to maximise proficiency and productivity throughout the company.

As the job evolves and self-sufficiency amongst data users grows, this role will likely act more as a data and technical advisor to the business rather than a solution provider.

Key Accountabilities:

Database Administration, Design and Optimisation
Bespoke Data and Process Knowledge
Dashboard Creation
Manage the Business Intelligence Tool
Continuous Improvement
Review and Validate Data
Develop Best Practice Policies and Procedures
Training and Communication


The successful candidate will possess the following;

Key skills include advanced development skills (SQL, Python, Powershell).
SQL Server skills, including SQL objects development, performance tuning, data analysis and SQL Server Integration Services (SSIS).
Data modelling, analysis, reporting & presentation.
Advanced analytical and problem-solving skills.
BI development experience (preferably QlikView, Qlik Sense, Power BI).
Proven experience in analysing, cleansing and transforming source data from multiple sources to bring enhanced end-to-end process visibility. Advantageous experience in integrating Machine Learning, Business Process Automation data.
Demonstrable evidence of advanced Excel knowledge, including data handling and manipulation techniques such as lookups and pivots. VBA is an advantage.
Ability to translate complex requirements into effective solutions to enable business processes & operations.
Knowledge of Data Hygiene, Data Management and Data Processing best practices and regulations

If you would be interested in working for James Cropper PLC, please send a CV and covering letter to recruitment@cropper.com or apply via our careers page on the company website, www.jamescropper.com.

Closing date: 16 December 2022

Why James Cropper PLC?

James Cropper is a specialist paper and advanced materials manufacturer in north-west England with a strong ambition to grow in its chosen markets. This is a fantastic opportunity to join a rapidly-growing listed company with more than 175 years of heritage that thrives on innovation.

A business of around £100m, it has important market shares in the USA, China, the Far East, Europe and the UK. We are renowned globally for colour expertise, dedicated responses to challenging custom projects and award-winning commitment to the highest standards of sustainability.