BI Developer

Arc Legal Assistance is a specialist provider of legal expenses insurance and related services. 
Based in Colchester, we work with insurers, intermediaries, financial institutions and affinity groups, focusing upon delivering bespoke solutions providing 'best in market' legal advice and case handling.

Our business model for legal expenses insurance involves outsourcing legal advice and the legal conduct of claims to top quality law firms.

Purpose of the role

To work as part of an agile development team, building detailed financial, claims, and complaints reports for internal and external business analysis. The role encompasses both front-end and back-end development and all stages of the product lifecycle. The successful applicant will have a proactive attitude to continuous improvement, identifying and raising product improvements with particular attention to system performance, as well as enthusiasm towards reporting generally and a desire to keep up to date with industry best practices.

Main tasks

Report development:

  • ETL design and development
  • Designing advanced reports in SSRS (financial, internal, external MI)
  • Data warehouse design and development (dimensional schema)
  • Complex T-SQL scripting with Microsoft SQL Server
  • T-SQL and database schema optimisation
  • Books and attends meetings with the business to gather requirements and design solutions

Participating and contributing to the agile development process:

  • Plays an active role in retrospectives, backlog reviews, planning, code reviews, and testing
  • Documentation of implementation and report logic
  • Works to deliver a continuously releasable codebase
  • Uses the Atlassian product suite, including JIRA, FishEye, Bamboo, and Confluence
  • Uses Git for source code version control, regularly merging in stable code changes


  • Third line support, problem solving, ad-hoc scripting of data fixes, and data extraction
  • Performance improvement, optimisation, and T-SQL refactoring
  • Other duties and responsibilities as may be set by the Technical Services Manager

Experience and person specification


  • Experience of SSRS, including parameters, shared datasets, sub-reports, matrices, conditional groupings, conditional formatting, pagination, drilldowns, and visibility
  • Experience of SSRS report manager and basic knowledge of report server
  • Experience of T-SQL, including parameters, temp tables, grouping, and window functions
  • Experience of MSSQL, including stored procedures, views, functions, synonyms, and indexes
  • Experience of SSAS and SSIS
  • Experience of ETL processes
  • Delivery focussed
  • Ability to own tasks
  • Excellent verbal and written communication
  • Enthusiasm for software development, reporting, and data analysis
  • Experience of working in a professional software development team
  • Team player
  • Keen focus on quality of work and lean, simple code that meets requirements


  • Experience of Power BI, SSAS, and/or Azure, all of which we aim to use in the future
  • Knowledge of Crystal Reports, for migration to SSRS
  • Application development with C# .NET, and WPF
  • Computer/technical related university degree, 2:1 or above
  • Working knowledge of Legal Expenses Insurance
  • Experience of agile development, continuous improvement, and the Atlassian product suite

Call us on 0344 770 9000