PC5 Regulatory Capital Reporting Analyst

Your new company This company is a reputable organisation within the public sector based in Cork. Your new role Design and develop the annual regulatory monitoring reports on capital costs, outputs and schedule including detailed Excel models and summary KPI-type reporting.Develop a strawman proposal for the structure and contents of the detailed Transmission and Distribution data books (BPQs). Ensure the proposed structure covers the CRU requirements and is based on an appropriate data model that allows the presentation of disaggregated data that aligns with high level reporting.Analyse and understand the existing data model for alignment of actual and forecast costs, outputs and schedule for the capital portfolio. Develop the data model further to ensure it is future proofed and enables the required disaggregated and aggregated regulatory reporting.Document the data model and data dictionary including the maintenance and change management process.Use the data model to align information from multiple data registers and to populate the reports and data books with actual costs and outputs; ensure there are appropriate checks and reconciliation.Leverage technical solutions to minimise the effort required to populate and update the report and document the process.Perform other analysis and reporting as required to support the explanation of cost drivers and efficiencies.What you'll need to succeed Third level qualification in a numerate discipline with at least 5 years relevant experience, ideally in a reporting/financial/analytical/data modelling role.Experience in development of data models and delivery of detailed and KPI type reporting.Proven advanced financial/numerical modelling skills in Microsoft Excel are essential.Data warehouse/Business Objects experience would be an advantage.Good understanding of Business Management Systems and their implementation, and specifically Maximo and Oracle is an advantage.What you'll get in return Currently living in Ireland.Flexible to work onsite in Cork 4 days a week for first month of the role and 2 days a week potentially after.Currently holding an EEA passport or valid Stamp 1G or Stamp 4 visa. (Visa must not expire during contract or is at least renewable).Immediate starter (if possible).