AI - Data Scientist

J. Murphy & Sons Limited.
London, United Kingdom
1 day ago
Apply on www.cv-library.co.uk
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) Artificial Intelligence Data Analysis Business Systems Cloud Storage Data Architecture Data Validation Data Cleansing Data Integration Data Integrity Data Security
+29 more
Relational Databases Web Development Python (Programming Language) PostgreSQL Machine Learning Microsoft SQL Server SQL Azure Oracle (Applications) Primavera Raw Data Power BI Standard Sql Microsoft SharePoint Systems Integration Web Applications Enterprise Software Applications Microsoft Power Automate Azure Data Factory Backend Agentic-AI Powerquery Microsoft Fabric Data Management Restful APIs Model Context Protocol Azure Synapse Analytics Data Pipelines Powerapps Databricks

Job description

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

Requirements

  • 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

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.cv-library.co.uk
Prepare application

Good distractions

Loading talks and stories from around this role…