Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our Data Engineering team to develop and support our Firmwide BI and Data Platform.
- Company: Addleshaw Goddard is a leading law firm known for its innovative approach and commitment to excellence.
- Benefits: Enjoy a collaborative work environment with opportunities for professional growth and development.
- Why this job: Be part of exciting projects that impact decision-making across the firm while enhancing your technical skills.
- Qualifications: 3+ years in BI development/data engineering, strong T-SQL skills, and experience with Microsoft BI tools required.
- Other info: Ideal for tech-savvy individuals eager to make a difference in a dynamic legal environment.
The predicted salary is between 42000 - 84000 £ per year.
Working within the Firm’s central Data Engineering team in IT, this newly created position will directly contribute to the development of the Firmwide BI and Data Platform, currently comprising a SQL Server 2022 Data Warehouse, Microsoft Fabric, Power BI Semantic Models and an SSRS/Power BI reporting layer. The Data Warehouse services c.500 reports, which are used across the Firm for reporting, analysis and decision support.
The role-holder will be confident working with the full Microsoft BI technology stack and will have strong T-SQL skills to support existing BI databases and models that underpin AG’s management information systems. The ideal candidate will also be confident liaising with end users for gathering requirements and for responding to ad-hoc queries. Knowledge of cloud technologies, such as Azure SQL PaaS, Azure Data Factory, Logic Apps/Power Automate and the ability to make REST API requests would be beneficial.
Specifically, the role will focus on:
-
Development of the Data Warehouse (SSIS / Data Factory / SQL Server) and back-end support of other BI SQL databases and data models (Power BI / Analysis Services Tabular) (60%)
-
Creating / providing support to more complex or advanced BI reporting requests (SSRS / Power BI) (20%)
-
Ad-hoc technical support on any internal project involving BI and data elements (20%), Creating/altering database objects (tables, views, stored procedures) in the SQL Data Warehouse via SSMS
-
Development of SSIS packages / Data Factory pipelines for loading source system data into the Data Warehouse
-
Development of the SSRS / Power BI Paginated reporting solutions
-
Development of Power BI / Analysis Services data models, which act as a semantic layer for the front-end reporting tools
-
Debugging and fixing failed SQL Server Agent Jobs and relating to Data Warehouse / model loading
-
Writing T-SQL queries for ad-hoc interrogation of the Data Warehouse / Data Marts / source system databases
-
Providing guidance to more junior members of the team and advisory to the technical reporting analysts across the business
-
Providing technical support and often leading internal projects on an ad-hoc basis
-
Development of Logic Apps flows for orchestration of the data platform and report distribution
-
Development of Microsoft Fabric data platforms (Data Factory / Lakehouse / Warehouse)
3+ years’ time served in BI developer/data engineering role (Essential)
-
Hands-on development experience with Microsoft Business Intelligence solutions and tools (Essential)
-
Sound understanding of data warehousing and experience of building/maintaining ETL/ELT processes (Essential)
-
T-SQL: able to construct efficient set-based queries with knowledge of all the main DDL/DML functions (Essential)
-
SQL Server Management Studio (Essential)
-
Visual Studio 2019 onwards (Essential)
-
Microsoft SQL Server 2016 onwards (Essential)
-
SSRS / Power BI Paginated: able to build, maintain and debug complex reports with knowledge of drill through and data-driven subscriptions (Essential)
-
SSAS Tabular or similar: able to build and maintain efficient data models in star/snowflake schema (Essential)
-
DAX: able to author formulas for calculated columns/tables and measures in Tabular models (Essential)
-
SSIS package development (Essential)
-
Power BI – Power Query / DAX / Front-end report design / administration of app.powerbi.com (Essential)
-
Logic Apps / Power Automate (Preferred)
-
Basic knowledge of how to make REST API requests (Preferred)
-
Azure Data Factory (Preferred)
-
Git Repository source control (Preferred)
-
Proficient in Microsoft Office packages (Essential)
-
General awareness of business software (e.g. accounting systems, CRM) (Essential)
-
Organised with a proactive approach to work (Essential)
-
High attention to detail (Essential)
Addleshaw Goddard
Data Engineer employer: Addleshaw Goddard
Contact Detail:
Addleshaw Goddard Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Familiarize yourself with the full Microsoft BI technology stack, especially SQL Server, Power BI, and SSIS. Being able to demonstrate your hands-on experience with these tools during the interview will set you apart from other candidates.
✨Tip Number 2
Brush up on your T-SQL skills and be prepared to discuss complex queries you've constructed in the past. Having specific examples ready can showcase your problem-solving abilities and technical expertise.
✨Tip Number 3
Since the role involves liaising with end users, practice articulating technical concepts in a way that non-technical stakeholders can understand. This will demonstrate your communication skills and ability to gather requirements effectively.
✨Tip Number 4
If you have experience with cloud technologies like Azure Data Factory or Logic Apps, make sure to highlight this in your discussions. Even if it's not a primary focus of the role, showing familiarity with these tools can give you an edge.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Understand the Role: Make sure to thoroughly read the job description and understand the key responsibilities and required skills. Highlight your experience with Microsoft BI technology stack, T-SQL, and data warehousing in your application.
Tailor Your CV: Customize your CV to reflect your relevant experience in BI development and data engineering. Emphasize your hands-on experience with SQL Server, SSIS, Power BI, and any cloud technologies like Azure that you are familiar with.
Craft a Strong Cover Letter: Write a cover letter that connects your background to the specific requirements of the role. Mention your ability to liaise with end users and provide examples of how you've successfully handled ad-hoc queries or reporting requests in the past.
Showcase Technical Skills: In your application, clearly outline your technical skills, especially in T-SQL, SSRS, and Power BI. If you have experience with Logic Apps or Azure Data Factory, make sure to include that as well, as it will strengthen your application.
How to prepare for a job interview at Addleshaw Goddard
✨Showcase Your T-SQL Skills
Be prepared to discuss your experience with T-SQL in detail. Highlight specific projects where you constructed efficient set-based queries and how you utilized DDL/DML functions. This will demonstrate your technical proficiency and problem-solving abilities.
✨Familiarize Yourself with the Microsoft BI Stack
Make sure you have a solid understanding of the full Microsoft BI technology stack, including SQL Server, SSIS, Power BI, and Azure Data Factory. Be ready to discuss how you've used these tools in past roles and any challenges you overcame.
✨Prepare for Technical Questions
Expect technical questions related to data warehousing, ETL/ELT processes, and report development using SSRS and Power BI. Brush up on your knowledge of building and maintaining complex reports, as well as debugging SQL Server Agent Jobs.
✨Demonstrate Your Communication Skills
Since the role involves liaising with end users to gather requirements, be prepared to discuss how you effectively communicate technical concepts to non-technical stakeholders. Share examples of how you've successfully collaborated with team members and clients in the past.
