At a Glance
- Tasks: Analyse data to drive business growth and improve performance in insurance schemes.
- Company: Join Hiscox, a leading brand in the insurance market known for innovation.
- Benefits: Flexible working, diverse culture, and opportunities for professional development.
- Other info: Collaborative environment with a focus on continuous improvement and innovation.
- Why this job: Make an impact by influencing strategic decisions with your analytical skills.
- Qualifications: Experience in analytics, insurance knowledge, and proficiency in SQL or Python.
Build a brilliant future with Hiscox.
About Hiscox: Hiscox UK is a leading brand in the insurance market, recognised as setting the standards others try to emulate. We consistently deliver strong growth and exceptional returns, recruiting only the very best and empowering them to deliver. We are known for insuring the homes of the rich and famous through to the most innovative technology companies. Our customers are diverse and unique and are only united by our ability to provide specialist insurance tailored to their needs.
The role: We have a market leading reputation for producing bespoke solutions for niche customer groups managed by our broker partners. Within the wider Schemes team, we deliver Schemes (Delegated Authorities and MGA) solutions across the UK retail business. You’ll work across the existing portfolio of Schemes (and Delegated Authorities) business as well as analysing the impact of new Schemes opportunities. You’ll work with the wider Schemes Team across underwriting, operations and sales delivering analytics and business insights to influence business decisions and drive the performance objectives of the Schemes business in support of our Active Performance and Portfolio Management ambitions. You will ensure alignment with the wider Hiscox UK business including, Pricing and Portfolio Management, the Insurance Analytics team and Underwriting & Distribution management, ensuring alignment with wider Hiscox UK strategy. You will report directly to the Schemes and MGA – Portfolio Analyst Team Lead and you will have responsibility for influencing the design and delivering our performance and portfolio management strategy in support of driving improvement and profitable growth to schemes. You will play an integral part in realising our ambitions of growing the portfolio in line with our strategic plans.
What you’ll be doing:
- Providing an independent review and recommendation for underwriting on large existing Schemes and MGA’s.
- Deploying analytical skills to assess new schemes opportunities, working in close collaboration with our Delivery Underwriters in support of our profitable growth ambitions and our service commitments.
- Completing all other relevant ad hoc and deep dive data analysis including underwriting referral analysis and making recommendations for improvements.
- In conjunction with the underwriting and Schemes Leadership team, and working closely with the analytics function, you will be designing and developing the data standards relevant for your sector.
- Using data visualisation tools to design and build a reporting suite to enable the Schemes Sector to actively monitor the performance and portfolio trends and produce on an ongoing basis our monthly and quarterly suite of reporting.
- Using your analytical skills to spot trends in the Schemes performance and provide insight and recommendations for changes to strategy in support of delivering on our strategic goals and profitable growth targets.
- Supporting innovation and continuous improvement and looking for opportunities to implement data, reporting and process improvements across Schemes Sector.
- Conducting data analysis to spot trends and recommend the necessary corrective action and opportunities for profitable growth within the existing portfolios in your sector.
- Applying knowledge of the regulatory environment to all portfolio decisions and ensuring recommendations result in our customers being treated fairly and consistently in line with Hiscox values.
- Working closely with a wide range of interested stakeholders to deliver a consistent and accurate suite of reports across a wide range of business performance metrics including deal conversion and decline data, underwriting loss and combined ratios, portfolio mix, claims frequency, large loss analysis etc.
Our must-haves:
- Experience in a similar analytical role, using data and insights to identify trends, evaluate performance and make recommendations that drive business growth and improvement.
- Experience within insurance, ideally within Schemes, MGA, Pricing, Portfolio Management or an analytical function supporting underwriting decisions.
- Experience using data analysis tools such as Python, R or SQL and data visualisation tools including Power BI.
- Proficient in applying analytical techniques to extract meaningful trends and make recommendations.
- Ability to make confident decisions in difficult and complex situations.
- Strong interpersonal skills and ability to operate in a collaborative environment.
- Excellent numerical, analytical and data manipulation skills.
- Results driven, ability to make decisions and operate on own initiative.
- Ability to execute and influence at all levels both internally and externally.
- Open to new ideas, innovation and educated risk taking.
- Excellent communication skills with ability to articulate the complex to technical and non-technical audiences.
Diversity and flexible working at Hiscox: At Hiscox we care about our people. We hire the best people for the job, and we’re committed to diversity and creating a truly inclusive culture, which we believe drives success. We also understand that working life doesn’t always have to be ‘nine to five’ and we support flexible working wherever we can. No promises, but please chat to our resourcing team about the flexibility we could offer for this role.
Work with amazing people and be part of a unique culture.
Location: London; York; Colchester
Type: Full time
Senior Portfolio Analyst SQL in London employer: Hiscox AG
Hiscox is an exceptional employer, renowned for its commitment to diversity and inclusion, fostering a collaborative work culture that empowers employees to excel. With flexible working options and a focus on professional growth, employees are encouraged to innovate and contribute to bespoke insurance solutions in a dynamic environment. Located in vibrant cities like London, York, and Colchester, Hiscox offers a unique opportunity to work alongside talented professionals while making a meaningful impact in the insurance industry.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Portfolio Analyst SQL in London
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Hiscox AG. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Senior Portfolio Analyst SQL in London
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Hiscox AG.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Hiscox AG's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Hiscox AG
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Hiscox AG.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Hiscox AG will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Hiscox AG employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
