Collinson is the global, privately-owned company dedicated to helping the world to travel with ease and confidence. The group offers a unique blend of industry and sector specialists who together provide market-leading airport experiences, loyalty and customer engagement, and insurance solutions for over 400 million consumers.
Collinson is the operator of Priority Pass, the world’s original and leading airport experiences programme. Travellers can access a network of 1,500+ lounges and travel experiences, including dining, retail, sleep and spa, in over 650 airports in 148 countries, helping to elevate the journey into something special. We work with the world’s leading payment networks, over 1,400 banks, 90 airlines and 20 hotel groups worldwide.
We have been bringing innovation to the market since inception – from launching the first independent global VIP lounge access Programme, Priority Pass to being the first to sell direct travel insurance in the UK through Columbus Direct and creating the first loyalty agency of its kind in the travel sector with ICLP. Today we still invest heavily in innovation to ensure that we continue to deliver superior customer experiences.
Key clients include Visa, Mastercard, American Express, Cathay Pacific, British Airways, LATAM, Flying Blue, Accor, EasyJet, HSBC, Chase, HDFC.
Our mission is focused on doing good beyond profit, which for us means we seek out opportunities for our people to share in our success and that we give back to the communities and people within which we work.
Never short of ambition, the success of our business is delivered through the diverse and talented team of over 1,800 global colleagues.
Purpose of the Job
We are looking for a skilled Finance & Accounting Data and Automation Analyst with a background in finance, advanced Microsoft Excel skills, and experience using Microsoft Power Automate to enhance data management and process efficiency. The ideal candidate will be adept at data analysis, report generation, and workflow automation, supporting finance teams by creating reliable, automated, and data-driven solutions.
Key Responsibilities
1. Finance Data Analysis, Structuring & Reporting:
- Perform in-depth structuring using Microsoft Excel to manage and analyse data sets, model scenarios, and produce insights.
- Build, maintain, and refine complex Excel models with formulas, pivot tables, conditional formatting, and advanced functions to support various finance processes.
2. Process Automation with Power Automate:
- Design, implement, and maintain automated workflows in Power Automate to streamline repetitive tasks, reduce errors, and improve data accuracy in finance operations.
- Integrate Excel with other Microsoft applications (e.g., SharePoint, Outlook, Teams) using Power Automate, automating data inputs, notifications, and report distribution.
- Continuously monitor and troubleshoot workflows to optimize performance and adapt to changing business needs.
- Experience working with Microsoft Dynamics is desirable
3. Financial Data Management & Integrity:
- Ensure data accuracy and integrity in all financial models and automated workflows, implementing robust data validation and control measures.
- Work with the finance team to identify data gaps and opportunities for automation and implement enhancements using Excel and Power Automate.
- Perform regular audits and quality checks to ensure data accuracy across financial systems and workflows.
4. Cross-Department Collaboration:
- Collaborate with finance, accounting, and operations teams to understand financial data needs and automate reporting processes.
- Provide training and support to team members on best practices for using Excel and Power Automate in finance tasks.
- Act as a point of contact for troubleshooting Excel and Power Automate issues, and identify solutions that enhance team efficiency.
5. Continuous Improvement & Documentation:
- Stay up-to-date on new Excel and Power Automate features, integrating relevant updates into finance processes.
- Document all automated workflows, Excel models, and reporting processes for easy access and knowledge sharing across the finance team.
- Proactively seek opportunities to improve workflows and reporting efficiency, suggesting new tools or methods where beneficial.
Key skills and experience to be evidenced within your application include
- Education: Bachelor’s degree in Finance, Accounting, Business, Data Analytics, or a related field.
- Experience: Experience in a finance and accounting data analysis role with a proven track record of using Excel and Power Automate for process automation.
- Technical Skills:
- Advanced proficiency in Microsoft Excel (formulas, pivot tables, VBA macros, data visualization, etc.).
- Strong knowledge of Microsoft Power Automate, with experience creating, testing, and maintaining workflows.
- Familiarity with other Microsoft tools, such as Power BI, Power Query, and SharePoint is a plus.
- Analytical Skills: Ability to analyse large datasets, interpret data structures, and provide automation producing actionable insights.
- Attention to Detail: Highly organized with a focus on data accuracy and quality control.
Preferred Qualifications:
- Experience with financial software (e.g. Microsoft Dynamics).
- Certification in Microsoft Office Specialist (Excel Expert) or Microsoft Power Automate is a plus
Key Competencies:
- Problem-Solving: Proactively identifies and resolves issues in workflows.
- Communication: Strong written and verbal communication skills, with the ability to translate complex data into clear insights.
- Time Management: Ability to handle multiple projects and meet tight deadlines in a fast-paced environment.
- Team Collaboration: Works effectively with cross-functional teams and demonstrates a customer-oriented mindset.
This role will be instrumental in modernising finance and accounting processes and supporting data-driven decision-making across the organization. If you’re passionate about finance, technology, and process improvement.
Collinson is an equal opportunity employer and welcomes differences in all their forms including: colour, race, ethnicity, gender identity, sexual orientation, neurodivergence, family status, age, individuals with disabilities and people from all backgrounds, cultures and experiences as we strongly believe this contributes to our on-going success.
We are focused on continually evolving our purpose driven, high performing culture, providing an environment where our people have the opportunity to achieve their full potential and do interesting and meaningful work. Our company values are: Act smarter, Do the right thing, One team and Be insight led. These help guide everything we do internally in terms of how we think, act and interact, right through to how we deliver value to our customers and clients.
In your application, please feel free to note which pronouns you use (For example - she/her/hers, he/him/his, they/them/theirs, etc).
If you need any extra support throughout the interview process, then please email us at
