Senior Business Intelligence Developer

  • AirTanker
  • Carterton, UK
  • 17/03/2021
Full time Data Science Data Analytics Big Data Business Intelligence Data Management Statistics

Job Description

    • Annual bonus scheme (eligibility in current year subject to bonus rules)
    • Private Medical Plan
    • Life Assurance Cover
    • Income Protection
    • Contributory Pension Scheme
    • Local Gym Discount
      • Provide the Head of Data and Information Assurance with support in the development and execution of the data strategy, deputising when required.Providing technical expertise and support.
      • Coach and mentor a small team of BI Developers in BI best practice.
      • Oversight and contribution to the design, development and implementation of the data warehouse to support the BI requirements of the business (translating requirements from the business into data solutions).
      • Support the development of the company capabilities in how we can look at what has happened to what will happen – predictive planning and analysis.
      • Minimise the duplication of data and logic to achieve the ‘single source of the truth’.
      • Ensure high quality documentation is developed, maintained, regularly review and stored.
      • Identify, test and fix bugs and bottlenecks in the ETL process to improve data quality, build quality and reporting responsiveness.
      • Developing analytics and reporting capabilities and leading BI projects to facilitate the optimal conversion of data into information, information into insight, and insight into business decisions.
      • Build, provide ongoing maintenance, drive consistency and drive usage of a suite of data visualisations, dashboards, operational reports etc using the most appropriate reporting and visualisation tools to meet customer requirements.
      • Work in close collaboration with key business stakeholders (include BIAs) to design and maintain new complex dashboards, facilitate analysis and model building and other reporting solutions.
      • Lead improvements to drive data quality such as accuracy, completeness, consistency, reliability and whether it's up to date.Drawing attention at a senior level to quality issues by including expectation reporting in any reporting output.
      • Acquiring data from primary or secondary data sources to build into the Data Warehouse, with relevant IAO approvals to exploit the data available to deliver customer requirements.
      • Liaise with application support specialists, business users and database developers via our IT team to fully understand data sources in order to deliver customer requirements.
      • Work alongside IT team to understand 1) impacts of database changes to reporting and ensure impacts are understood and considered 2) ensure that data / reporting is considered when implementing IT change 3) drive technology changes to support our data capabilities.
      • Contribute to the development and implementation of policies, processes and systems that support the maintenance and provision of accurate and fully governed data.Potential owning and driving adherence to those policies in the business.
      • Ensure processes and policies are followed when building out data / reporting requirements to ensure we maintain the integrity of the data, the output is fully tested and customer sign off is achieved.
        • Proven experience of leading and delivering large and complex business intelligence projects.
        • Experience of coaching / mentoring teams in best practice BI.
        • Excellent data warehouse development skills preferably in SQL Server environment with experience of designing and building multi-dimensional data warehouse models and downstream cubes/marts – creating tables, views, stored procedures, indexing and performance tuning, and ETL processes
        • Ability to think strategically; looking at bigger picture and longer term goals.
        • Strong data analytical skills with ability to collect, organize, analyse and disseminate significant amounts of information with attention to detail and accuracy
        • Expertise of full MS BI Stack including MS Azure, SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS).
        • Experience of building front-end BI solutions/dashboards using reporting and visualisation tools such as Power BI (DAX), SQL Server Reporting Services (SSRS), and Excel (including Power Query).
        • Ability to build relationships and focus on delivering customer outcomes.
        • Proactive, hands-on approach, self-starter that is able to take the initiative
        • Strong team player that can work both independently and as part of a fully integrated team
        • Ability to translate technical knowledge into something that can be easily understood by non-technical business roles.
        • Ability to communicate at all levels of the business effectively
        • Ability to manage multiple priorities.
        • Ability to look at issues from a broad perspective to come up with imaginative solutions, and to identify innovative alternatives to typical, unusual or difficult situations or problems
        • Previous experience of developing and executing data governance policies and frameworks.Recommend and implement continuous improvement initiatives identified as crucial to the enhancement of the data warehouse, the team and associated processes and data/reporting outputs.Plane Saver (Credit Union)

          AirTanker is one of the world’s most exciting aviation innovations and we offer a diverse range of roles in our unique environment, based in the heart of the picturesque Cotswolds.

          AirTanker was established in 2008 to deliver Voyager, the RAF’s new air-to-air refuelling and air transport aircraft. Working alongside full time RAF personnel and Reservists, we blend the best of civil and military aviation expertise to carry out air-to-air refuelling tasks and fly our armed forces to wherever they are needed in the world.

          In 2016 Airtanker also successfully launched into the commercial leasing market and has quickly built a reputation for integrity, professionalism and flexibility amongst our customers.

          As we change and grow, we continue to place a major emphasis on the quality of our people. We look to recruit candidates who can demonstrate the same passion, flexibility and motivation that we do. We are a unique and complex airline and are looking for people who will thrive in this environment.

          We are proud to invest in our people and wellbeing and to be a diverse and inclusive employer.

          Joining AirTanker could be the best decision you make!

          For more information on AirTanker, please visit our website:

          Senior Business Intelligence Developer

          Purpose of the Role

          To establish and maintain a best-practice framework that will contribute to the delivery of high quality data analytics at Airtanker.

          The Senior BI Developer should be expert at designing, implementing and operating stable, scalable solutions to flow data from business applications to the data warehouse, and into end user facing analytics applications. They will provide mentoring and coaching to other Business Intelligence developers to drive a consistent approach and customer experience. They will work with business customers at all levels to understand their requirements and implement trusted and reliable reporting solutions that satisfy their needs.

          The Senior BI Developer will help define and drive execution of the data team strategy and keep up to date with the latest developments in data technologies.

          The Individual

        Job Responsibilities

      The Reward

      Working with like-minded people, you’ll also find a warm welcome here at the AirTanker community. We have an annual diary of organized events from family days and summer festivals to a social scene that has gone from strength-to-strength as we have grown. AirTanker is about much more than the ‘nine to five’. We will earn your commitment, offering you a unique opportunity to play a crucial part in a pioneering service that is working to deliver unparalleled support to the RAF and UK armed forces.

      On top of your basic salary, you’ll receive;

    Additional Information

    Due to the nature of the organisation, all employees of AirTanker Services are required to be security cleared to SC level. If successful in your application we would support you with the SC process. As a guideline only, you would normally need to have been a UK resident for the last 5 consecutive years. Further confirmation can be found on the National Security Vetting (NSV) website

    If you have not been a UK resident for the last 5 consecutive years, please be prepared to request an Overseas Criminal Records Check for these countries as you will be asked to provide this for referencing and security checks if you are successful.