Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support data-driven decisions and develop tools for impactful reporting.
- Company: Dynamic insurance company focused on innovation and collaboration.
- Benefits: Competitive salary, flexible work options, and opportunities for professional growth.
- Why this job: Join a pivotal role in transforming data into actionable insights.
- Qualifications: 5+ years in data analytics with strong Excel and SQL skills.
- Other info: Opportunity to travel and build relationships across teams and locations.
The predicted salary is between 36000 - 60000 £ per year.
Responsibilities include being 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 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. Create 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. Train junior team members and oversee workflow within the team to ensure deadlines are met. There is 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. Work 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 and work closely with our Project Management Team to contribute to project planning.
Qualifications:
- 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
Senior Assistant Data Analyst in City of London employer: W. R. Berkley Corporation
Contact Detail:
W. R. Berkley Corporation Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Assistant Data Analyst in City of London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend events, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your data expertise. Be ready to discuss your experience with tools like SQL and Power BI, and how you've used them to drive business decisions.
✨Tip Number 3
Showcase your problem-solving skills! During interviews, share specific examples of how you've tackled challenges in data analysis or reporting. This will demonstrate your ability to think critically and creatively.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Senior Assistant Data Analyst in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the job description. Highlight your experience in data analytics, especially with tools like SQL and Power BI. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for the Senior Assistant Data Analyst role. Share specific examples of your past work that relate to the responsibilities listed.
Showcase Your Communication Skills: Since this role involves acting as a 'translator' between teams, make sure to demonstrate your strong interpersonal skills in your application. We love candidates who can communicate complex data insights clearly!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and we’ll be able to track your application more efficiently. Don’t miss out!
How to prepare for a job interview at W. R. Berkley Corporation
✨Know Your Data Inside Out
Make sure you brush up on your data analytics skills, especially in SQL and Excel. Be prepared to discuss specific projects where you've used these tools to solve problems or improve processes. This will show that you not only understand the technical side but can also apply it effectively.
✨Understand the Business Context
Familiarise yourself with the insurance industry, particularly the London and US markets. Knowing how data impacts underwriting, claims, and finance will help you articulate how you can add value to the company. Research their current data practices and think of ways you could enhance them.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems or analyse case studies. Practice articulating your thought process clearly and concisely. Use the STAR method (Situation, Task, Action, Result) to structure your answers, showcasing your analytical skills and problem-solving abilities.
✨Showcase Your Communication Skills
As a Senior Assistant Data Analyst, you'll need to communicate complex data insights to various stakeholders. Prepare examples of how you've successfully translated technical jargon into layman's terms in past roles. Highlight your experience in training junior team members and collaborating with cross-functional teams.