BI Analyst

Join 150+ strategists and specialists who refuse to settle, creating bold digital experiences for ambitious brands since 2004. We're a full-service digital agency delivering strategic consultancy, web development, and digital marketing to drive demand online. Using over two decades of industry experience, we provide next-gen solutions as part of lasting partnerships with hundreds of clients from Chester Zoo and Zip World to Balfour Beatty and Mind. What makes us different:

• We break new ground. You'll work on innovative projects using the latest technologies before they hit the mainstream. We celebrate calculated risks and learn fast from every experiment.
• We get stuck in together. Genuine collaboration across all departments. Your ideas matter here, regardless of your role or how long you've been with us.
• We stay curious. Continuous learning is essential. You'll have dedicated time and budget for development, working alongside industry experts who are genuinely invested in your success.
• We own it. Full accountability and autonomy over your work means you'll build client relationships, see real-world impact, and be recognised when you go the extra mile.

Our Data & Insights team underpins key decision-making across CTI , driving smarter business outcomes with clear, consistent, and actionable insights. This role sits within our Finance team and blends engineering rigour with strategic thinking to build and maintain robust data systems that fuel analytics and business intelligence. As part of the broader Technology function, you'll work closely with stakeholders across the business to ensure our data infrastructure delivers impact at every level. You'll be the internal champion of data, enabling everyone at CTI to 'Own it' by providing trusted, structured, and insightful reports., As our BI Analyst, you'll take ownership of our cloud-based data infrastructure and reporting ecosystem. You will play a critical role in transforming fragmented data into trusted, structured systems that power decision-making across the business. This role is about much more than just numbers- it's about providing the clear intelligence that allows CTI to 'Break new ground' strategically. You'll be responsible for:

• Reporting & Visualisation Mastery: Develop and manage visualisations in Tableau Cloud, transforming complex data into intuitive, actionable dashboards and reports.
• Data Architecture & Optimisation: Maintain, extend, and optimise our central data warehouse and associated ELT (Extract, Load, Transform) pipelines.
• Strategic Collaboration: Work closely with internal stakeholders to understand reporting needs and deliver scalable, fit-for-purpose Business Intelligence solutions.
• Data Modelling: Build reliable data models, combining datasets from multiple platforms into a fully related and normalised structure suitable for performance tracking and reporting.
• Quality Assurance & Governance: Implement and manage rigorous data quality assurance processes, ensuring accuracy, integrity, and completeness , and ensuring the security and proper access of company data.
• Continuous Improvement: Continuously review data structures and reporting outputs, identifying improvements that drive insight, efficiency, and operational performance.
• Documentation & Planning: Maintain clear documentation for all systems, processes, and data flows , and partner with a programme coordinator to maintain a roadmap of system improvements.

Do you have experience in Tableau?, * Tableau Expertise: Proven commercial experience using Tableau to build dashboards and reports is essential.

• SQL Proficiency: You must be comfortable writing and editing SQL queries to manipulate and extract data.
• Problem-Solving Mindset: The ability to use data to answer complex questions and spot trends or inconsistencies in numbers.
• Effective Communication: Strong skills in simplifying complex information and presenting it clearly to both technical and non-technical stakeholders.
• Curiosity and Attention to Detail: You are naturally curious and organised, with a sharp eye for detail and a proactive approach to continuous improvement.
• Collaborative Spirit: A genuine team player who enjoys working with others to get to the best possible solution, embodying the 'Get stuck in' value.

Bonus points for:

• Experience working with cloud-based tools like Google Sheets or HubSpot.
• Hands-on experience with ELT tools such as Fivetran.

️28 days annual leave, in addition to the bank holidays Hybrid-working - we're in the office twice a week Workplace nursery scheme Health cash plan Cycle-to-work scheme

• Flexible working hours

Employee well-being and mental health programme Relaxed working environments - office dogs welcome! Company socials and lots of fun!