Senior Technical Business Systems Analyst
Type: Permanent – Full Time
Location: London
Oakleaf is thrilled to partner with an award-winning, prestigious city law firm in their search for a Senior Technical Business Systems Analyst. This individual will design, develop, and test enhancements for our data warehouse, reporting (SSRS), and dashboards (Power BI). The role involves building strong relationships across the business to support and enhance current systems, while also being a key contributor to system upgrades and roadmap improvements.
Role Overview
Reporting to the Technical Business Systems Manager, this role collaborates closely with Financial Systems Analysts, Development Analysts, and the wider IT team. You will be instrumental in developing, enhancing, and supporting our finance and business applications. The focus is on data integration, extraction, transformation, and report/dashboard design. You will also support the firm’s business systems, including Elite 3E, Elite Templates, Elite EDI, CreditForce, CRM, and HRIS.
As a technical expert, you will facilitate the use of systems and technology globally, promoting best practices and liaising with senior stakeholders to meet business needs.
Key Responsibilities
* Design, develop, and test data warehouse solutions (Star schema dimensional model), reports, and dashboards (SSRS/Power BI).
* Create, maintain, and enhance data integrations across multiple data stores (IntApp Integrate/SSIS).
* Analyse database content to identify and resolve data integrity issues.
* Serve as a key technical resource for business systems support, enhancements, and customisations.
* Work closely with Finance Systems and Development teams to ensure seamless delivery across the team.
Technical Skills and Experience
* Proven technical expertise in a global law firm.
* Understanding of legal environment business applications.
* Strong SQL skills and experience with ETL processes.
* Experience in designing and building business-facing reports and dashboards using Microsoft tools (SSRS & Power BI).
* Knowledge of the following systems is an advantage:
- Elite 3E, Workspace, Workspace Mobile, Templates (PMS).
- SelectHR (HRIS).
- Interaction (CRM).
- Intapp Open, Integration Builder, Walls (Data management).
Personal Skills
* Excellent verbal and written communication skills; confident in engaging with stakeholders.
* Ability to document complex business requirements and translate them into technical solutions.
* Strong problem-solving skills, with the ability to quickly address issues.
* Proactive and enthusiastic, maintaining high professional standards.
* Highly self-motivated, with a desire to learn new skills.
* Demonstrates strong teamwork, flexibility, and patience.
* Excellent organisational skills and attention to detail.
* Capable of managing multiple tasks and projects under pressure.
