Data Analyst

Role & responsibilities

The candidate would be a part of a multi-disciplinary function which encompass technical pricing, claims reserving, data analytics, visualization and data administration, and would be responsible for the development, maintenance and support of Business Intelligence applications and reporting. The specifics include,

• Manage monthly load processes to ensure the delivery of accurate and timely data to key stakeholders
• Support the collection and maintenance of pricing/reserving data
• Support exposure and accumulation control methodologies. Download, refresh, query and integrate third party peril data sets
• Provide support to underwriting teams on data queries and enhancements. Recommend initiatives to enhance underwriting profitability. Measure impact of underwriting actions, rate change, renewal retention, new and lost business
• Provide support to team members when SQL or Python expertise is required
• Develop/maintain ETL packages to load data into SQL databases to ensure the delivery of accurate, clean data to key stakeholders
• Recommend initiatives to enhance and streamline existing processes
• Ensure accuracy, timeliness, reporting and documented procedure for workflow management
• Keep abreast of industry initiatives, new visualisation methods and best practice
• Develop/enhance new/existing dashboards using Power BI or similar platforms
• Optimise database integrity, scalability and security
• Ensure data quality is to the highest standard, reconciled and fit for purpose
• Identify opportunities that can improve efficiency of business processes
• Act in accordance with agreed service standards and report complaints effectively in line with the companys professional standards manual
• Act as a role model to others for conducting business in accordance with the company ethos and values and in an ethical manner & comply with the AJG Professional Standards Manual
• Take all reasonable steps to ensure the part of the business for which you are accountable for demonstrably complies with applicable laws, rules, regulations, good governance and Gallaghers shared values, in particular, putting clients at the heart of our business. If shortcomings are identified take responsibility for remedial action planning, and action in conjunction with the relevant experts within the firm.

Preferred candidate profile

• Graduate/post-graduate.
• Strong knowledge of Python and SQL (essential).
• Good knowledge of MS Office especially Excel
• Knowledge around Power BI (would be advantageous).
• Ability to translate business requirements into practical solutions
• Able to communicate effectively with key stakeholders
• Strong analytical and problem-solving skills
• Ability to manage large data sets
• Ability to work collaboratively in a team environment and adapt to changing priorities.
• Excellent communication and collaboration skills, meeting common goals with colleagues across matrix environments
• Ability to plan and organize work to meet targets and deadlines
• Ability to use negotiation and persuasion to achieve solutions to complex situations, both internally and externally