Data Analyst

Data Analyst - 3 Month Fixed Term Contract Company Overview Established in 2006, FluidOne is an award-winning provider of secure Connected Cloud Solutions with a £110m turnover and consistently one of the highest Net Promoter Scores (NPS) in the industry. FluidOne has a strong company culture enjoyed by 460 staff and was ranked in the UK top 50 large companies to work for in the Best Companies awards 2023. FluidOne supports the needs of 2,000+ customers, and 200 channel resellers, with IT and Cyber Security managed services underpinned by connectivity and communications solutions. As AI becomes a core enabler of innovation, FluidOne’s vision is to lead the way in secure AI adoption, combining innovative Connected Cloud solutions with unmatched expertise and service, empowering businesses to thrive confidently in the AI era. The company consults with its customers to design solutions that complement their in-house IT structures; taking complex hybrid multi-site environments, to make them simple and secure, so end-users can access their business applications wherever they are. Role Overview: We’re looking for a detail‑oriented Junior Analyst with strong Microsoft Excel skills, a knack for comparing datasets to spot discrepancies, and the people skills to work across teams to drive actions to completion. You’ll help maintain data integrity across our commercial, operational, and finance systems, producing clear analysis and follow‑ups that keep stakeholders aligned and projects moving. Responsibilities: • Data comparison & reconciliation • Compare datasets from multiple sources (e.g., billing, CRM, finance) to identify variances, duplicates, and gaps. • Perform reconciliations (e.g., product, customer, invoice, usage) and document root causes and fixes. • Maintain discrepancy logs and track remediation through to closure. • Excel‑based analysis • Build robust spreadsheets using XLOOKUP/VLOOKUP, INDEX‑MATCH, PivotTables, PivotCharts, Power Query, conditional formatting, and data validation. • Create reusable templates for monthly checks and audit trails. • Automate routine checks in Excel where practical (Power Query steps, simple macros if appropriate). • Stakeholder engagement & action tracking • Work with colleagues in Operations, Finance, Sales, Billing, and IT to agree owners and timelines for fixes. • Facilitate short action‑review huddles; chase updates and unblock issues. • Escalate risks early with clear, concise summaries of impact and options. • Reporting & insights • Produce digestible reports that highlight anomalies, trends, and recommended actions. • Maintain dashboards (Excel/Power BI basics) showing discrepancy volumes, remediation progress, and SLA adherence. • Process improvement • Document data flows and hand‑offs; suggest practical improvements to reduce recurring errors. • Contribute to data quality standards and simple control checks. • Governance & compliance • Handle sensitive data responsibly (GDPR); follow internal policies for data access, storage, and sharing. Requirements: • Excel proficiency: XLOOKUP/VLOOKUP, INDEX‑MATCH, PivotTables/Charts, Power Query; able to cleanse, reshape, and join data. • Data QA mindset: Strong attention to detail; systematic approach to finding and explaining discrepancies. • Communication: Clear written and verbal communication; able to translate technical findings for non‑technical audiences. • Collaboration: Confident working with busy stakeholders to agree actions and deadlines; resilient in chasing progress. • Organisation: Able to manage multiple checks and follow‑ups, prioritising by risk/impact. • Experience: 6–18 months in an analyst, operations, billing, finance, or QA role (internship/placement acceptable). • Tools: Excel (advanced user), Teams/SharePoint/OneDrive, basic Power BI; familiarity with CRM/ERP or billing systems a plus. Nice‑to‑have • Basic SQL; simple VBA for task automation. • Experience with reconciliation across CRM ↔ billing ↔ finance. • Exposure to data stewardship or KPI reporting. Benefits after probationary period • Subsidised health and dental care • Employee Assistance Programme (EAP) • Life assurance (3x salary) • Discount platform • FluidOne breakfast and refreshments on office days • Pension contribution – 5% company contribution • Generous holiday entitlement • One day off for birthday • Half price internet connectivity • Ride2Work scheme • Department incentives • Volunteer day scheme