Business Intelligence Developer

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.

Key Duties and 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.

Do you have experience in SQL?, * 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

Pulled from the full job description

• Referral programme
• Free or subsidised travel
• Employee discount
• Sick pay
• Gym membership
• Employee assistance programme
• Free parking, * No. 1 in Road User Charging: Highways England, Transport for London
• Large central government contracts: HMCTS, HMRC, DVLA
• 5 centres of excellence: London, Stoke, Bolton, Darlington, Market Harborough
• 150+ Local Authority clients
• People and technology centric business
• Advanced unique business operating software platform, * 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 program
• Discounts and savings available on our bespoke staff rewards platform
• Casual dress
• Free onsite parking (excluding City of London)
• Loans for travel
• 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
• Hybrid working
• Extra holiday days available to buy, up to five days per year
• As if that wasn’t enough, we even provide you with unlimited refreshments, regular mouth-watering treats and healthy snacks each week

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.

Job Types: Permanent, Full-time

Pay: From £37,000.00 per year

Benefits:

• Additional leave
• Casual dress
• Company events
• Company pension
• Cycle to work scheme
• Discounted or free food
• Employee discount
• Free or subsidised travel
• Gym membership
• Referral programme
• Sick pay
• Store discounts
• Wellness programmes