Senior Database and Analytics Developer

Role overview

Workplace and working pattern

• The position is remote and described as predominantly remote.
• Candidates must be based in the UK.

Contract and compensation

• Five-month contract; full-time hours.
• Rate is £36.00 per hour (Umbrella); pay is stated as bi-weekly.

Mosaic data and reporting

• Serve as the expert on the Mosaic data model and create complex Mosaic reports, dashboards, and analytics.
• Interpret Children's Services and stakeholder data requirements; develop reporting datasets and BI solutions.
• Extract, transform, and present data from Mosaic and related systems.

Database development and business intelligence

• Design, develop, implement, and maintain corporate databases, complex integrations, and automated data flows.
• Maintain reporting structures, data warehouses, and analytics environments; provide database expertise across SQL Server, Oracle, and other platforms.
• Support BI and performance reporting, accurate management information, and improved data quality and accessibility.

Technical support and collaboration

• Troubleshoot reporting, database, and analytics issues; guide end users and stakeholders.
• Produce technical documentation and recommend improvements to storage, reporting, and analytics.
• Support data governance and information management; collaborate with service managers, analysts, developers, operational teams, and suppliers.

Essential requirements

• Extensive Mosaic data-model experience and a proven record developing Mosaic data and analytics reporting solutions.
• Strong SQL skills and significant experience with SQL Server, Oracle, Microsoft Access, and relational database systems.
• Experience designing and maintaining BI solutions, data warehouses, data storage solutions, and reporting frameworks.
• Proficiency in complex reports and dashboards; analytical and problem-solving skills; ability to work independently.
• Strong documentation and report writing; ability to translate business requirements into technical reporting solutions.
• Degree-level ICT, Computing, Data Analytics, or Information Systems qualification, or equivalent relevant experience.

Desirable experience and qualifications

• Local Government Children's Services, Mosaic reporting frameworks and integrations, data warehouse architecture, and BI platforms are desirable.
• PRINCE2 Foundation, ITIL Foundation, Agile development experience, and mentoring or supporting technical staff are desirable.
• Relevant database, reporting, or BI qualifications are advantageous.