Data Specialist

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.

Job Title: Data Specialist

Location: Warwick / Remote

Contract Type: 6 months - possibility for extension

Overview

For a dynamic organisation focused on data-driven decision making, we are seeking a highly capable Data Specialist to join our team in a business-critical role. This position plays a key part in ensuring the accuracy and integrity of data that will directly inform future investment decisions worth billions of pounds and support regulatory submissions.

The role requires an experienced data professional who can hit the ground running, with exceptional Excel expertise and a strong understanding of data governance, accuracy, and regulatory implications. The successful candidate will work independently, and will be accountable for ensuring that all data collected and reported is complete, accurate, and defensible.

This role is responsible for manually extracting, validating, and managing data from approximately 200 individual projects, capturing information directly from project requirements and maintaining it within structured Excel trackers. The accuracy of this data is critical-any errors may compromise the integrity of the submission and call the wider dataset into question.

There is an immediate requirement to keep this data fully up to date as part of ongoing RRP processes, with a hard deadline for finalisation by the end of March.

Key Responsibilities

• Manually extract, document, and maintain detailed project data from ~200 projects using structured Excel trackers
• Ensure all data is accurate, consistent, and fully aligned with regulatory and RRP requirements
• Actively engage with project teams to obtain missing, unclear, or complex data inputs
• Measure, validate, and continuously assess data integrity and quality, proactively identifying and resolving issues
• Develop and streamline Excel-based processes and tools to improve efficiency and accuracy
• Prepare high-quality executive-level reports, dashboards, and presentations
• Produce clear, defensible datasets suitable for regulatory scrutiny and external submission
• Collaborate closely with stakeholders while operating independently and confidently
• Understand and communicate the implications of data errors or inconsistencies on downstream decision-making

Essential Skills & Experience

• Advanced Excel expertise (expert-level formulas, data validation, reconciliation, trackers, large datasets)
• Strong experience with Power Query; limited Power BI exposure is acceptable, but Excel is the core requirement
• Proven background in data accuracy, data integrity, and regulatory or high-risk reporting environments
• Experience working in the utilities sector
• Comfortable manually extracting and managing complex data from unstructured sources
• Strong analytical mindset with the confidence to challenge data quality where required
• Ability to work independently at pace with minimal guidance
• Excellent communication skills, able to engage stakeholders and explain data clearly

Desirable

• Previous involvement in submissions or regulatory reporting
• Experience supporting investment planning, capital programmes, or large infrastructure portfolios
• Background in executive-level reporting and stakeholder engagement

Personal Attributes

• Highly detail-oriented with an uncompromising approach to accuracy
• Proactive, resilient, and comfortable operating under pressure and tight deadlines
• Strong cultural fit with a fast-moving, delivery-focused environment
• Confident self-starter

Please be advised: if you haven't heard from us within 48 hours, then unfortunately your application has not been successful on this occasion. We may, however, keep your details on file for any suitable future vacancies and contact you accordingly.

We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention.