Role: Junior Data Engineer

I.T. & Communications
Midlothian
January 14, 2026
£40000 - £40000
Permanent
Urgent

Job Description

Company Overview

NCM are an independent company providing fund administration, regulated operator and depositary services to UK private equity, real estate, venture capital, debt and other alternative investment funds.
We operate from offices in Edinburgh, London and Jersey.

Role Overview

We are seeking a proactive and detail-oriented Junior Data Engineer to join our growing team. This role is ideal for someone who enjoys solving technical challenges, learning new technologies and collaborating across the business to deliver impactful data solutions.
The successful candidate will work closely with stakeholders to design and implement scalable data processes, ensuring accuracy, reliability, and performance across systems. They will contribute to building and maintaining data models, dashboards, and automation workflows that enable actionable insights for the organisation.
This position requires strong analytical thinking, technical problem-solving skills, and a passion for continuous learning. The Junior Data Engineer will play a key role in optimising data infrastructure, supporting business intelligence initiatives, and exploring emerging technologies to drive innovation. A background in Computer Science, Data Engineering, or a related STEM field-or equivalent practical experience-is highly desirable. Familiarity with SQL, Python, cloud-based data platforms (such as Azure), and data modelling tools like Power BI or Tableau will be advantageous.

  • Collaborate with stakeholders to understand requirements and translate into scalable technical solutions
  • Develop, maintain, and enhance data flows between internal systems
  • Monitor and maintain system performance, data accuracy, and data refresh reliability
  • Support the design and optimisation of Azure SQL tables, views and stored procedures
  • Build and maintain Power BI + Tableau data models, reports, and dashboards to deliver actionable insights
  • Use available integration tools to streamline manual processes and automate data movement
  • Document workflows, data structures, and automations to ensure maintainability and knowledge transfer
  • Explore emerging technologies – including AI – to enhance business
  • Technical problem-solving: able to investigate, troubleshoot, and resolve data or automation issues logically
  • Analytical thinking: understand data relationships and how to model effectively for analysis
  • Adaptability: eager to learn new tools and technologies to tackle new challenges in a fast growing business and enjoy continuous learning
  • Collaboration: comfortable working closely with both technical and non technical colleagues at all levels of seniority
  • Communication: able to explain technical solutions clearly and concisely
  • Accountability: takes ownership of assigned systems and tasks, ensuring reliability and quality
  • Quality driven: have an eye for detail and aesthetics

Experience & Qualifications

  • Computer Science, Information Systems, Engineering, Data Science/AI (or related STEM field qualifications) OR a strong portfolio/project experience demonstrating practical capability in the relevant tools
  • 1 3 years of relevant industry experience
  • Familiarity with Microsoft 365 and SharePoint data environments (FIS Private Capital Suite (formerly Investran) is a plus)
  • Strong Excel and data manipulation skills (SQL, Python, R is a plus)
  • Understanding of cloud based data platforms (e.g. Azure, GCP, AWS etc) and data aggregation from various sources with the use of API’s
  • Experience automating workflows and tools
  • Experience with SSMS, VS Code, Azure Data Factory
  • Understanding of data modelling in Power BI/Tableau
  • Experience developing on the Power Platform
  • Understanding of data architecture principles, database management, and data governance
  • Experience in web/platform development is a plus (CSS/HTML)

At NCM Fund Services, we are committed to diversity, equal opportunity and promoting a respectful and inclusive workplace. We encourage individuals from all backgrounds to apply for this position.

Location

Related Jobs