ERM Logo

ERM

Consulting Senior Associate: AI and Automation (Entry Level)

Posted Yesterday
Be an Early Applicant
Hybrid
Edinburgh, Midlothian, Scotland, GBR
Senior level
Hybrid
Edinburgh, Midlothian, Scotland, GBR
Senior level
Build AI and automation solutions using Microsoft Fabric, Power Platform, LLMs, intelligent document processing, agentic AI, and Power BI. Lead responsible AI practices, stakeholder discovery, training, adoption, and MVP delivery across capital project consulting. Maintain billable involvement in Technical Due Diligence engagements, identify client-facing AI opportunities, and support proposals and commercial delivery. The role requires Python, SQL, data pipeline development, governance awareness, strong communication, and UK work authorization.
The summary above was generated by AI

Within ERM, our Capital Project Delivery service line is investing in AI and automation as a strategic enabler of its consulting services.

We are establishing a dedicated AI & Automation Implementation Support role to accelerate this transformation — embedding intelligent tooling into our delivery workflows, driving adoption across the practice, and translating emerging AI capabilities (LLMs, agentic systems, intelligent document processing) into tangible commercial outcomes for clients.

This is a hybrid build-and-enable role. The post-holder will spend part of their time designing and building AI/automation solutions — primarily on the Microsoft Fabric and Power Platform stack — and part of their time driving adoption through training, enablement, and stakeholder engagement across CPD.

What you'll do

Build — AI & automation solution development
  • Design, build and maintain AI-powered data and document pipelines on Microsoft Fabric (Lakehouse, Delta tables, notebooks, Dataflows Gen2, pipelines) supporting CPD service lines.

  • Apply Large Language Models (LLMs) to real consulting workflow problems — including document extraction, classification, summarisation, retrieval-augmented generation (RAG), and structured output generation from technical reports.

  • Develop Intelligent Document Processing (IDP) capabilities for the long-form, table-heavy, multi-format documents that characterise TDD, ESDD, owner's engineering and lender's advisory engagements.

  • Build Power BI dashboards and semantic models that translate AI/automation outputs into executive-ready insight for internal stakeholders and clients.

  • Explore and prototype Agentic AI patterns (tool-use agents, planner–executor, multi-agent orchestration) for consulting workflows where they offer step-change value.

  • Embed Responsible AI practice into every solution — including source citation, verifiable reasoning, output guardrails and alignment with frameworks such as the EU AI Act, ISO/IEC 42001 and the NIST AI RMF.

Enable — adoption, training and stakeholder engagement
  • Drive adoption of AI and automation tooling across CPD through training sessions, workshops, lunch-and-learns and written enablement materials.

  • Act as a trusted internal advisor to project managers, technical leads and Partners on where AI and automation can credibly improve delivery quality, speed or margin.

  • Run discovery and requirements-gathering workshops with stakeholders across CPD to identify, scope and prioritise candidate use cases.

  • Apply a product mindset — defining MVPs, iterating on user feedback, and managing a backlog of CPD AI/automation initiatives.

  • Contribute to ERM's wider AI Champions network and CPD technical communities, sharing learnings and reusable patterns across the firm.

Deliver — billable client engagements (TDD attachment)
  • Retain an active attachment to the TDD subteam, contributing to fee-earning client engagements (renewables, energy infrastructure and adjacent capital projects).

  • Identify and deliver client-facing AI/automation workstreams within TDD and broader CPD engagements — supporting proposal scoping, pricing inputs and delivery.

  • Apply a commercial mindset, recognising opportunities to extend or secure billable client work through differentiated AI-enabled delivery.

What we're looking for

  • Degree (or equivalent) in a sustainability-related, environmental, engineering, scientific or quantitative discipline, with demonstrable analytical and data-driven capability; 1–2+ years of consulting, technical, data or related experience.

  • Strong hands-on development skills in Python and SQL, with practical experience building data and AI pipelines end-to-end (ingestion → transformation → modelling → delivery).

  • Working proficiency in Microsoft Fabric — Lakehouse, Delta Lake, notebooks, Dataflows Gen2 and pipelines — in line with ERM's strategic adoption of the integrated Fabric Data Platform.

  • Strong Power BI skills, including semantic modelling, DAX, and the design of executive-ready dashboards and reports for non-technical audiences.

  • Demonstrable experience applying LLMs and/or ML to real workflow problems — e.g. document extraction, classification, summarisation, retrieval-augmented generation (RAG), structured output generation.

  • Familiarity with the wider Microsoft 365 and Power Platform ecosystem — Copilot extensibility, Power Automate, SharePoint/OneDrive, and Microsoft Graph — and how to compose them into low-friction business solutions.

  • Awareness of Agentic AI concepts (e.g. tool-use agents, planner–executor patterns, multi-agent orchestration) and a clear appetite to develop hands-on agent-building skills within the role.

  • Product mindset: comfort with requirements gathering, stakeholder engagement, MVP scoping and iterative delivery — whether evidenced through formal training (e.g. a recognised AI/product apprenticeship, ongoing or completed) or applied project experience.

  • Awareness of AI governance and Responsible AI frameworks (EU AI Act, ISO/IEC 42001, NIST AI RMF or equivalent) and a practical approach to embedding them in delivery — for example, requiring AI systems to cite verbatim sources and explain their reasoning as a baseline observability pattern.

  • Excellent written and spoken English; ability to translate technical concepts for non-technical audiences, including senior client stakeholders.

  • Right to work in the UK.

Desirable
  • Direct experience in capital-projects, infrastructure, energy or environmental consulting — particularly Technical Due Diligence (TDD), ESDD, owner's engineering or lender's advisory engagements — with an understanding of the document types, deliverable formats and client expectations specific to those workstreams.

  • Experience designing and delivering training, workshops, lunch-and-learns or enablement programmes to upskill technical and non-technical colleagues on AI/automation tools.

  • Familiarity with Intelligent Document Processing (IDP) techniques — layout-aware parsing, table extraction, OCR pipelines, and downstream LLM-based structuring of unstructured documents.

  • Exposure to LLM evaluation and observability practices — e.g. eval harnesses, output guardrails, LLM-as-judge patterns, or production-grade frameworks such as Azure AI Foundry's evaluation suite — with appetite to develop these as a discipline within the role.

  • Working knowledge of at least one other European language, useful for engaging with EMEA project teams and clients.

  • Active engagement with internal or external technical communities — e.g. ERM's AI Champions network, internal Teams communities of practice, technical blogs, or open-source contributions in AI/ML.

  • Current or recent participation in a recognised AI/product apprenticeship or structured programme (e.g. "AI for Business Value" or similar) — including exposure to product management, stakeholder engagement, requirements gathering and AI governance.

#LI-SG2

#LI-Hybrid

ERM is committed to creating an inclusive workplace where everyone feels valued, respected, and empowered to thrive, it’s an essential part of what makes ERM a great place to build a career and helps us create better solutions for our clients.

We welcome talent from all backgrounds and provide equal opportunities for every candidate. If you have a disability, are neurodivergent, or need accommodations during the selection process, we’re here to support you. Our commitment doesn’t stop at hiring. Once you join us, we’ll ensure you have the tools, support, and adjustments needed to succeed and feel a true sense of belonging. Learn more about our Diversity, Inclusion & Belonging (DIB) efforts by visiting our website or exploring our 2025 Sustainability Report..

ERM Edinburgh, Scotland Office

6th Floor 102 West Port, Edinburgh, Scotland, Edinburgh, United Kingdom, EH3 9DN

Similar Jobs

2 Hours Ago
Hybrid
Mid level
Mid level
AdTech • Cloud • Digital Media • Information Technology • News + Entertainment • App development
Designs and supports end-to-end digital asset management and media supply chain workflows, API integrations, metadata and ETL architectures, automations, and AI/ML-enabled operational solutions. Partners with business stakeholders, clients, product, engineering, operations, and vendors to translate requirements into scalable content workflows. Responsibilities include ingest, metadata enrichment, QC, transcoding, delivery, archival, troubleshooting, documentation, platform support, and vendor coordination.
Top Skills: Adobe Creative SuiteAdobe Media EncoderAirtableAsperaAvid Media ComposerAWSAws Elemental MediaconvertAzure Logic AppsBatonCapmateCaptioncreatorEtlworksEvertz MediatorFinal Cut ProFrame.IoGitGraymeta IrisJavaJIRAJSONMcpMicrosoft Copilot StudioMicrosoft Power AutomateOrange Logic DamPythonQibbQuasarRest ApisSalesforceServicenowSigniantSmartsheetSwitchTelestream VantageTimedtext FlipVisual Studio CodeXMLYaml
2 Hours Ago
In-Office
Expert/Leader
Expert/Leader
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead and scale a Strategic Account team across EMEA, set segment vision and execution, manage pipeline/forecasting, drive enterprise deal strategy, build executive relationships, and recruit/coach top sales talent while partnering across CS, Marketing, and Product.
2 Hours Ago
In-Office or Remote
Senior level
Senior level
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead EMEA regional marketing for DX by turning account intelligence into tailored ABM programs and executive-level activations. Own account engagement plans, run executive roundtables and VIP events, design region-specific activations around global moments, produce localized content and webinars, and act as the EMEA voice into global marketing to ensure programs resonate and drive pipeline.

What you need to know about the Edinburgh Tech Scene

From traditional pubs and centuries-old universities to sleek shopping malls and glass-paneled office buildings, Edinburgh's architecture reflects its unique blend of history and modernity. But the fusion of past and future isn't just visible in its buildings; it's also shaping the city's economy. Named the United Kingdom's leading technology ecosystem outside of London, Edinburgh plays host to major global companies like Apple and Adobe, as well as a growing number of innovative startups in fields like cybersecurity, finance and healthcare.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account