At a Glance
- Tasks: Enhance data platforms using Snowflake and Power BI for impactful reporting and analysis.
- Company: Join a leading financial services firm with a focus on innovation.
- Benefits: Competitive salary, health benefits, and opportunities for professional growth.
- Why this job: Make a real impact by transforming data solutions in a collaborative international team.
- Qualifications: Experience in BI development, Snowflake, Power BI, and strong SQL skills.
- Other info: Work on-site in London three times a week with excellent career advancement potential.
The predicted salary is between 36000 - 60000 £ per year.
The Power BI Developer will play a pivotal role in enhancing the platform, which utilizes Snowflake for data storage (including VaR, sensitivities, and stress data) and Power BI for reporting and analysis via both the Power BI Service and Excel.
This person will also be instrumental in migrating legacy platforms (SQL Server, SSIS, SSAS, SSRS) to modern Snowflake/Power BI architecture. The role requires working directly with risk managers to capture requirements, manage expectations, and deliver impactful data solutions. This includes contributing to the expansion of our platform to support additional bank entities and potentially reverse engineering Excel EUCs into robust ELT processes.
The ideal candidate will be adept at estimating projects of varying scales and thrive in a collaborative environment with a large international team.
Experience Required:- Experience as a BI Developer or Data Engineer with a focus on Snowflake and Power BI.
- Skills in Snowflake, including data modelling (star/snowflake schemas), query optimization, and Snowflake-specific features (e.g., virtual warehouses, time travel).
- Experience designing and developing data pipelines using ADF (Azure Data Factory).
- Practical experience with dbt (data build tool) for data transformation and modelling in Snowflake.
- Proficiency in Power BI, including dashboard and report creation, data visualization best practices, and DAX (Data Analysis Expressions).
- Strong SQL skills for data extraction, manipulation, and optimization.
This position will be on-site at their London office 3 times a week.
Seniority level: Mid-Senior level
Employment type: Full-time
Job function: Information Technology
Financial Services, Banking, and Investment Banking
Power BI Developer (Snowflake) – Financial Services in London employer: Sterlings
Contact Detail:
Sterlings Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Power BI Developer (Snowflake) – Financial Services in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the financial services sector and let them know you're on the hunt for a Power BI Developer role. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI dashboards and Snowflake projects. This will give potential employers a taste of what you can do and set you apart from the competition.
✨Tip Number 3
Prepare for interviews by brushing up on common BI Developer questions, especially around Snowflake and Power BI. Practice explaining your past projects and how you've tackled challenges in data migration and reporting.
✨Tip Number 4
Don't forget to apply through our website! We’ve got loads of opportunities waiting for talented individuals like you. Plus, it’s a great way to ensure your application gets seen by the right people.
We think you need these skills to ace Power BI Developer (Snowflake) – Financial Services in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Snowflake and Power BI. We want to see how your skills align with the role, so don’t be shy about showcasing relevant projects or achievements!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about this role and how your background makes you the perfect fit. We love seeing enthusiasm and a personal touch.
Showcase Your Technical Skills: Since this role is all about data, make sure to include specific examples of your work with data pipelines, SQL, and any relevant tools like ADF or dbt. We want to know what you can bring to the table!
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!
How to prepare for a job interview at Sterlings
✨Know Your Tech Inside Out
Make sure you brush up on your Snowflake and Power BI skills. Be ready to discuss your experience with data modelling, query optimisation, and any specific features of Snowflake that you've used. They’ll likely want to hear about your practical experience with ADF and dbt too!
✨Understand the Business Context
Since this role is in financial services, it’s crucial to understand how data impacts risk management and decision-making. Familiarise yourself with concepts like VaR and stress testing, so you can speak knowledgeably about how your work will contribute to the business.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems or describe past experiences. Think of examples where you’ve successfully migrated legacy systems or improved data processes. Use the STAR method (Situation, Task, Action, Result) to structure your answers.
✨Show Your Collaborative Spirit
This role involves working with a large international team, so be prepared to discuss how you’ve collaborated in the past. Highlight your communication skills and any experience you have managing expectations with stakeholders, especially risk managers.