At a Glance
- Tasks: Analyse data and create impactful dashboards using Power BI and SQL.
- Company: Join a forward-thinking company in the insurance and financial services sector.
- Benefits: Enjoy a competitive salary, annual bonus, private medical insurance, and flexible holiday options.
- Other info: Flexible working hours available; great opportunities for career growth.
- Why this job: Make data-driven decisions and influence stakeholders with your insights.
- 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: Insight-Driven Power BI & SQL Specialist in City of Westminster employer: Zurich Community Trust
Join a forward-thinking company that values data-driven insights and fosters a collaborative work culture. With a strong commitment to employee growth, we offer extensive training opportunities in advanced data analysis and tools like Power BI and SQL, alongside a competitive benefits package including a generous pension scheme and private medical insurance. Located in a vibrant area, our flexible working arrangements ensure a healthy work-life balance, making us an excellent employer for those seeking meaningful and rewarding careers in data analytics.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst: Insight-Driven Power BI & SQL Specialist 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 Power BI dashboards and SQL projects. This gives potential employers a taste of what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common data analysis scenarios. Be ready to discuss how you've tackled large datasets and communicated findings to stakeholders. Confidence is key!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Data Analyst: Insight-Driven Power BI & SQL Specialist in City of Westminster
Some tips for your application 🫡
Show Off Your Skills:Make sure to highlight your technical skills, especially with Power BI, SQL, and Excel. 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 application for this role. Use the job description as a guide and align your experiences with what we’re looking for. This shows us you’ve done your homework and are 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 to do!
How to prepare for a job interview at Zurich Community Trust
✨Know Your Tech Inside Out
Make sure you brush up on your Power BI and SQL skills before the interview. Be ready to discuss specific projects where you've created dashboards or transformed data. Practising DAX formulas and advanced Excel functions will also give you an edge.
✨Showcase Your Data Storytelling Skills
Prepare to explain how you've turned complex datasets into actionable insights. Think of examples where you've communicated findings to stakeholders, especially non-technical ones. This will demonstrate your ability to make data relatable and impactful.
✨Familiarise Yourself with Data Regulations
Since understanding data regulations like PII and GDPR is crucial, be prepared to discuss how you've adhered to these in past roles. Showing that you’re aware of compliance will highlight your professionalism and attention to detail.
✨Engage with Stakeholders
Think about times when you've worked directly with stakeholders. Be ready to share how you’ve collaborated within a team to deliver projects on time. This will show your interpersonal skills and ability to work in a dynamic environment.
