Junior Data Engineer - SQL Server & Data Platform (6-month fixed term contract

The Junior Data Engineer is a new role within the Business Services Development team, created to help unlock the value of the firm's data and support our long-term Data and AI strategy. Working alongside experienced technology professionals, this role will contribute to the operational support, design, development and maintenance of our data platforms.

The role combines hands-on technical delivery with continuous learning across data engineering, database administration and analytics. Responsibilities include supporting our operations, developing and maintaining data pipelines, supporting SQL Server environments, improving data quality and performance and ensuring business data is secure, reliable and accessible.

This is an excellent opportunity for someone looking to build on their experience and career in Data Engineering. The role provides exposure to Microsoft SQL Server, Azure Data Services, Microsoft Fabric and emerging AI technologies, while working within a collaborative and supportive environment.

• Maintain, monitor Azure database solutions. Investigate data issues and help resolve discrepancies across source systems. Maintain documentation for data flows, database objects and operational support processes.
• Build and maintain solutions to extract, transform, and load (ETL) data from various sources (case management system, document management system, finance system, etc.) into centralised data repositories (data Lakehouse). Ensure pipelines are efficient, reliable, and well-documented.
• Implement a unified data warehouse/data Lakehouse/Medallion Architecture within Fabric/Azure for the business analytical needs. Model structured data (e.g., relational tables in Azure SQL or Microsoft Fabric) to support flexible reporting and analysis, and manage unstructured/semi-structured data (documents, text logs) in a data lake.
• Combine data from on-premises SQL Server and cloud databases, available APIs as well as files and external data, to create a single source of truth for insights.
• Develop pipelines, notebooks and workflows for data cleansing, normalisation, and aggregation. Resolve data quality issues by implementing validation rules and collaborating with data owners to correct source data when necessary.
• Monitor and tune the performance of data queries and pipelines. This includes indexing strategies, query refactoring, partitioning of data, and scaling of Azure resources to meet demand.
• Support data governance best practices, including access controls for sensitive data, data encryption, and compliance with data privacy regulations (GDPR, etc.). Work with IT security and compliance teams to ensure data solutions meet the company’s confidentiality and security standards.
• Stay current with advancements in data engineering, analytics, and AI.
• Handle the day-to-day management of the analytical data infrastructure. This includes scheduling and monitoring ETL jobs, troubleshooting failures or data inconsistencies, and ensuring high availability of critical analytics databases. Provide backup and recovery support and front-line support for data-related inquiries or issues.

• Proficiency in SQL (T-SQL) and strong knowledge of SQL Server (on-prem and Azure SQL). Able to design and optimise relational schemas, indexes, views, and stored procedures for complex data processing.
• Hands-on experience building ETL/ELT workflows. Familiarity with tools like Azure Data Factory, Fabric Pipelines.
• Knowledge of Materialized Lake Views (or similar ETL tools) and Logic Apps for orchestrating data movement and transformation between heterogeneous systems.
• Proficiency in Microsoft Azure data services, including Azure Data Lake Storage, Microsoft Fabric, Medallion Architecture.
• Strong ability in a programming language for data handling, ideally Python & TSQL. Familiar with scripting for automation (Power Shell or Bash). Demonstrated ability to manipulate data through code (e.g., parsing JSON, calling APIs, etc.).
• Knowledge and awareness of No
  
  SQL and Big Data Tools including No
  
  SQL databases (e.g., Cosmos DB, MongoDB) and understanding of when to use them.
• Experience developing reports or dashboards in Power BI (preferred) or similar BI tools (Tableau, Qlik).
• Monitoring & Alerting:
  Implement telemetry, logging, and monitoring for cloud data platforms built on Microsoft Fabric and Microsoft Azure, leveraging Azure Monitor, Log Analytics, and Application Insights to track pipeline health, automate alerts, and ensure reliable operation of data ingestion and transformation pipelines.
• Dev Ops & CI/CD:
  Knowledge of modern software development practices. Comfortable using Git for version control. Experience with CI/CD pipelines (Azure Dev Ops, Git Hub Actions, or similar) to automate deployment of data projects. Understanding of Infrastructure-as-Code (e.g., ARM templates, Terraform) for provisioning data infrastructure.
• Security & Governance:
  Deep appreciation for data security, privacy, and governance. Familiar with…