At a Glance
- Tasks: Design and develop scalable data solutions for enterprise reporting and business intelligence.
- Company: Leading global financial services firm with a high-performing Risk Reporting team.
- Benefits: Competitive day rate, hybrid working, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and technical excellence.
- Why this job: Join a dynamic team and work on exciting BI transformation projects.
- Qualifications: Strong SQL skills, experience with data warehouses, and familiarity with Power BI.
We are seeking an experienced BI Developer to join a high-performing Risk Reporting team within a leading global financial services environment. This role will focus on developing scalable data solutions, supporting enterprise reporting capabilities, and enhancing business intelligence platforms. This is an exciting opportunity to work on large-scale data warehousing and reporting initiatives within a complex, enterprise-grade environment.
Key Responsibilities
- Design and develop scalable data models, schemas, and pipelines
- Develop data ingestion and transformation solutions using existing frameworks
- Write and optimise complex SQL queries, stored procedures, and functions
- Ensure data integrity, consistency, and performance optimisation
- Collaborate with stakeholders to translate business requirements into technical solutions
- Implement data governance, security, and access controls
- Monitor and troubleshoot data pipelines and performance bottlenecks
- Participate in code reviews and maintain technical documentation
- Support CI/CD implementation for automated deployment and testing
Required Skills & Experience
- Strong expertise in SQL and advanced SQL concepts
- Experience working with large-scale enterprise data warehouses
- Strong understanding of dimensional modelling and star schema design
- Hands-on experience with Snowflake
- Expertise in Power BI development
- Experience with ETL/ELT processes and data integration techniques
- Familiarity with Python and/or PowerShell scripting
- Experience using dbt for data transformation and modelling
- Financial services or risk reporting experience
- Experience with orchestration tools such as Control-M
- Exposure to Agile and DevOps methodologies
What’s on Offer
- Opportunity to work on enterprise-scale BI transformation projects
- Collaborative and technically strong environment
Business Intelligence Developer employer: Queen Square Recruitment
Join a leading global financial services firm that prioritises innovation and collaboration, offering BI Developers the chance to work on enterprise-scale transformation projects in a dynamic hybrid environment. With a strong focus on employee growth, you will benefit from a culture that encourages continuous learning and development, while also enjoying competitive compensation and the opportunity to make a significant impact within the Risk Reporting team in London.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer
✨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 lookout for BI Developer roles. You never know who might have the inside scoop on an opportunity that’s not even advertised yet!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best work with SQL, Power BI, and any data models you've developed. This will give potential employers a taste of what you can bring to their Risk Reporting team.
✨Tip Number 3
Prepare for those interviews! Brush up on your knowledge of data governance and performance optimisation. Be ready to discuss how you've tackled challenges in past projects, especially in large-scale data environments.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got some fantastic opportunities waiting for you, and applying directly can sometimes give you a leg up in the process. Let’s get you into that BI Developer role!
We think you need these skills to ace Business Intelligence Developer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with SQL, data warehousing, and BI tools like Power BI. We want to see how your skills match the role, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re excited about the BI Developer role and how your background in financial services aligns with our needs. Keep it concise but impactful!
Showcase Your Technical Skills:When filling out your application, be sure to mention your hands-on experience with Snowflake, ETL processes, and any orchestration tools you've used. We love seeing specific examples of your work!
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 this exciting opportunity in our Risk Reporting team!
How to prepare for a job interview at Queen Square Recruitment
✨Know Your SQL Inside Out
As a BI Developer, your SQL skills are crucial. Brush up on complex queries, stored procedures, and functions. Be ready to discuss your past experiences with SQL and how you've optimised performance in previous roles.
✨Showcase Your Data Modelling Skills
Familiarise yourself with dimensional modelling and star schema design. Prepare examples of how you've designed scalable data models in the past, and be ready to explain your thought process during the interview.
✨Demonstrate Your BI Tool Expertise
Since Power BI is a key part of the role, make sure you can talk about your experience with it. Bring along examples of dashboards or reports you've created, and be prepared to discuss how they added value to your previous projects.
✨Understand the Financial Services Landscape
Having experience in financial services or risk reporting will set you apart. Brush up on industry trends and challenges, and think about how your skills can help address them. This will show your potential employer that you're not just technically skilled, but also understand the business context.
