At a Glance
- Tasks: Design and develop impactful dashboards using Power BI and SQL to drive data insights.
- Company: Join CDER Group, the UK's largest technical debt collections company with a supportive culture.
- Benefits: Enjoy gym contributions, flexible hours, 25 days holiday, and regular social events.
- Other info: Hybrid working model after probation with excellent career growth opportunities.
- Why this job: Make a real difference in data-driven decision-making while growing your career.
- 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.
BI Developer: Power BI & SQL | Hybrid 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 employee well-being. With a range of benefits including gym membership contributions, flexible working hours, and opportunities for professional growth, our London office fosters a collaborative environment where your contributions directly impact our mission. Join us to be part of a team that not only prioritises your career development but also encourages meaningful engagement with the community through voluntary service opportunities.
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 BI Developer questions. Get comfortable talking about your experience with Power BI and SQL, and be ready to showcase your problem-solving skills with real examples.
✨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 at CDER Group. We’re always looking for talented individuals like you, and applying directly through us can give you a better chance!
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 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 the role and how your background aligns with our mission at CDER Group. Keep it concise but impactful!
Showcase Your Technical Skills:Don’t forget to mention your technical skills prominently. We want to see your proficiency in SQL, PostgreSQL, and Excel, as well as any experience you have with ETL processes and data modelling.
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 CDER Group Ltd
✨Know Your Tools Inside Out
Make sure you’re well-versed in Power BI, SQL, and PostgreSQL. Familiarise yourself with the latest features and best practices for data visualisation and reporting. Being able to discuss specific projects where you've used these tools will show your practical experience.
✨Prepare for Technical Questions
Expect to be asked about your experience with ETL processes and data modelling. Brush up on your SQL skills and be ready to solve problems on the spot. Practising common technical interview questions can help you feel more confident.
✨Showcase Your Analytical Skills
Be prepared to discuss how you've translated complex data into actionable insights in previous roles. Use examples that highlight your analytical thinking and problem-solving abilities, especially in a business context.
✨Engage with Stakeholders
Since this role involves working closely with analysts and stakeholders, think of examples where you’ve effectively communicated technical information to non-technical audiences. Demonstrating your ability to bridge the gap between technical teams and business needs will set you apart.
