At a Glance
- Tasks: Design and develop impactful dashboards using Power BI and SQL to drive data insights.
- Company: Join CDER Group, a leading tech-driven debt collections company in the UK.
- Benefits: Enjoy gym contributions, flexible hours, 25+ days holiday, and regular social events.
- Other info: Hybrid work model after probation with excellent career growth opportunities.
- Why this job: Make a real difference with data while growing your career in a supportive environment.
- Qualifications: Degree in Data Analytics or related field; strong SQL and Power BI skills required.
The predicted salary is between 37000 - 40000 £ per year.
Position: Business Intelligence Developer
Location: London
Salary: From £37,000 pa dependent on experience
Reporting to: Business Intelligence Manager
Hours: 35 hours, Monday to Friday
About CDER Group
Here at CDER Group we support and help clients recover money that is owed to them compassionately and compliantly. We understand that everyone is different and with our unique approach to fairness we ensure that clients, customers, and employees are treated fairly, supporting our customers to repay any outstanding money owed. As the largest technical debt collections and enforcement company in the UK, we are proud to work on behalf of clients such as Highways England, Transport for London, HMCTS, HMRC and DVLA.
Introduction
As a Business Intelligence Developer, you will design, develop, and maintain the organisation’s reporting infrastructure to ensure data accuracy, accessibility, and usability. Your responsibilities will include creating and optimising dashboards, building robust ETL pipelines, and maintaining scalable data models that support advanced reporting. Leveraging tools such as PostgreSQL, Power BI, and Excel, you will deliver reliable, scalable reporting solutions that improve operational efficiency and inform strategic decision-making. Working closely with analysts and stakeholders, you will ensure the organisation’s data is transformed into meaningful insights that support CDER Group’s mission of fair and effective enforcement. You will report directly to our Business Intelligence Manager within a flat-structured organisation. This role is based in our London (City) office; following the successful completion of your probation period, it will transition to a hybrid model requiring three days in the office per week.
What’s in it for you?
- Gym membership contribution: we will give you up to £20 per month towards your gym membership
- Company pension
- 24/7 employee assistance programme
- Company sick pay
- Referral programme
- Discounts and savings available on our bespoke staff rewards platform
- Free onsite parking (excluding City of London)
- Cycle to work scheme
- 25 days holiday, rising to 28
- Regular subsidised social events
- Voluntary service opportunities to a charity of your choice – up to two days per year
- Long service awards
- Enhanced family leave
- Working hours that are flexible
- Extra holiday days available to buy, up to five days per year
- Unlimited refreshments, regular mouth-watering treats and healthy snacks each week
Responsibilities
- Design, develop, and maintain advanced dashboards and reports using Power BI or similar tools.
- Implement best practices for data visualisation, ensuring reports are user-friendly and impactful.
- Continuously improve reporting capabilities based on stakeholder feedback and business needs.
- Translate complex data into intuitive reports that cater to both technical and non-technical audiences.
- Build, maintain, and optimise SQL scripts and ETL processes to extract, transform, and load data from diverse sources.
- Ensure built reports are efficient, reliable, and scalable to meet evolving business requirements.
- Automate and streamline recurring reports to improve efficiency and reduce manual effort.
- Write and optimise advanced SQL queries to extract, transform, and analyse data.
- Design, integrate and implement data and data models to support reporting and analysis needs.
- Develop and manage robust data models to enable effective analysis and reporting.
- Optimise data structures to improve query performance and report delivery times.
- Troubleshoot technical issues in data pipelines, dashboards, and BI tools.
- Perform regular testing and validation to ensure data accuracy and system reliability.
- Manage and prioritise tickets in Jira to ensure timely delivery of solutions.
- Analyse customer requirements detailed in Jira tickets and translate them into technical deliverables.
- Communicate effectively with stakeholders to clarify requirements and provide status updates on ticket progress.
- Work closely with cross-functional teams across divisions to understand their data needs.
- Act as a bridge between technical teams and business stakeholders, ensuring alignment in reporting goals.
- Present findings and insights to technical and non-technical key stakeholders, providing clarity and actionable recommendations.
- Offer guidance to other departments in interpreting and leveraging BI outputs effectively.
- Monitor the performance of reporting systems, addressing any issues proactively.
- Highlight data inconsistencies to seniors and managers, while also analysing and resolving them, where possible and applicable, to ensure a clear understanding of root causes and implementing necessary solutions.
- Support continuous improvement initiatives in data processes.
- Ensure compliance with data governance and security protocols in all BI solutions.
- Experiment with and implement enhancements to existing reporting tools to improve functionality and user experience.
- Contribute ideas to enhance data collection, analysis, and reporting practices.
- Stay updated on industry trends, tools, and best practices in Business Intelligence.
Personal qualities, experience and skills
- A degree in Data Analytics, Computer Science, Mathematics, or a related field
- Strong analytical and problem-solving abilities.
- Advanced in SQL/PostgreSQL, data modelling, and database management.
- Proficiency in Microsoft Excel (e.g., PivotTables, VLOOKUP, data cleaning).
- Advanced skills in Power BI, including building dashboards, reports, and DAX.
- A minimum of 2 years of experience in Data Analysis, Data Engineering or Business Intelligence.
- A proactive and curious mindset with a passion for data-driven decision-making.
- Strong troubleshooting skills to resolve technical issues promptly.
- Analytical
- Accurate
- Detail-oriented
Ready to Join Us? Apply now and start your journey with CDER Group, where you can make a real difference while growing your career.
CDER Group are proud to be an Equal Opportunities Employer. We celebrate diversity and equal opportunities and are committed to creating an inclusive environment for all employees that represents a variety of backgrounds, perspectives and skills.
If you require any assistance or accommodation due to a disability, please contact the HR department.
Please contact us if you need help or more information.
Be Scam Aware! Here’s how to protect yourself:
BI Developer: Power BI & SQL | Hybrid London employer: CDER Group Ltd
At CDER Group, we pride ourselves on being an exceptional employer that values fairness and inclusivity, making it a great place for a Business Intelligence Developer to thrive. Our London office offers a vibrant work culture with flexible hybrid working arrangements, generous benefits including gym membership contributions, enhanced family leave, and opportunities for professional growth through continuous learning and collaboration with cross-functional teams. Join us to make a meaningful impact while enjoying a supportive environment that celebrates diversity and encourages personal development.
StudySmarter Expert Advice🤫
We think this is how you could land BI Developer: Power BI & SQL | Hybrid London
✨Tip Number 1
Network like a pro! Reach out to your connections on LinkedIn or attend industry meetups. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions and showcasing your skills with real examples. We recommend using the STAR method (Situation, Task, Action, Result) to structure your answers.
✨Tip Number 3
Don’t just apply and wait! Follow up on your applications after a week or so. A quick email can show your enthusiasm and keep you on their radar.
✨Tip Number 4
Check out our website for the latest job openings. Applying directly through us not only gives you a better chance but also keeps you updated on any new roles that fit your skills!
We think you need these skills to ace BI Developer: Power BI & SQL | Hybrid London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the BI Developer role. Highlight your experience with Power BI, SQL, and any relevant projects that showcase your skills. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data and how your background aligns with our mission at CDER Group. Keep it engaging and personal – we love to see your personality!
Showcase Your Technical Skills:Don’t forget to mention your technical skills in your application. Be specific about your experience with data modelling, ETL processes, and any tools you've used. We’re looking for someone who can hit the ground running!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you don’t miss out on any important updates. Plus, it’s super easy!
How to prepare for a job interview at CDER Group Ltd
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, SQL, and Excel. Brush up on your skills by creating sample dashboards or reports that showcase your ability to transform data into meaningful insights. This will not only help you answer technical questions but also demonstrate your hands-on experience.
✨Understand the Company’s Mission
CDER Group focuses on fair and effective enforcement. Familiarise yourself with their approach and think about how your role as a BI Developer can contribute to this mission. Be ready to discuss how your work can support their goals and improve operational efficiency.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems using your BI skills. Practice explaining your thought process when building ETL pipelines or optimising dashboards. Use examples from your past experiences to illustrate how you’ve tackled similar challenges.
✨Showcase Your Communication Skills
As a BI Developer, you’ll need to bridge the gap between technical teams and business stakeholders. Prepare to discuss how you’ve effectively communicated complex data insights to non-technical audiences. Highlight any experiences where you’ve collaborated with cross-functional teams to meet their data needs.
