Financial Data Analyst

About us Avencia Consulting are recruiting on behalf of a leading Specialty Reinsurer based in the City, who are looking to hire a Financial Data Analyst to join on a permanent basis. Across product lines and geographies, they focus on three diversified pillars: reinsurance, specialty and bespoke solutions. We are truly diversified. Our long-standing partnerships with capital providers and quota share partners make us nimble. Our breadth of expertise and capabilities deliver outstanding market returns. The role Reporting to the Head of Technical Accounting, the Financial Data Analyst will be responsible for providing reporting and data analytics for the Finance users. The successful candidate will be expected to work directly with the business to understand their business processes. By combining this process understanding with an understanding of data manipulation and analysis, the successful candidate with be expected to create innovative reporting and data integration solutions that enhance the business. Key accountabilities Working with the Finance team to analyse their existing data and improve their data integrations Investigating, evaluating, and making recommendations for improvements to current and new reporting, analysis and data integration enhancements to Fidelis' data ecosystem Effective documentation of relevant schemas and reports in order to mitigate business risks Work with the IT team to ensure the technology environments are properly supported, fit for purpose, and kept up to date Develop and build additional database reports to automate existing finance extract and allocation processes.Skills & experience University Degree in Information Systems, Computer Science, Finance, Accounting, Economics, Mathematics or a related technical discipline. Experience in the financial services industry; Insurance/Reinsurance experience preferred Demonstrated understanding of Accounting principles Excellent Microsoft Excel skills; knowledge of Excel VBA a plus Excellent communication (verbal and written) and interpersonal skills, and an ability to effectively communicate with both business and technical teams Must have at least 5 years SQL Server query building experience; Experience with large datasets and data warehouse experience is a plus Must have demonstrated expertise of Microsoft SSRS and Microsoft PowerBI; FlexMonster is a plus Ability to work in a fast paced, agile development environment