At a Glance
- Tasks: Develop and implement analytics solutions using Children's Services Mosaic data models.
- Company: Join a supportive local authority team focused on impactful project delivery.
- Benefits: Competitive daily rate, remote work, and provided equipment.
- Other info: Flexible remote role with opportunities for mentoring and professional growth.
- Why this job: Make a difference in local services while working with advanced data technologies.
- Qualifications: Expertise in Mosaic data models and strong SQL Server/Oracle skills required.
The predicted salary is between 266 - 266 £ per hour.
Senior Database and Analytics Developer (Access Mosaic)
Rate: £266 per day Contract duration: 22 weeks Start date: 26 October 2026 End date: 28 March 2027 Hours: 37 per week IR35 status: Inside IR35
About the role
We are recruiting a Senior Database and Analytics Developer to support a local authority with project delivery during a peak in workload.
We are specifically looking for someone with specialist knowledge of The Access Group's Children's Services Mosaic data models and experience using them for data and analytics development for reporting purposes.
This expertise is not currently available within the team, so you will need sufficient experience to work confidently and independently.
You will lead the analysis, specification, development, testing, implementation and support of corporate data storage solutions and internal database developments.
You will also implement, maintain and support business analytics and intelligence systems that help deliver effective council services.
Working arrangements
The role is predominantly remote, with little to no requirement for onsite attendance.
Equipment will be provided for the duration of the contract.
Due to server access requirements, the duties cannot be performed from outside the UK.
Key responsibilities
- Develop reporting and analytics solutions using Children's Services Mosaic data models.
- Define and maintain data architecture, including metadata, integration, business intelligence and data warehouse architecture.
- Design and implement complex data flows connecting operational systems with analytics and BI systems.
- Analyse service requirements and develop data storage solutions and integrations using internal and third party data sources.
- Support BI development using sources including Microsoft SQL Server, Oracle Database and Microsoft Access.
- Manage, maintain and monitor SQL Server and Oracle databases and support corporate BI systems.
- Work with stakeholders to clarify requirements, recommend improvements and support their delivery.
- Investigate database, reporting and BI issues, assessing their operational impact and implementing solutions within agreed service levels.
- Provide technical documentation, training and support to users, helping improve data literacy and reduce data risks.
- Support project planning by estimating timescales for BI development activities.
- Mentor and coach Database and Analytics Development Officers, liaising with training providers to support their development.
- Contribute to policies, processes and standards for data storage and business intelligence.
Essential skills and experience
- Specialist experience with The Access Group's Children's Services Mosaic data models, specifically for reporting and analytics development.
- Ability to work independently, applying specialist knowledge with confidence.
- Substantial experience designing, developing and maintaining reports, including complex reports using BI tools.
- Substantial experience managing relational database systems, with strong knowledge of SQL Server and Oracle administration, maintenance and monitoring.
- Experience administering corporate BI systems and associated data storage solutions.
- Knowledge of data storage design, including data warehouses and data lakes.
- Strong understanding of relational theory and the manipulation and security of non relational data sources.
- Experience troubleshooting BI and reporting errors.
- Ability to translate business requirements into practical technical solutions and explain specialist information to colleagues with varying levels of technical knowledge.
- Experience producing clear technical documentation and providing training and support to users.
- Understanding of incident recording, service requests and problem escalation, with experience delivering solutions within service level agreements.
- Project management experience, knowledge of a recognised project management methodology and experience working within the software development lifecycle.
- Strong organisational skills and experience managing multiple projects or activities.
Desirable skills and qualifications
- PRINCE2 Foundation.
- Knowledge of Agile development methodologies.
- ITIL Foundation.
- Knowledge of the OSI seven layer model.
- Experience of staff management.
- Additional requirements
You will be self motivated, communicate well and be willing to constructively challenge existing practices.
Occasional evening or weekend work may be required to facilitate upgrades, updates and testing.
Applicants must be resident in the UK and already have the right to work in the UK.
Visa sponsorship is not available for this role. *Rates depend on experience and client requirements
Senior Database and Analytics Developer (Access Mosaic) employer: Salt
As a UX Designer at our global investment management firm in London, you'll be part of a dynamic and innovative team that values creativity and collaboration. We offer a hybrid work environment, competitive salary, and comprehensive benefits, alongside ample opportunities for professional growth in the rapidly evolving field of digital marketing and AI. Join us to shape engaging user experiences while working on cutting-edge projects that blend classic UX design with emerging technologies.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Database and Analytics Developer (Access Mosaic)
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Salt before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Salt.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Salt.
We think you need these skills to ace Senior Database and Analytics Developer (Access Mosaic)
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Salt, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Salt, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Salt’s attention and show the tangible impact of your work.
How to prepare for a job interview at Salt
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Salt.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Salt.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Salt.