Data Platform Engineer – London Fire Brigade

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 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.

Salary: Salary range: £43,736 - £52,242 per annum

Contract type: Full Time

Closing date: July 25 2024

Post a job for £500

Our jobs attract over 15,000 page views per month. You can advertise a job on the NFCC website for 30 days

Submit a Job

Members FREE job posting

Members of NFCC can advertise jobs for FREE

Submit a Job