Data Engineer

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., * 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.

• 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.