Data Modeller

This role will focus primarily on Occupational Health, wellbeing and workforce-related analytics, helping to shape and mature a growing reporting and insight capability in this area. You will help improve management information, identify trends and support evidence-based decision making using data from SAP and a range of workforce systems, including Occupational Health and employee case management platforms, alongside other business systems and reporting sources. As the role develops, there will be opportunities to apply your modelling and analytical expertise across a wider range of workforce and business challenges. What you will be doing

• Building data models, forecasts, scenario analysis and management information products.
• Developing Power BI dashboards and reporting solutions for business users and senior stakeholders.
• Working with SAP based ERP data and other enterprise data sources.
• Supporting Occupational Health, Employee Relations, workforce and attendance-related reporting and analysis.
• Helping stakeholders understand trends, risks, opportunities and data quality issues.
• Translating complex data into clear insight for technical and non-technical audiences.
• Improving reporting processes, automation and the consistency of business intelligence outputs.
• Supporting wider HR, financial, operational and organisational modelling as business priorities change., You will work on data that supports real operational and workforce decisions in one of the UK’s largest and most complex transport organisations. You will have the opportunity to improve how Business Services uses data, shape reporting across emerging priority areas and build analytical products that help colleagues make better, faster and more evidence-based decisions.

You will be naturally curious, analytical and comfortable working with large and complex datasets. You do not need to be an Occupational Health specialist, but you should be interested in using workforce and operational data to improve decision making.

• Strong Power BI and SQL skills.
• Experience developing analytical models, dashboards or business intelligence solutions.
• Experience working with SAP based ERP data or comparable enterprise system data.
• Ability to work with data from multiple systems and turn it into clear, usable insight.
• Experience analysing workforce, HR, operational, case management, finance or organisational datasets.
• Strong attention to detail, with a good understanding of data quality and governance.
• Good stakeholder engagement skills and the ability to explain technical findings clearly.
• Ability to prioritise, manage competing demands and deliver accurate outputs to deadlines.

It would be beneficial if you also have

• Experience with SAP BW, SAP reporting or ERP reporting environments.
• Experience with Employee Relations, case management, Occupational Health, wellbeing or attendance-related data.
• Experience using or reporting from case management systems such as SAP EIC, Meddbase or similar platforms.
• Experience with Power Query, DAX, VBA, Python, R or similar analytical tools.
• Exposure to Databricks, cloud analytics platforms or modern data architecture approaches.

In return for your commitment and expertise, you will enjoy excellent benefits and scope to grow. Rewards vary according to the level of role but mostly include the below:

• Final salary pension scheme
• Free travel for you on the TfL network
• Reimbursement of 75% of the cost of a standard class Ticket for National Rail travel from home or 75% reimbursement on a 28-day flexi ticket
• 30 days annual leave plus public and bank holidays
• TfL is committed to work-life balance, operating a hybrid working approach where business and role requirements allow
• Private healthcare discounted scheme (optional)
• Tax-efficient cycle-to-work programme
• Retail, health, leisure and travel offers
• Discounted Eurostar travel

Hybrid working within this role enables a balance of 50 per cent of time split between the office and home over a 4 week period. Hybrid working arrangements can evolve subject to business requirements. All offers of employment are subject to satisfactory right-to-work checks. Candidates must be able to demonstrate their right to work in the UK. At the present time TfL is unable to offer visa sponsorship for this role.

Shape workforce and organisational insight at TfL We are looking for a talented Data Modeller to join our Business Services team and help turn complex organisational data into insight that supports decisions across Transport for London. This is a varied modelling and analytics role, suited to someone who enjoys solving complex problems, working with business stakeholders and building reporting solutions that make data easier to understand and act on.