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: Be part of a diverse team committed to fairness and inclusivity.
- 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 - 37000 £ 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 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 arrangements, and a range of benefits including gym membership contributions, enhanced family leave, and regular social events. Join us to make a meaningful impact while enjoying a rewarding career in Business Intelligence.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence Developer
✨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 opportunities that aren’t even advertised!
✨Tip Number 2
Prepare for those interviews! Research common questions for Business Intelligence Developers and practice your answers. We want you to showcase your SQL skills and Power BI expertise confidently.
✨Tip Number 3
Show off your projects! If you've built dashboards or worked on data models, bring them up during interviews. We love seeing real examples of your work and how you’ve tackled challenges.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team at CDER Group.
We think you need these skills to ace Business Intelligence Developer
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 the easiest way for us to keep track of your application and ensure it reaches the right people!
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 about past experiences where you’ve had to troubleshoot issues or optimise reports, and be ready to share those stories with specific examples.
✨Understand the Company’s Mission
CDER Group focuses on fair and effective enforcement. Familiarise yourself with their approach and think about how your skills can contribute to their mission. This will help you align your answers with their values during the interview.
✨Practice Communicating Complex Ideas Simply
As a Business Intelligence Developer, you'll need to present findings to both technical and non-technical stakeholders. Practice explaining complex data concepts in simple terms, so you can effectively communicate insights during the interview.
