Senior Assistant Data Analyst

A central resource to support the Company’s primary functions of underwriting, claims, finance, actuarial and . Providing the business with data expertise and reporting to empower and guide business decisions. Maintain oversight of data governance and to establish and operate appropriate controls and reconciliations to ensure data integrity. Support the development and maintenance of the data warehouse and reporting tools in conjunction with software and services vendors. Provide the data needed for corporate and external regulatory reporting requirements in all applicable territories.

• Conduct detailed data/business analysis on business processes and requirements, identify requirements for specific use cases, and produce high-quality documentation that is clear, concise, and accessible to business and technical audiences.
• Learn about the business to assist and improve upon the reporting and data collection tools already in place.
• Develop tools and dashboards to deliver data for all teams across the company.
• Creating regular and ad-hoc analyses of large datasets to produce a deeper understanding of the insurance portfolios.
• Communicate between internal departments and external parties, acting as a 'translator' where necessary to convey requirements and support the organisation's needs.
• Support the maintenance and development of the reporting estate, automating processes and delivering high-quality reports using the most appropriate BI tools.
• Training of junior team .
• Oversight of workflow within the team and ensuring deadlines are met.
• Potential for travel to other company offices (overseas) as required.
• Build strong productive relationships with the business, IT teams and external third parties in order to deliver effective solutions.
• Working and functioning as a pivotal part of the change team, ensuring that technology is at the heart of our business.
• Support in the prioritisation of issues and changes.
• Working closely with our Project Management Team to contribute to project planning

• Five or more years of experience in data analytics
• Advanced knowledge of Microsoft Excel including VBA, Power Pivot.
• Advanced knowledge of data programming languages (SQL – required, familiar with Python)
• Experience working with data visualisation/dashboarding tools (Power BI, DAX and M formula).
• Understanding of data warehousing, ETL processes & data quality assurance a plus.
• Advanced knowledge of data analytics, cleaning and preparation.
• Experience using a range of data modeling and data analysis tools. (SSMS)
• Insurance experience within the London and US Markets
• Exposure to London Market and US NAIC Minimum Standards.
• Demonstrable ability to fully understand business processes and business needs.
• Knowledge of Insurance business processes and functions.
• Experience capturing, documenting and delivering detailed documentation and requirements upon technical and highly integrated business systems.
• Strong interpersonal skills with a proven ability to communicate effectively with stakeholders at various levels, both verbally and in writing.
• Creative problem solving skills.
• Outcome focused, self-motivated, flexible and enthusiastic.
• Ability to work within and promote a diverse and inclusive culture.