Data Engineer

DAC Beachcroft; Bristol; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

A leading legal firm in the UK is seeking a Data Engineer to manage and transform data within a legal context. Key responsibilities include collaborating with teams to understand data needs, developing data pipelines using T-SQL and Azure Data Factory, and ensuring data quality. The ideal candidate should have strong T-SQL and SSRS/SSIS skills, as well as experience with Azure platforms. Flexible working options are available, encouraging discussions during the hiring process.

Qualifications

• Proven experience in data engineering with strong T-SQL skills.
• Proficiency in SSRS/SSIS and experience with complex reports.
• Experience with Azure Data Factory (ADF) for data pipelines.

Responsibilities

• Collaborate with team members to gather and translate data needs.
• Design and maintain data pipelines with T-SQL and ADF.
• Develop Power BI semantic models for data visualization.
• Monitor and ensure data quality and accuracy.

Skills

T-SQL

SSRS

SSIS

Azure Data Factory

Power BI

MS Purview

Job description

Description

The Data Engineer plays a critical role in managing, processing, and transforming data to meet business needs in a legal setting. The role involves liaising with internal stakeholders to understand data requirements, building robust data pipelines, and ensuring data quality. The ideal candidate should have solid T‑SQL knowledge, experience with SSRS/SSIS, and familiarity with Azure data platforms, specifically Azure Data Factory (ADF). Experience with MS Purview and migrating from SSRS to Power BI is desirable.

Key Responsibilities

• Collaborate with legal and IT teams to understand data needs and translate them into technical requirements.
• Design, develop, and maintain data pipelines using T‑SQL and Azure Data Factory to ensure seamless data flow.
• Develop and maintain Power BI semantic models; manage the transition to Power BI for advanced data visualisation.
• Support SSIS packages to manage ETL processes and ensure efficient data extraction, transformation, and loading.
• Implement data governance practices, leveraging MS Purview for data cataloguing and compliance.
• Monitor data quality and ensure data accuracy and consistency throughout all stages of processing.
• Provide technical support and training to colleagues on data-related processes and tools.
• Participate in data-related projects, ensuring compliance with legal and regulatory standards.
• Troubleshoot and resolve data‑related issues in a timely manner.
• Take ownership of any other tasks and responsibilities as required.

Skills, Knowledge and Expertise

• Proven experience in data engineering, with strong T‑SQL skills and a solid understanding of database design.
• Proficiency in SSRS/SSIS and experience building complex reports and ETL processes.
• Experience with Azure data platforms, specifically Azure Data Factory (ADF), for data pipeline creation.
• Knowledge of MS Purview for data governance and compliance.
• Experience migrating from SSRS to Power BI is a strong advantage.
• Understanding of data security and compliance in a legal setting.

We are happy to talk flexible working with our Flex Forward scheme. We would encourage you to discuss our approach to flexible working during the hiring process if you would like to explore this further.