Data Analyst

Role overview

Business context

Data delivery and analysis

• Develop, execute, and manage transformation scripts to produce valuation portfolio data.
• Cleanse, profile, map, and mine valuation portfolio data; translate and validate client data.
• Produce CLR-ready valuation portfolio data and ad hoc reports for internal valuation team clients.
• Monitor availability, quality, and consistency of client data used for valuation portfolio deliveries.
• Maintain consistent data formats in line with treaty arrangements and ensure data is good quality and up to date.

Requirements, improvement and collaboration

• Gather business requirements for data and reporting needs and support related process improvements and projects.
• Improve team tools and processes used in valuation portfolio delivery.
• Work with internal clients to understand data content, identify weaknesses, and help correct them.
• Document detailed data requirements using appropriate tools and techniques and ensure agreement across the business.
• Prioritize and organize work, manage colleague expectations, and work independently or collaboratively as appropriate.
• Produce written and numerical materials appropriate to their purpose.

Essential skills and experience

• Professional experience in a Data Analyst role and demonstrable data processing, handling, and analysis skills.
• Experience with SQL scripting, R, Python, Power BI, and advanced Microsoft Excel.
• Experience with a cloud-based data platform such as Azure or Databricks, plus Git and version control practices.
• High numerical and analytical skills.
• Strong root cause analysis and problem-solving skills to investigate and resolve complex data issues effectively.

Desirable experience

• The available description begins a desirable qualification concerning insurance or reinsurance business, but the source text is truncated before the full statement.

Working competencies