At a Glance
- Tasks: Analyse data and create impactful dashboards using Power BI and SQL.
- Company: Join a leading firm in the insurance and financial services sector.
- Benefits: Enjoy a competitive salary, annual bonus, and private medical insurance.
- Other info: Flexible working hours with part-time and job-share options available.
- Why this job: Make data-driven decisions that influence real-world outcomes.
- 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 employer: Zurich Community Trust
As a leading employer in the financial services sector, we offer a dynamic work environment that fosters collaboration and innovation. Our commitment to employee growth is reflected in our comprehensive benefits package, including a generous pension scheme, private medical insurance, and flexible working options. Join us to leverage your data analysis skills in a supportive culture that values your contributions and encourages professional development.
StudySmarter Expert Advice🤫
We think this is how you could land Data Analyst: Insight-Driven Power BI & SQL Specialist
✨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 questions and scenarios. Be ready to discuss how you've tackled large datasets and communicated findings to stakeholders in the past.
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining our team. Plus, it makes it easier for us to keep track of your application.
We think you need these skills to ace Data Analyst: Insight-Driven Power BI & SQL Specialist
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 projects, so don’t hold back on the details!
Tailor Your Application:Customise your CV and cover letter to match the job description. Use keywords from the listing, like 'data analysis' and 'stakeholder engagement', to show us you’re a perfect fit for the role.
Be Clear and Concise:When writing your application, keep it straightforward. We appreciate clarity, so avoid jargon and make sure your experience shines through without unnecessary fluff.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates from our team!
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, and don't shy away from showcasing your DAX formula expertise.
✨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, and how you made those concepts clear and relatable.
✨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. This shows that you not only know your technical stuff but also respect the legal side of data handling.
✨Engage with Stakeholders
Demonstrate your experience in collaborating with different teams and stakeholders. Share examples of how you've worked together to deliver projects on time, and highlight your comfort in engaging with various levels within an organisation.
