business intelligence analyst - Reed & Mackay

business intelligence analyst

London, UK



Reed & Mackay leads the global travel and event management arena with extraordinary service and proprietary, client-led technology. Ranked first in the Sunday Times International Fast Track 2020, we are a business that is always looking forwards, while ensuring that we’re everything that our clients need today. In May 2021, we became part of Navan (formerly TripActions), and together we are setting the agenda for the future of business travel.

In recent years we have established international offices in Dubai, the USA, France, Germany, Singapore, Australia and many others. Due to the successful growth of R&M, our international expansion and our philosophy around continuous improvement, a position has become available for a highly competent individual to help drive the group’s reporting capabilities.


Reporting to the Group BI & Data Product Manager, the primary role of this position is to develop Reed & Mackay’s reporting capability, including but not limited to international reporting across the Group and its partner network. R&M are going through an exciting and pivotal evolution in terms of business intelligence and a shift in the approach to how our clients interact with their data. This varied role will play a vital part in this progression. Requires a team player with a strong background developing Tableau reporting, whilst strong skills in SQL Server are also needed for data querying and troubleshooting. Lead by example in being courteous, proactive, helpful and respectful with everyone around you.


  • Creating dashboards based on documented requirements within an Agile environment.
  • Conduction maintenance and improvements on existing dashboards.
  • Utilising MS SQL for data querying to validate business inquiries and troubleshoot issues.
  • Using MS SQL to interrogate large sets of data
  • Collaborating with internal stakeholders to comprehend business needs and gather essential requirements
  • for support system tasks.
  • Escalating tickets to the Group BI & Data Product Manager when development or bug resolution is necessary.
  • Engaging in administrative tasks within the team, such as documentation, best practice guidelines, and training materials.
  • Demonstrating testing proficiency both before and after releases, including writing test cases for items in
  • development and post-release feature testing as directed by the Group BI & Data Product Manager.
  • Advocating for process automation and self-service solutions throughout the organization.
  • Actively engaging with clients to understand their needs, address concerns, and gather valuable feedback, fostering strong client relationships and enhancing product/service offerings based on client input.


  • Advanced knowledge of T-SQL query writing.
  • Advanced knowledge of Tableau Desktop / Server development.
  • Strong Excel skills and experience of working a variety of file formats including CSV, TXT and XML.
  • A collaborative, team orientated approach.
  • Problem-solving skills and ability for critical thinking.
  • A flexible nature to respond to changing priorities.
  • Professional verbal and written communication skills with excellent attention to detail.
  • Strong presentation skills.
  • Strong organisational and time management skills to deal with simultaneous multiple projects and time zones.
  • An amiable, approachable nature.


  • Experience developing in SQL Server Reporting Services (SSRS) and implementing ETL processes using SQL
  • Server Integration Services (SSIS).
  • Previous experience with Python.
  • Previous experience of working with dbt and Snowflake.
  • Ability to communicate with technical and non-technical stakeholders across all levels of the business.
  • Testing experience.
  • Agile experience.
  • The ability to analyse and resolve issues under pressure.
  • Previous use of ServiceNow or DevOps


We think it’s very important that you take responsibility and drive your own personal and professional development. You will be encouraged to develop your technical skills and knowledge through a combination of formal (classroom), online (PluralSight, Tableau and Microsoft) and “on the job” training. R&M encourage individuals to pursue professional accreditations and provide support for external exams. R&M operate an open culture, providing the opportunity for their staff to build valuable management, business and commercial experience to complement their proven technical skill set. Team members have the opportunity to influence the Data Analytics strategy and take a key role in the delivery of data solutions across the business.