Job 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.
- Is also willing to take ownership on 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 in 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
About DAC Beachcroft
We are a leading international legal business with over 3,000 colleagues and a diverse range of capabilities. We are market leaders in insurance, health and real estate but with a full-service offering, including growing Financial Services and Tech capabilities. We represent a wide range of clients – from household names to government departments and NHS bodies. We act for nearly all of the top-20 UK and global insurers, we're market leaders in the provision of strategic, commercial and regulatory advice to providers and commissioners in the health sector, and in real estate we advise all of the UK’s top-five housebuilders.
We are a fast-growing international business with offices around the globe. In addition to our 11 UK offices, we also have offices in Bogota, Buenos Aires, Dublin, Lima, Los Angeles, Hong Kong, Madrid, Mexico City, Milan, New York, Paris, Rome, Santiago de Chile, and Singapore plus a representative office in Miami and broad network of affiliations across the globe.
At DAC Beachcroft we are committed to and recognise the importance of equity, diversity and inclusion across the board, including and beyond the protected characteristics. We take decisions based solely on merit. We value, welcome and seek out people with different backgrounds and life experiences, perspectives, beliefs, ways of thinking and identities.We are happy to talk flexible working with our Flex Forward scheme. We would encourage you to talk to us about our approach to flexible working during the hiring process if you would like to explore this further.
Note for Recruitment Agencies
DAC Beachcroft manages all vacancies via our in-house recruitment teams, prioritising direct sourcing and referrals. When external support is required, roles are released to selected agencies on our Preferred Supplier List (PSL).
DAC Beachcroft manages all vacancies via our in-house recruitment teams, prioritising direct sourcing and referrals. When external support is required, roles are released to selected agencies on our Preferred Supplier List (PSL).
Speculative CVs sent to any DAC Beachcroft employee without prior instruction from our recruitment teams (LLP and CSG) will not be accepted, and no fees will be payable.
For PSL queries, please contact: recruitment@dacbeachcroft.com or csgrecruitment@dacbeachcroft.com
About DAC Beachcroft
DAC Beachcroft is a leading international legal business with offices across Europe, Latin America, North America and Asia Pacific. We partner with our clients to help them achieve sustainable growth and to defend their business and reputation. We do this by taking a tailored approach to providing commercial, transactional, claims, risk and advisory legal services. We are recognised leaders in Insurance, Health and Real Estate and draw on the knowledge, industry experience and commercial expertise of our outstanding 3,000 lawyers and support colleagues in these sectors and beyond. We are forward-thinking, flexible and easy to engage with and we're proud that our clients tell us regularly that we're great to work with. We know that our clients value advice that is innovative, practical and personal to them, and we pride ourselves on getting to the heart of their businesses. We measure our performance against their expectations and embrace change as a necessary stage in evolving and strengthening our relationships. The close working relationship we enjoy with our clients has not been built overnight but honed carefully over the last 250 years. This means today our clients can remain confident they have the very best legal expertise available.