At a Glance
- Tasks: Analyse data, create dashboards, and present insights to stakeholders.
- Company: Join a leading firm in the insurance and financial services sector.
- Benefits: Enjoy a competitive salary, bonus, private medical insurance, and flexible holiday options.
- Other info: Flexible working hours with part-time, job-share, or full-time options available.
- Why this job: Make an impact by transforming data into actionable insights in a collaborative environment.
- Qualifications: Degree or diploma in a numerical field; coding experience in SQL and Python required.
The predicted salary is between 50000 - 60000 £ per year.
We prefer candidates with a degree, apprenticeship, or diploma in a numerical discipline such as Mathematics, Statistics, or Data Science. Experience in coding, particularly with SQL and Python, is essential, though other languages are also welcome.
Technical Skills
- Advanced experience with Power BI: Creating and publishing dashboards, data transformation, visual conformity, and DAX formulas.
- Advanced Excel skills: Proficiency with functions including Lookups, Index, Match, Pivot Tables, and visualisations.
- Advanced SQL expertise: Proficient in reading and writing SQL code.
- Experience handling unstructured data: Capable of processing, conforming, and presenting large datasets (1M+ rows).
- Proficiency with the Microsoft O365 suite.
- Snowflake experience: Proficient in managing and manipulating data with Snowflake (and/or SQL) and connecting datasets to Power BI dashboards.
- Strong data analysis skills: Ability to understand, visualise, and trend large datasets to formulate evidence-based hypotheses and communicate findings to stakeholders.
- Data Science / Predictive Modelling: Skilled in using techniques to model past data for future predictions and understanding drivers of trends and patterns (preferable).
Non-Technical Skills
- Proven experience interacting directly with stakeholders.
- Ability to work collaboratively within a team to deliver projects.
- Comfort engaging with stakeholders at all levels.
- Adherence to agreed time‑frames, whether internal or regulatory.
- Understanding of data regulations such as PII, GDPR, and Data Retention.
- Ability to present data and communicate complex technical concepts clearly to non‑technical audiences.
- Experience in insurance or financial services (preferred).
- Prior experience working as part of a data team (preferred).
Benefits
- 12% defined non‑contributory pension scheme.
- Annual company bonus.
- Private medical insurance.
- Option to buy up to an additional 20 days or sell some of your holiday.
Working Hours & Salary
This role is available on a part‑time, job‑share or full‑time basis. Salary: Circa £50‑£60k depending on experience plus an excellent benefits package.
Data Analyst in City of Westminster employer: Zurich Community Trust
As a Data Analyst with us, you'll thrive in a dynamic work culture that values collaboration and innovation. We offer a competitive salary alongside a robust benefits package, including a generous pension scheme and private medical insurance, ensuring your well-being is a priority. With opportunities for professional growth and the chance to engage with stakeholders at all levels, this role is perfect for those seeking meaningful and rewarding employment in a supportive environment.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst in City of Westminster
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your data analysis projects, especially those using SQL, Python, and Power BI. This gives potential employers a taste of what you can do beyond your CV.
✨Tip Number 3
Prepare for interviews by brushing up on common data analysis scenarios. Be ready to discuss how you've handled large datasets and communicated findings to stakeholders. Practice makes perfect!
✨Tip Number 4
Don’t forget to apply through our website! We love seeing candidates who are genuinely interested in joining us at StudySmarter. Plus, it’s a great way to ensure your application gets noticed.
We think you need these skills to ace Data Analyst in City of Westminster
Some tips for your application 🫡
Show Off Your Skills:Make sure to highlight your technical skills in SQL, Python, and Power BI. We want to see how you've used these tools in real-life situations, so don’t hold back on sharing specific examples!
Tailor Your Application:Take a moment to customise your CV and cover letter for this role. Use the job description as a guide and align your experiences with what we’re looking for. It shows us you’re genuinely interested!
Keep It Clear and Concise:When writing your application, clarity is key! Avoid jargon and keep your language straightforward. We appreciate a well-structured application that’s easy to read and gets straight to the point.
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Zurich Community Trust
✨Know Your Numbers
Brush up on your numerical skills, especially in Mathematics and Statistics. Be ready to discuss how you've applied these skills in real-world scenarios, particularly in data analysis or predictive modelling.
✨Show Off Your Coding Skills
Make sure you can confidently talk about your experience with SQL and Python. Prepare examples of projects where you've used these languages, especially in handling large datasets or creating dashboards in Power BI.
✨Master the Tools
Familiarise yourself with Power BI and Excel functions like Lookups and Pivot Tables. Be prepared to explain how you've used these tools to transform data and create visualisations that communicate insights effectively.
✨Communicate Clearly
Practice explaining complex data concepts in simple terms. Think about how you would present your findings to non-technical stakeholders, as this is crucial for the role. Good communication can set you apart!
