BI DATA ANALYST
24 Hour Assistance: +44 (0) 207 246 3333

BI DATA ANALYST

Colchester

London, 27th May

REPORTING TO: GLOBAL HEAD OF DATA

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 the TripActions Group, and together we are setting the agenda for the future of business travel.

Due to the continuing growth of our business internationally and the importance we and our clients place on information security, a position has become available for a highly competent BI Data Analyst.

The BI Data Analyst role is pivotal within the company and your overall remit will be to analyse activity data, investigate trends and make recommendations to support the business operations across the board.

WHAT YOU’LL DO:

  • Using SQL to build, maintain and optimise complex data sets and associated reports
  • Managing ETL process, including adapting and troubleshooting as required to ensure data consistency
  • Carrying on data quality assessments, identifying gaps, and performing remediation actions
  • Communicating with stakeholders to understand data content and business requirements
  • Preparing reports and create data dashboards, graphs, and visualisations for varying audiences within the business
  • Producing and tracking key performance indicators
  • Refining, updating, and timely distributing existing reports, ensuring they remain accurate and are fit-for-purpose as the business evolves
  • Using statistical tools to analyse data and forecast trends with actionable business insights
  • Processing and delivering solutions to the internal customer requests and queries in an efficiently and timely manner
  • Helping to deliver a continuously improve strategy by proactively identifying data issues, investigating errors, fixing root cause issues, and recognizing improvement opportunities
  • Promoting processes automation and self-serve solutions
  • Maintaining awareness of technology changes within the BI industry

WHAT WE’RE LOOKING FOR:

  • Proven working experience in data analysis
  • Proficient in MS SQL, MS SSIS or similar ETL packages
  • Experience with Azure and other data tools
  • Strong knowledge of SSRS and Tableau (or similar)

ESSENTIAL:

  • An amiable, approachable nature
  • A collaborative, team orientated approach
  • Problem-solving skills and ability for critical thinking
  • A desire to contribute, grow and develop with the business

INTERNAL RESPONSIBILITIES:

Responsible for assisting with compliance to Reed & Mackay’s certification programmes and policies.