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.
- Other info: Work on-site in London three times a week with excellent career advancement opportunities.
- 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 required.
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 England employer: Sterlings
Sterlings is an exceptional employer that fosters a collaborative and innovative work culture, particularly for the Power BI Developer role in the heart of London. With a strong focus on employee growth, we offer opportunities to enhance your skills in cutting-edge technologies like Snowflake and Power BI, while working alongside a diverse international team. Our commitment to meaningful projects and impactful data solutions ensures that you will find your work both rewarding and significant.
StudySmarter Expert Advice🤫
We think this is how you could land Power BI Developer (Snowflake) – Financial Services in England
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the financial services sector. We can’t stress enough how personal connections can lead to job opportunities.
✨Show Off Your Skills
Create a portfolio showcasing your Power BI dashboards and Snowflake projects. This is your chance to shine! We recommend using platforms like GitHub or even your own website to display your work. It’ll give potential employers a taste of what you can do.
✨Ace the Interview
Prepare for those interviews by brushing up on common BI Developer questions and scenarios. Practice explaining your past projects and how you tackled challenges. We suggest doing mock interviews with friends or using online resources to get comfortable.
✨Apply Through Us!
Don’t forget to check out our website for the latest job openings. Applying directly through us not only gives you access to exclusive roles but also helps us match you with positions that fit your skills perfectly. Let’s land that dream job together!
We think you need these skills to ace Power BI Developer (Snowflake) – Financial Services in England
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 bit of personality!
Showcase Your Technical Skills:Since this role is all about data, make sure to emphasise your technical skills in SQL, ADF, and dbt. We’re looking for someone who can hit the ground running, so let us know what you 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 don’t miss out on any important updates from our team!
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 dbt and ADF, so have some examples ready.
✨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 terms like VaR and stress data, and think about how your work can enhance reporting and analysis for risk managers.
✨Prepare for Collaborative Scenarios
This position involves working closely with a large international team. Be prepared to discuss how you’ve collaborated in the past, especially in estimating project scales and managing expectations. Think of examples where you’ve successfully worked with stakeholders to deliver impactful data solutions.
✨Showcase Your Problem-Solving Skills
They’ll want to see how you approach challenges, especially when migrating legacy platforms to modern architectures. Prepare to talk through a specific problem you faced in a previous role and how you tackled it, particularly if it involved reverse engineering or creating robust ELT processes.