AI - Data Scientist at J. Murphy & Sons Ltd, London
J. Murphy & Sons Ltd · Direct employer
Pay not stated
London · Permanent
Murphy is a leading international, specialist engineering and construction company founded in 1951 with a purpose to improve life by delivering world-class infrastructure. Operating in the United Kingdom, Ireland, Canada and America, Murphy provides better engineered solutions to infrastructure sectors including transportation; natural resources; energy and water.
Headquartered in London, Murphy has a number of related businesses – Ground Engineering; Utility Connections; Murphy Plant; Murphy Process Engineering; Pipeline Testing Services; Specialist Welding Services; and Electrical Services. Murphy is a specialist in delivering pipelines, design, structural steel, tunnelling, fabrication, bridges and piling, and has a substantial holding of plant, equipment and facilities.
Murphy employs around 4,000 engineers, professional managers and skilled operatives around the world. Together, they work as ‘One Murphy’ - directly delivering the people, plant and expertise needed to make projects a success. Visit (url removed) or follow us on LinkedIn, Facebook, Instagram and X:
#MoretoMurphy
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
Application opens at the source listing. Free for jobseekers.