With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

Job Summary -

Business Intelligence Analyst needed for an Insurance company to manage and manipulate large data sets, produce reports, and draw actionable insights which you will present to senior stakeholders across the group. In your role as a BI analyst you will work collaboratively with London Market business users, actuarial analysts, and the Business Intelligence team to capture requirements and deliver new Power BI solutions, or to troubleshoot existing reports & perform Data analysis.

You will be the BI Analyst of an agile team for Reporting function and will be involved in delivering stories/epics in a rapidly evolving landscape: including moving of reporting estate to Snowflake cloud & using near of real time updates, Devops and transition reports to PowerBI.

Task & responsibilities -

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

• This is a Business facing role which involves developing links and building effective working relationships with key Business stakeholders from London Markets domain to deliver appropriate business MI.
• Gather & Document Business requirements.
• Perform Data Analysis & Build using T-SQL and SnowSQL.
• Processing datasets to deliver interactive Power BI reports and dashboards.
• Deliver actionable insights to senior stakeholders.

Skills & competencies -

• Demonstrable experience of working in Insurance sector – particularly in London Markets Insurance.
• Excellent knowledge of Power BI, SQL scripting & Excel.
• Knowledge of working with SnowSQL will be highly beneficial.
• Proven experience of performing data analytics.
• Sound understanding of Insurance Business .
• Knowledge and understanding of the underwriting disciplines & concepts within the London Market.
• Understand the Business nature & way that business is conducted in the London Market
• Excellent consulting skills and the ability to work effectively with clients and team members.

Will need to be in London office 3 days / per week .

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.