Data Platform Engineer

Post: Data Platform Engineer Grade: FRS E Salary range: £43,736 – £52,242 per annum Contract type: Permanent Working pattern: Full-time Application closing date: 4 PM on Thursday 01 November 2024 In today’s rapidly evolving world, technology plays a crucial role in every aspect of our lives, and the London fire Brigade is no exception. As one of the largest Fire & Rescue services in the world, the Brigade has around 6000 employees and is located at over 100 sites in Greater London. We are here to make London a safer city. From advanced communication systems to data management and real-time analytics, ICT is the backbone that underpins operational service delivery, ensuring firefighters have the tools they need to respond quickly and effectively in emergencies. We are currently recruiting for a range of roles across the department, in support of our ambitious transformation programme(s) and operational service delivery. A full list of all of the roles available at London Fire Brigade

can be found at https://jobs.london-fire.gov.uk/alljobs/ We are looking for a Data Platform Engineer to join our Data Platform Team within the Application and Data Services Team. The Data Platform is transforming LFB’s reporting environment to allow for an enterprise-wide data-driven approach to decision making. You will be responsible for helping to develop, build, deploy, document and Support the Data Platform. As a Data Platform Engineer, you will help to: Design data structures optimised for analysis. Extract data from source systems into Staging, perform any data cleansing required. Load dimension and fact tables. Deploy databases changes to test and live as required, using the SQL Compare and following LFB’s change management procedures. Develop, test, implement and maintain SSAS tabular models including adding measures and calculated columns. Develop, unit test, implement and document reports to meet stakeholder requirements using Power BI, DAX and SSAS

dimensional tabular models Ensure tabular models are documented, and changes communicated, in an appropriate manner. Integrate data access controls to meet LFB data security requirements, leveraging Windows security and RLS. Work with the BI team to handover new tabular models and reports when appropriate, and support during this process.id improved deliverables through your area of work responsibility. Participate in daily team Standup meeting, working with the Head of Application and Data Services to support and contribute to the JIRA board. Maintain accurate documentation for all work and ad hoc tasks. Plan and organise own work so that personal and team objectives are met within agreed deadlines and targets. Further information about the main duties and responsibilities of the role are detailed in the job description. If you are unable to see the job description, salary range or the full advert, please visit our jobs pages at

https://jobs.london-fire.gov.uk/alljobs/ to access the full advert. We value the diversity of our employees and aim to recruit a workforce which reflects our diverse communities across London. The London Fire Commissioner is an Equal Opportunities Employer and we positively welcome applications from all suitably qualified individuals, irrespective of people’s age, disability, gender, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances. We have guidance in place to ensure that all applicants are treated fairly and consistently at every stage of the recruitment process, including the consideration of reasonable adjustments for people who have a disability.

Assessment Overview

Stage 1 To apply, please complete the online application, upload a copy of your up-to-date CV and provide evidence to address the following selection criteria: 1. Experience of extracting data from a variety of source systems, including databases, spreadsheets, text files. 2. Experience of loading data into a dimensional model using T-SQL and / or SSIS / ADF. 3. Experience of automation of data warehouse loading processes and techniques. 4. Experience of good experience of using Power PBI to build reports from a Tabular Model. Please note that we will evaluate score the evidence you provide based on the competencies listed in the selection criteria above. The CV is for information purposes only and will not be marked. Shortlisted candidates will be invited to attend the stage 2. Please ensure you give yourself enough time to complete and submit your application. Late or un-submitted applications cannot be accepted. Please note any correspondence

• Additional leave

• Annual leave

• Company pension

• Cycle to work scheme

• Employee discount

• Work from home, Benefits of working for the London Fire Brigade 26 days’ holiday plus bank holidays Flexi-time Scheme (which can result in an additional 12 days annual leave) Additional leave between Christmas Day and New Year Family (including maternity) leave and emergency support leave Flexible working including work from home 60% Free access to the Brigade gym Use of the Brigade’s Medical Adviser/physios/fitness advisers Free counselling Season ticket loans Join social networks including our Equality Support Groups Contributory pension scheme Cycle to work scheme Staff discount scheme including access to Blue Light Card retail and hospitality discounts Opportunity to access affordable accommodation In line with the Basic Personnel Security Standard (BPSS) employment checks will be completed by successful candidates, which will include a Standard criminal records check. Successful candidate will be required to declare any

convictions for offences and any offer of employment is subject to the LFC receiving a criminal records disclosure which it considers satisfactory.

Job Reference: FRS01164

If you require alternative methods of application or screening, you must approach the employer directly to request this as Indeed is not responsible for the employer’s application process.

received from us will be via e-mail and sent to the address you provide on your application form. Stage 2 Assessment for this role is due to take place in weeks commencing 18th and 25th November 2024 at our Headquarters, 169 Union Street, Southwark. Please be advised that if you are unable to make the scheduled assessment date, we may not be able to make alternative arrangements.