Company Description
Evelyn Partners is the UK’s leading integrated wealth management and professional services group, with over 186 years of experience in helping generations of people and businesses to thrive. We offer an extensive range of financial and professional services to individuals, family trusts, professional intermediaries, charities and businesses.
We provide an award-winning service for our clients by employing the best people. Join us on our mission to place the power of good advice into more hands because we believe that everyone deserves access to good advice, regardless of where they’re at in their financial journey.
An exceptional track record of growth and innovation is driven by our core values of: Personal, offering advice based on a true understanding of what matters to our clients; Partnership, working with our clients in a joined-up, collaborative way; and Performance, demonstrating a breadth and depth of advice expertise to deliver first-class results.
Read more about us and available career opportunities here: and
Job Description
Job Purpose
The purpose of this role is to provide insightful, accurate and impactful dashboards and reporting across the Professional Services (PS) business.
This successful candidate will be required to work from our Bracknell office at least 2 days per week.
Key Responsibilities
1. Design, develop, and deploy BI data solutions across PS by developing data models and pipelines and reports, Power BI dashboards, and KPI scorecards
2. Overseeing and creating where necessary complex tabular models, including SQL database development to store data in a manageable reporting format.
3. Using SQL Server Analysis Services (SSAS) for larger data models, including complex DAX.
4. Business Analysis and requirements gathering with stakeholders to design the best technical solution and translate to team for development.
5. Creating automated sustainable reporting solutions and identifying improvements in existing processes to enhance efficiency and tackle technical debt.
6. Monitoring security in Power BI and incorporating Row Level Security (RLS) into data models.
7. Creating Power BI Gateways, Workspaces and Apps. Ensuring that appropriate access is applied.
8. Documenting processes, database models, and architecture plans.
9. Bring together multiple data sets into defined and sustainable solutions to deliver ‘one source of truth’ to the business.
10. Work closely with different teams across the business to improve data literacy and empower teams with the right tools, reports and guidance to leverage insight to make better informed decisions
Qualifications
Key Skills and Experience
11. Strong experience with MS Power BI & DAX.
12. Strong experience in SQL for querying, analysis, and optimisation.
13. Experience using Microsoft Development (Visual Studio) tools to develop and manage database & BI projects.
14. Understanding of best practices to deliver compelling data visualisations & reports.
15. Understanding of industry-standard data warehousing modelling techniques
16. Knowledge of ETL using a variety of data sources
17. Ability to work independently and within a team
18. Good communication skills both written and verbal.
19. Understands processes, data and strategic priorities.
20. Has the ability to design solutions that meet user needs, allowing for design and ethics standards.
21. Work towards the successful delivery of products and establish maintenance requirements.
Professional Qualifications and Education
22. STEM preferred but experience above more essential.
23. PowerBI certifications preferred.
Additional Information
As a colleague here at Evelyn Partners, you will have access to benefits that include:
24. Competitive salary
25. Private medical insurance
26. Life assurance
27. Pension contribution
28. Hybrid working model (role dependant)
29. Generous holiday package
30. Option to purchase additional holiday
31. Shared parental leave
We are proud to value the differences that a diverse workforce brings, representative of society and our clients. At Evelyn Partners we have a wide range of highly active employee resource groups and we’re delivering multiple diversity, equity and inclusion initiatives across the organisation. It is our commitment to provide a workspace where all colleagues, regardless of identity, background, or circumstance, feel respected as individuals and feel that they can achieve their full potential and work in a safe, supportive, and inclusive environment.
We are happy to make any reasonable adjustments to accommodate for your needs throughout the application process. Please let your Recruiter know.