Skip to main content

Search for jobs via job title or by location using the fields below:

If you leave fields blank and click the search button you will see all available vacancies. There may be several pages of results.

Search Vacancies


BI Developer

We are looking for an experienced BI developer to design and develop analytics solutions within the Rail Snowflake platform and includes developing interfaces, ETL and data pipelines, and visualisations.  The role will involve working with IT and business stakeholders to understand requirements, and working with users to ensure developments meet the business need

What will you be doing?

Develop high quality solutions to meet business requirements:

  • Design and develop end to end BI solutions with a focus on Snowflake
  • Work with stakeholders and users to understand requirements
  • Ensure compatibility with required analytics packages
  • Produce analytic dashboards, according to user requirements
  • Support user interrogation of the database, with documentation and consulting support
  • Proactively identify and resolve issues, including performance and data quality problems
  • To own the integrity of the data within the platform and ensure this is maintained
  • Identify potential datasources to meet user requirements, work with IT colleagues to develop robust and secure interfaces
  • Work with product and project managers to maintain roadmaps
  • To ensure a library of technical documentation is maintained and regularly updated

Additional Responsibilities

  • Understand TOC and Rail industry systems and data and to advise and deliver solutions that take advantage of any of these data sources
  • Collaborate with peers and wider teams to enhance best practice
  • Assist the TOCs in helping them understand opportunities in their use of the platform

Who are we looking for?


  • Experience working in user facing BI roles
  • Good knowledge of architecting and implementing very large-scale data intelligence solutions in Snowflake Data Warehouse
  • Strong experience in data warehouse design
  • Strong SQL and data modelling skills
  • Performance tuning expertise, with a focus on Snowflake
  • Experience in ETL/ELT tools such as Matillion and dbt
  • Experience of testing and deployment processes
  • Experience of managing deployments to production environments


  • Python scripting and analytical libraries
  • Experience in AWS stack, including S3
  • Experience working with a range of different interfaces
  • Working with APIs
  • GitHub / Bitbucket
  • Analytics and Visualisations packages, such as Power BI, AWS Quicksight
  • Experience working with statistical and data science languages and software packages
  • AGILE working and sprint planning
  • Rail specific knowledge about train operational data

What key behaviors/attributes are we looking for?

  • Performance and delivery oriented
  • Analytical mindset with a problem-solving aptitude
  • Ability to communicate to a wide range of business audience, to ensure their requirements are understood and prioritised
  • Willingness to confront and ask probing questions to understand colleagues needs
  • Good written and verbal communication skills
  • Operate effectively in unfamiliar environments, remaining calm under pressure and agile in approach
  • Proactive and positive attitude
  • Transparent and open style
  • Excited by a challenge and enthusiastic about developing the wider team
  • Takes responsibility for personal objectives

What you'll get in return?

  • Minimum of 10% contribution to your Pension (5% employer and 5% employee)
  • 25 days Holiday plus National Bank Holidays
  • Travel Offers for Bus and Rail*
  • Free Bus Travel on your local FirstGroup Operated Network
  • Payroll Giving – donate directly from your pay to a Charity of your Choice
  • Shopping Discounts including discounts and cashback on electrical goods, your weekly shop, holidays, cinema trips, car insurance, upgrading your mobile and lots more
  • All employee Share Schemes*
  • Save as You Earn - gives you the opportunity to save a regular amount each month for three years. At the end of the savings period, you can use your savings to buy shares at a discounted price set at the start of the Scheme or take your savings as cash.
  • Buy as You Earn - allows you to buy shares each month, with 2 free ‘matching' shares for each 3 shares you buy. You can vary the amount you save, or stop it at any time. You need to participate in the scheme for at least 3 years in order to receive the matching shares.
  • Employee Assistance Helpline – free, confidential employee support service provided by an independent provider

*after 6 months of employment

FirstGroup plc welcomes applications from a diverse range of candidates regardless of background, gender, race, religious beliefs, disability, sexual orientation or age. We aspire to be a diverse and inclusive organisation because we believe that diversity brings benefits for our customers, communities and our people. Valuing our differences and drawing on our collective knowledge and experience helps us develop new services, open up new markets and broaden our customer base.

Interested?  Apply Today!

Close map
Capital House, London
Capital House, Chapel St, London, England, NW1 5DH
  • Ref:
  • Company:
    First Rail Holdings
  • Website Skillset:
    All Other Roles
  • Contract Type:
    Permanent - Full Time
  • Contracted Hours:
  • Location:
    Capital House, London
  • Closing Date:
    22 April 2021
Share this page
Share with linkedin
Share with facebook
Share with twitter
Share with email
Vacancy Alerts
Create an alert subscription based on this vacancy