Job Title: AI - Data Scientist
Murphy is recruiting for a AI - Data Scientist to work within the AI Team at Kentish Town
Operating in the United Kingdom, Ireland, Canada and the USA, Murphy provides better engineered solutions to infrastructure sectors including transportation, water, power and natural resources. So that our teams out on projects can run smoothly it is vital that we have robust support functions in place.
We are committed to fostering an engaging and collaborative work environment in which each person’s career is nurtured and developed. We focus on employee development, providing a culture of innovation and positive work-life balance.
Murphy's AI team designs and delivers AI solutions across the whole business, from engineering and project delivery to commercial, work winning and support functions. These include AI agents, web applications and data-driven tools that help people work more efficiently and make better decisions.
The AI strategy is built on four foundations: people, data, process and technology. This role drives the data foundation, building the reliable data layer that AI solutions run on. The post holder will connect business systems through APIs and MCP connectors, create clean, structured data in Microsoft Fabric and supporting databases, and help turn that data into working solutions, including automated workflows and web applications. As this foundation matures, the role will develop the first predictive models, turning historical project data into insight that helps the business anticipate risks and improve delivery.
A day in the life of a Murphy AI Data Scientist
- Data integration and system connectivity
- Connect source systems such as Oracle Primavera P6, Oracle Aconex, SharePoint and Excel trackers, using REST APIs and other integration methods
- Set up and use Model Context Protocol (MCP) connectors so AI agents and applications can access business systems and data securely
- Build repeatable, maintainable data pipelines instead of one-off manual extracts
- Work with system owners and IT colleagues to agree secure data access, credentials and permissions
- Data platforms and architecture
- Build and maintain data solutions in Microsoft Fabric, including lakehouses, pipelines, dataflows and notebooks
- Design and implement a medallion architecture (Bronze → Silver → Gold), taking raw data through cleansed and conformed layers to curated, business-ready datasets
- Design and maintain relational databases (e.g. Azure SQL Database, PostgreSQL) that support AI solutions and web applications, including schema design, performance and data integrity
- Design data models that bring together information currently spread across multiple trackers and systems
- Data cleaning and preparation for AI solutions
- Clean, validate, deduplicate and standardise data from multiple sources
- Transform and structure data and documents so AI agents and applications can use them
- Handle unstructured and semi-structured inputs such as PDFs, programme exports and reports
- Put data quality checks in place and document data sources, definitions, lineage and limitations
- Solution development and delivery
- Support and develop automated workflows using Power Automate, integrating them with business systems and data sources
- Contribute to building and delivering AI-enabled web applications, particularly the data, integration and back-end components
- Work with the AI team to take solutions from prototype through testing and deployment
- Support existing solutions as they move into live use, including fixes, refinements and data updates
- Analytics and predictive modelling (developing area)
- Explore historical project data to find patterns, trends and data gaps
- Identify where predictive models could add value, such as programme slippage or delay risk
- Develop, test and evaluate pilot models, and explain the results and their limitations clearly to non-technical stakeholders
- Collaboration and governance
- Work closely with the AI team throughout discovery, build and testing
Still interested, does this sound like you?
- Strong Python and SQL skills, including relational database design (e.g. Azure SQL, SQL Server or PostgreSQL)
- Experience pulling data from APIs and integrating multiple data sources
- Hands-on experience cleaning, transforming and modelling data
- Experience with Microsoft Fabric or a comparable lakehouse platform (e.g. Azure Synapse or Databricks)
- Understanding of medallion or layered data architecture
- Experience with Power BI and/or Power Query
- Ability to explain technical work clearly to non-technical colleagues
- Structured, practical approach with strong attention to data quality
Desirable skills - Experience with MCP connectors or connecting AI agents to enterprise systems
- Experience with Oracle P6 and/or Aconex data
- Experience with Azure data services (e.g. Azure SQL Database, Azure Database for PostgreSQL, Azure Blob Storage)
- Experience with Power Platform (Power Automate, Power Apps), SharePoint or Dataverse
- Experience contributing to web application development
- Understanding of statistics and machine-learning techniques (e.g. regression, classification, forecasting)
- Experience preparing data or documents for AI and LLM-based solutions
- Knowledge of construction, infrastructure, planning or project controls
What’s in it for you?
- 27 days holiday, plus bank holidays with the option to buy an additional 2 days holiday each year, holidays increase with length of service
- Discretionary annual bonus and annual salary review
- Above market rate contributory pension scheme
- Life assurance, health screening and enhanced sick pay
- Enhanced maternity and paternity pay and a maternity returners bonus
- Extra weeks holiday for all employees getting married and a wedding bonus
- Subsidised canteen facilities in core locations
- Dedicated and continued investment in your professional development
- Other Murphy benefits include retail discounts and cashback, discounted gym memberships, cycle to work scheme etc
About Murphy
Murphy is formally recognised as a sector leading employer, Platinum Investors In People accredited along with reported operating profit up 57% on prior year. At Murphy, we are incredibly proud of our diverse workforce. Not only do our people represent over 60 different nationalities, but they also represent a wide range of backgrounds, ethnicities and ages. With a forward order book of £5.4bn and £23m Invested in environmentally friendly plant in 2024 there really is #MoretoMurphy
If you are unable to apply via the usual process, please call Lorna Rhodes on 07801 960464 to discuss in more detail.
Murphy is unable to employ anyone who does not have the legal right to live and work in the UK