Data Engineer

DAC Beachcroft•Seekonk, MA

15h

About The Position

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.

Requirements

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

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