Senior Database and Analytics Developer

Civic Recruitment Limited; United Kingdom; On-site; GBP 70,000 - 90,000; Full time

Benefits offered by this job

Bi-Weekly pay

Predominantly remote work

UK-based Candidates Only

Job summary

Zohorecruit seeks a Senior Database & Analytics Developer to join a Local Authority's Software Development Team. The role focuses on Mosaic data extraction, reporting, BI, and analytics development, delivering expert insights to an existing team.

Ideal candidates will design and maintain reporting solutions using Mosaic data, data warehouses, and BI platforms, working predominantly remote with UK-based access constraints required.

Qualifications

• Extensive experience with The Access Group Children's Services Mosaic data models.
• Proven track record in developing data and analytics reporting solutions using Mosaic data.
• Significant experience with Microsoft SQL Server, Oracle, and Microsoft Access.
• Experience with data warehouses, data storage, and BI/reporting frameworks.

Responsibilities

• Serve as the expert on The Access Group Children's Services Mosaic data model and related reporting.
• Create complex reports, dashboards, and analytics solutions using Mosaic data.
• Analyze data requirements from Children's Services and stakeholders.
• Design, develop, maintain, and support reporting and BI solutions.

Skills

Mosaic data model

SQL Server

Oracle

MS Access

Data warehousing

BI reporting

Analytical thinking

Independent work

Education

ICT/ Computing degree

Tools

The Access Group Mosaic

SQL Server

Oracle databases

Job description

Job Information

Interim & Executive Management

Job Description

This is a remote position.

Location: Remote (UK-Based Candidates Only)

Contract: 5-Month Contract

Hours: Full Time

Working Pattern: Predominantly Remote

Summary

We are seeking a seasoned Senior Database & Analytics Developer to join a Local Authority's Software Development Team. This role is ideal for a professional with extensive expertise in The Access Group Children's Services Mosaic data model, focusing on data extraction, reporting, business intelligence, and analytics development. The successful candidate will independently deliver expert technical insights that the current team lacks. Responsibilities include designing, developing, maintaining, and supporting reporting solutions and analytics using Mosaic data, while also contributing to broader database and business intelligence projects. Please note that this position requires candidates to be based in the UK due to system and server access constraints.

Key Responsibilities

Mosaic Data & Reporting

• Serve as the expert on The Access Group Children's Services Mosaic data model.
  
• Create and develop complex reports, dashboards, and analytics solutions using Mosaic data.
  
• Analyze and interpret intricate data requirements from Children's Services and stakeholders.
  
• Develop reporting datasets and business intelligence solutions to aid operational and strategic decisions.
  
• Independently identify, extract, transform, and present data from Mosaic and related systems.
  

Database & Analytics Development

• Design, develop, implement, and maintain corporate database solutions.
  
• Create complex data integrations and automated data flows.
  
• Support business intelligence and performance reporting initiatives.
  
• Design and maintain reporting structures, data warehouses, and analytics environments.
  
• Provide technical expertise in SQL Server, Oracle databases, and other database platforms.
  
• Develop and support reporting and business intelligence solutions.
  
• Ensure access to accurate management information and performance reporting.
  
• Collaborate with stakeholders to understand reporting needs and translate them into technical solutions.
  
• Enhance data quality, accessibility, and reporting efficiency.
  

Technical Support & Improvement

• Troubleshoot issues related to reporting, databases, and analytics.
  
• Offer technical guidance and support to end users and stakeholders.
  
• Produce technical documentation, guidance, and support materials.
  
• Recommend improvements to data storage, reporting processes, and analytics capabilities.
  
• Support corporate data governance and information management activities.
  

Stakeholder Engagement

• Collaborate with service managers, analysts, developers, and operational teams.
  
• Coordinate with third-party suppliers as needed.
  
• Communicate technical concepts clearly to non-technical audiences.
  
• Assist users in understanding reporting outputs and business intelligence tools.
  

Requirements

Requirements:

• Extensive experience with The Access Group Children's Services Mosaic data models.
  
• Proven track record in developing data and analytics reporting solutions using Mosaic data.
  
• Significant experience with:
  • Microsoft SQL Server
    
  • Oracle Databases
    
  • Microsoft Access
    
  • Relational Database Management Systems
    
• Experience in designing and maintaining:
  • Business Intelligence Solutions
    
  • Data Warehouses
    
  • Data Storage Solutions
    
  • Reporting Frameworks
    
• Proficiency in creating complex reports and dashboards.
  
• Strong analytical and problem-solving skills.
  
• Ability to work independently with minimal supervision.
  
• Excellent skills in technical documentation and report writing.
  
• Capability to translate business requirements into technical reporting solutions.
  
• Experience within Local Government Children's Services.
  
• Familiarity with Mosaic reporting frameworks and integrations.
  
• Experience with data warehouse architecture and business intelligence platforms.
  
• Experience mentoring or supporting technical staff.
  

Qualifications

• Degree-level qualification in ICT, Computing, Data Analytics, Information Systems, or equivalent relevant experience.
  
• Relevant database, reporting, or business intelligence qualifications are advantageous.
  

What's on Offer?

• 5-Month Contract
  
• Predominantly Remote Working
  
• UK-Based Candidates Only
  
• Bi-Weekly Pay
  
• Opportunity to specialize in Mosaic reporting and analytics.
  
• High-impact role supporting Children's Services data and performance reporting.
  
• Opportunity to lead complex reporting, data development, and analytics projects.
  

Ideal for candidates with experience as a Senior Database Developer, SQL Developer, BI Developer, Data Warehouse Developer, Reporting Analyst, Business Intelligence Developer, Mosaic Reporting Specialist, Data & Analytics Consultant, or Senior Data Developer with Children's Services Mosaic experience.