BI Developer

The Role

We are looking for an experienced BI developer to design and develop analytics solutions within the Rail BI platforms which includes SAP BW and Snowflake, developing interfaces, ETL, data pipelines and visualisations. The role will involve working with IT, functional consultants and predominately Finance business stakeholders to understand requirements and working with users to ensure developments meet the business needs. The right candidate will be performance and delivery orientated, with an analytical mindset and problem solving attitude. They will have the ability to communicate to a wide range of business audience to ensure their requirements are understood and prioritised.

Key Responsibilities

Develop high quality solutions to meet business requirements:

Design and develop end to end BI solutions with focus on SAP BW and Snowflake
Work with stakeholders, SMEs, and users to understand the 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 data sources to meet user requirements, work with IT colleagues to develop robust and secure interfaces
Work with product and project managers to maintain roadmaps
Assist in the delivery of user training as required
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

Person Specification

Required

Strong experience in SAP BW toolset (3 years +, 2 Lifecycles +), SAP BW / BW on HANA Modelling and BEx Query Designer essential
Strong experience in working with SAP ECC and S/4 HANA extractors for modules - Finance, PCA, SD and MM.
Good knowledge of architecting and implementing very large-scale data intelligence solutions in Data Warehouse like Snowflake
Experience or knowledge of ETL/ELT tools such as Matillion and dbt
Experience working in user facing BI roles
Experience of supporting production environment, resolving data loading issues, process chains
Excellent communication skills, able to communicate effectively with the business and technical colleagues
ABAP and SQL working experience, using ABAP and SQL in Transformations / Rules and custom extractors
Experience of testing and deployment processes
Experience of managing deployments to production environments
Working knowledge of SAP NetWeaver, and operating environment (ie Databases, Operating Systems, networking, applications)
Understands BI technology landscape both current and emerging solution options, and can envisage the business potential of emerging technologies and products
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

Benefits

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*
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*
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 to receive the matching shares*
Employee Assistance Helpline – free, confidential employee support service provided by an independent provider
Payroll Giving – donate directly from your pay to a Charity of your Choice

*After 6 months employment