Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop stunning Power BI solutions to transform data into actionable insights.
- Company: Join a leading analytics firm with a focus on innovation and collaboration.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with a focus on continuous learning and development.
- Why this job: Make a real impact in the People Analytics space using cutting-edge data visualisation tools.
- Qualifications: 8+ years in business intelligence, with strong Power BI and SQL skills.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking an experienced and highly skilled Power BI expert/Data Visualization Specialist to join our team. You will be responsible for designing, developing, and maintaining complex Power BI solutions to meet the analytical needs of our organization, as well as advising on and maintaining our Power BI architecture and environment.
You will collaborate closely with stakeholders to understand requirements, create visually appealing and insightful reports and dashboards, provide expertise in data ingestion from various sources, data modeling, DAX calculations, data visualization best practices, and provide expertise in setting up Power BI workspaces, dataflows, client-facing applications, and automatic data publication and refresh processes. A key requirement will be helping to create a modular suite of dashboards for maximum configurability, scalability, and re-use.
A strong understanding and sensitivity to the increasingly complex rules around data privacy and local data residency laws will be essential. Partnering with colleagues in other areas including IT, legal and our Digital colleagues will be critical to ensure we work towards a One Korn Ferry approach.
Power BI architecture, environment and dataflows- Establish best practices and standards for managing Power BI artifacts, including reports, datasets, and dataflows within workspaces.
- Configure and manage dataflows to ingest, transform, and prepare data from various sources for analysis within Power BI.
- Develop and implement strategies for automating data refresh processes to keep Power BI reports and dashboards up-to-date.
- Collaborate with data engineers and data scientists to optimize dataflows and ensure data quality and consistency.
- Monitor and troubleshoot data refresh failures, performance issues, and other technical challenges related to Power BI datasets and dataflows.
- Manage Power BI deployment pipelines for development, testing, and production environments.
- Leverage Power BI REST APIs and PowerShell (or similar code environment) to automate CI/CD pipelines for deploying, configuring, and updating numerous dashboards at scale.
- Communicate with data engineering teams on required data views to ensure clean source data / data transformations occurring at the right step of the BI pipeline.
- Develop advanced Power BI reports, dashboards, and interactive visualizations that provide actionable insights and facilitate data-driven decision-making.
- Design and implement efficient and scalable data models using Power BI Desktop and SQL Server Analysis Services (SSAS).
- Write complex M query and DAX calculations to manipulate and transform data for analysis and reporting purposes.
- Integrate Python and/or R scripts, and custom visuals into Power BI for data transformation and data visualization.
- Optimize performance of Power BI reports and dashboards to ensure fast load times and smooth user experience.
- Create and maintain documentation related to Power BI solutions, including data models, calculations, and report designs.
- Provide training and support to upskill other data scientists on how to improve their Power BI capabilities.
- Stay current with industry trends and advancements in Power BI and related technologies and recommend innovative solutions to enhance data analytics capabilities.
8+ years of experience in business intelligence and data analytics, ideally with 5 years of hands-on experience with Power BI.
- Expertise in designing and developing complex Power BI reports and dashboards from scratch, with strengths in creating elegant, highly professional data visualizations.
- Strong understanding of data modeling and data integration concepts and experience building data models using Power BI Desktop and SSAS.
- Proven expertise in designing and implementing Power BI architecture, including workspaces, datasets, and dataflows.
- Proficiency in Power Query M language and writing advanced DAX calculations and optimizing performance of Power BI solutions.
- Proficiency in configuring and managing data refresh schedules and automating data pipelines in Power BI.
- Experience working with Power BI gateways.
- Strong self-QA and development testing ensuring accuracy of displayed visuals, data aggregation, and measure outputs.
- Microsoft Power BI certification(s) preferred.
- Familiarity with AI tools such as ChatGPT, Copilot, and Copilot in Power BI, ability to leverage AI tools to enhance workflows and outputs.
- Familiarity with SQL and ability to query database and explore data table structure for seamless data integration to Power BI.
- Collaborate with delivery teams to manage client workspace deployment and access, and troubleshooting report errors as needed.
Highly organized, self-starting, methodical and with the ability to manage complex projects. Ability to connect overall BI strategy to day-to-day work planning.
BI Developer (SQL Server) in London employer: Korn Ferry
Contact Detail:
Korn Ferry Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Developer (SQL Server) in London
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or at industry events. Let them know you're on the lookout for BI Developer roles, and who knows? They might just have the inside scoop on an opening.
✨Tip Number 2
Show off your skills! Create a portfolio of your best Power BI projects and share it during interviews. This will not only demonstrate your expertise but also give you a chance to discuss your thought process and problem-solving abilities.
✨Tip Number 3
Prepare for those tricky interview questions! Brush up on your DAX calculations and data modelling concepts. Be ready to explain how you've tackled challenges in past projects, especially around data privacy and integration.
✨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 gives you a better chance to stand out from the crowd!
We think you need these skills to ace BI Developer (SQL Server) in London
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Power BI and data visualisation. We want to see how your skills match the job description, so don’t hold back on showcasing your best projects!
Showcase Your Technical Skills: Since this role is all about Power BI, SQL Server, and data modelling, be sure to include specific examples of your work with these technologies. We love seeing DAX calculations and M queries in action, so share those details!
Keep It Clear and Concise: While we appreciate detail, make sure your application is easy to read. Use bullet points for key achievements and keep paragraphs short. We’re looking for clarity, so make it simple for us to see your strengths.
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’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Korn Ferry
✨Know Your Power BI Inside Out
Make sure you’re well-versed in Power BI features, especially those mentioned in the job description. Brush up on your skills with DAX calculations, dataflows, and report design. Being able to discuss specific projects where you've implemented these skills will show your expertise.
✨Showcase Your Data Storytelling Skills
Prepare to discuss how you've transformed complex data into insightful visualisations. Bring examples of dashboards or reports you've created that had a significant impact on decision-making. This will demonstrate your ability to not just analyse data, but to tell a compelling story with it.
✨Understand Data Privacy Regulations
Familiarise yourself with data privacy laws and how they apply to BI solutions. Be ready to discuss how you’ve ensured compliance in past roles, as this is crucial for the position. Showing awareness of these regulations will highlight your professionalism and attention to detail.
✨Prepare Questions for Them
Think of insightful questions to ask about their Power BI architecture and team dynamics. This shows your genuine interest in the role and helps you assess if the company culture aligns with your values. Plus, it gives you a chance to engage in a meaningful conversation during the interview.