> Markdown version of [/jobs/ext/4763498-ai-data-scientist](https://www.wearedevelopers.com/jobs/ext/4763498-ai-data-scientist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # AI - Data Scientist - **Company:** J. Murphy & Sons Limited. - **Location:** London, United Kingdom - **Contract:** Permanent contract - **Skills:** 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, 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 - **Published:** November 18, 2026 - **Apply:** https://www.cv-library.co.uk/job/225850392/ai-data-scientist ## About the Role * 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 ## 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