Description
Sopra Steria Recruitment is working in partnership with a major public sector client in the UK. We are currently recruiting a Financial Data Modeller for an initially 9 month contract with a possibility of extension based in Newcastle upon Tyne.
Please find the job responsibilities below:
- Data gathering, cleansing and analysis from various systems and sources in order to inform financial modelling.
- Gathering information on the gateway check processes to inform the current decision making process on case allocation and any feedback loops;
- Extracting information from the time recording system on cases, types, bands, volumes and average case hours as well as caseworker effort by grade and band of case;
- Extracting information from MCMS on project costs, type and other indicators that drive fee band;
- Obtain information from Marine Licensing on current casework utilisation rates and processes;
- Extracting information on relevant costs in line with Managing Public Money guidance, including staff costs, direct and overhead costs;
- Compiling and presenting the above data into combined data sets as required to then use as the basis for financial modelling.
- Financial Modelling, impacting proposed Better Regulation changes
- Refresh the existing model structure with the above data sets in order to review the cost per hour with the Fees and Charges remaining in its current state;
- Model scenarios factoring in impacts from Better Regulation proposals, Audit and Risk Committee recommendations and any other scenarios as appropriate in order to identify options requiring further evaluation;
Required skills:
- Previous experience of working across various IT platforms and data sources in order to extract datasets;
- Experience of modelling complex and large datasets with multiple variables and scenarios;
- Previous legislative experience and knowledge of Managing Public Money and HMT guidelines;
- Strong problem solving, analytical and report writing skills;
- Ability to communicate with a wide range of internal and external stakeholders.
Apply now to know more!