At a Glance
- Tasks: Design and develop impactful dashboards and reports using Power BI and SQL.
- Company: Join CDER Group, the UK's largest technical debt collections company.
- Benefits: Enjoy gym contributions, flexible hours, 25+ days holiday, and regular social events.
- Other info: Hybrid working model after probation; inclusive culture celebrating diversity.
- 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.
Location: London
Salary: From £37,000 pa to 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.
Business Intelligence Developer in London employer: CDER Group Ltd
At CDER Group, we pride ourselves on being an exceptional employer, offering a supportive and inclusive work culture that values fairness and compassion. Our London office provides a vibrant environment with opportunities for professional growth, flexible working hours, and a comprehensive benefits package including gym contributions, enhanced family leave, and regular social events. Join us to make a meaningful impact while enjoying a rewarding career in Business Intelligence development.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer in London
✨Tip Number 1
Network like a pro! Reach out to people in the industry, attend meetups, and connect with current employees at CDER Group. A friendly chat can sometimes lead to job opportunities that aren't even advertised!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best dashboards and reports. When you apply through our website, include links to your work so we can see your talent in action.
✨Tip Number 3
Prepare for the interview by brushing up on your SQL and Power BI skills. We love candidates who can demonstrate their technical prowess, so be ready to tackle some practical questions or challenges.
✨Tip Number 4
Follow up after your interview! A quick thank-you email can leave a lasting impression. It shows you're genuinely interested in the role and helps keep you on our radar as we make decisions.
We think you need these skills to ace Business Intelligence Developer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Business Intelligence Developer role. Highlight your experience with SQL, Power BI, and any relevant projects that showcase your skills in data analysis and reporting.
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 concise but impactful!
Showcase Your Problem-Solving Skills:In your application, don’t forget to mention specific examples where you've tackled complex data challenges. We love seeing how you approach problem-solving, especially in a BI context!
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s super easy, and we can’t wait to see your application come through!
How to prepare for a job interview at CDER Group Ltd
✨Know Your Tools Inside Out
Make sure you’re well-versed in PostgreSQL, Power BI, and Excel. Brush up on your SQL skills and be ready to discuss how you've used these tools in past projects. Being able to demonstrate your technical expertise will show that you're the right fit for the role.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems or scenarios related to data analysis and reporting. Think of examples from your previous experience where you successfully tackled challenges, optimised processes, or improved reporting capabilities. This will highlight your problem-solving skills.
✨Understand the Company’s Mission
Familiarise yourself with CDER Group's mission of fair and effective enforcement. Be prepared to discuss how your role as a Business Intelligence Developer can contribute to this mission. Showing that you align with their values will make a strong impression.
✨Ask Insightful Questions
Prepare thoughtful questions to ask at the end of your interview. Inquire about the team dynamics, ongoing projects, or how success is measured in the role. This not only shows your interest but also helps you gauge if the company is the right fit for you.
