Application Deadline: 30 September 2025
Department: Finance
Location: Manchester
Compensation: £35,000 - £40,000 / year
Description
About CTI
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. Sitting within our Finance team, this role 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.
Responsibilities
What you’ll be doing
- As our Data Analyst, you’ll take ownership of our cloud-based data infrastructure and reporting ecosystem. You’ll play a critical role in transforming fragmented data into trusted, structured systems that power decision-making across the business.
- Maintain, extend and optimise our central data warehouse and associated ELT (Extract, Load, Transform) pipelines
- Build reliable data models, combining datasets from multiple platforms into a fully related and normalised structure suitable for performance tracking and reporting
- Develop and manage visualisations in Tableau Cloud, transforming complex data into intuitive, actionable dashboards and reports
- Collaborate with stakeholders to understand reporting needs and deliver scalable, fit-for-purpose BI solutions
- Continuously review data structures and reporting outputs, identifying improvements that drive insight, efficiency, and operational performance
- Implement and manage rigorous data quality assurance processes, ensuring accuracy, integrity and completeness
- Partner with a programme coordinator to maintain a roadmap of system improvements and prioritise delivery with key business stakeholders
- Ensure the security and proper access of company data in compliance with best practices
- Maintain clear documentation for all systems, processes, and data flows
Qualifications
What experience you need to be successful
- Proven data analysis experience: hands-on, commercial experience using Tableau to build dashboards and reports
- SQL Proficiency: comfortable writing and editing SQL queries to manipulate and extract data
- Problem-Solving Mindset: enjoy using data to answer complex questions and can spot trends or inconsistencies in numbers
- Effective Communication: able to simplify the complex and present information clearly to both technical and non-technical stakeholders
- Curiosity and Attention to Detail: naturally curious and organised, with a sharp eye for detail and a proactive approach to continuous improvement
- A collaborative spirit; a great team player who enjoys working with others to reach the best possible solution
Bonus points for:
- Experience working with cloud-based tools like Google Sheets or HubSpot
- Hands-on experience with ELT tools such as Fivetran
We’re challenging the ''Gender Confidence Gap,'' which suggests that individuals will only apply for a job if they meet 100% of the criteria. Some of our best hires didn’t check every box in the role description, so if you were about to rule yourself out, we still encourage you to apply!
Learn more about our commitment to equality, diversity, and inclusion here.
What's in it for you?
- 28 days annual leave, in addition to the bank holidays
- Hybrid-working - 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