Global Financial & Business Intelligence Analyst (12 month FTC)
- Recruiter
- Career Legal, Legal Finance & Accounting
- Location
- London
- Salary
- £80,000 to £100,000
- Posted
- 09 May 2017
- Closes
- 06 Jun 2017
- Ref
- 909124
- Job Title
- Legal Finance
- Contract Type
- Contract
- Hours
- Full Time
This client is an international law firm with nearly 3000 lawyers in offices across Europe, Middle East, Russia & CIS, North & South America, Far East and Australasia.
Applicants should have previous, relevant industry experience and will be responsible for providing support in relation to the manipulation of financial data and the creation of reporting tools to support global financial reporting, key client reporting and other data-related initiatives.
Responsibilities
Completes MS SQL Administration tasks on Data Warehouse, Reporting and Analysis services
Completes month-end reporting procedures and daily report subscription administration tasks
Provides SQL support to Accounts Systems for ad-hoc data extracts and updates to Elite
Completes administration on ProClarity server and provides support to ProClarity users
Completes design, development and testing of new reporting requirements using SQL, MDX and .Net programming skills
Completes updates and fixes to Data warehouse and ETL process to fulfil changing business requirements
Completes upgrades and changes to utility applications through VB and .Net programming skills
Produces regular month-end reports for the use of global leaders in relation to our global practice and sector groups
Creates reports to track the changes in revenues for key clients as identified by practice and sector groups
Candidate Profile
Strong SQL Server 2008/2012/2016
Advanced T-SQL and complex Stored Procedures
Experienced in developing ETL integration packages using SSIS
Experienced with developing SSRS reports and administering Reporting Services
Strong Excel /VBA skills
Experienced with analysing data and creating dashboards using Pyramid Analytics / Tableau (or similar)
Familiar with data warehousing concepts and Kimball methodology
Working knowledge of SSAS cubes and MDX queries
Important Notice
It is Career Legal’s policy, as a matter of courtesy, to respond to all applications within three working days. However because of the volume of applications, we are sometimes unable to respond to individual candidates. If we have not contacted you within three working days your application has been unsuccessful and your details have not been retained. Please apply for any other position that you may see in the future. Thank you.
Career Legal is a Recruitment Agency and is advertising this fixed term contract vacancy on behalf of one of its Clients.