The Role
Post: Data Platform Engineer
Salary: £43,736 per annum
Grade: FRS E
Salary range: £43,736 - £52,242 per annum
Contract type: Permanent
Working pattern: Full-time
Application closing date: Thursday 25 July 2024 at 16:00 GMT
London Fire Brigade (LFB) is one of the largest firefighting and rescue organisations in the world and the busiest in the country. As an organisation we are committed to delivering our services in ways that best suit the needs of our communities.
We are looking for a Data Platform Engineer to join our Data Platform Team within the Application and Data Services Team, part of the ICT department.
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.
To be considered for this role, you will need to have:
• Previous experience of extracting data from a variety of source systems, including databases, spreadsheets, text files.
• Loading data into a dimensional model using T-SQL and / or SSIS / ADF.
• Automation of data warehouse loading processes and techniques.
• Good experience of using Power PBI to build reports from a Tabular Model.
• Advanced T-SQL – including Merge, Insert, views, tables and stored procedures.
• Knowledge of Kimball methodology.
• Knowledge of Agile methodology.
• Knowledge of dimensional data warehousing.
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 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
Online application, CV and cover letter (sift). Shortlisted candidates will be invited to stage 2.
To apply, please complete the online application, provide a cover letter clearly outlining the relevant experience, skills and knowledge you have to successfully perform this role (see competencies below) and upload a copy of your up-to-date CV. The CV is for information purposes only and will not be marked.
Please note that we will review and score the cover letter based against the competencies listed below:
• Previous experience of extracting data from a variety of source systems, including databases, spreadsheets, text files.
• Loading data into a dimensional model using T-SQL and / or SSIS / ADF.
• Automation of data warehouse loading processes and techniques.
• Good experience of using Power PBI to build reports from a Tabular Model.
• Advanced T-SQL – including Merge, Insert, views, tables and stored procedures.
• Knowledge of Kimball methodology.
• Knowledge of Agile methodology.
• Knowledge of dimensional data warehousing.
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 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 early/mid-August 2024. Please be advised that if you are unable to make the scheduled assessment date, we may not be able to make alternative arrangements.
Please note: Should you be shortlisted you may need to be able to conduct an interview over Microsoft Teams (a video conferencing service). You will be asked to provide relevant contact details for that to take place if shortlisted.
Additional Information
Benefits of working for LFB
• 26 days’ holiday plus bank holidays
• Option Absence Scheme (which can result in an additional 12 days annual leave for staff at this grade)
• Flexible working including job share
• Welfare Scheme
• Use of Brigade Medical Adviser/physios
• Season ticket loans
• Equality Support Groups
• Contributory Pension Scheme
• Cycle to work scheme
• 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.
Attachments