Salary: £8,400 - 10,200 per year Requirements: Demonstrate work experience in the creation and managing analytical assets such as semantic models, warehouses, and Lakehouse Strong data modelling background with experience working with multiple data sources in cloud and fabric and deployment pipelines Industry experience in delivering Power BI/Microsoft Analytics solutions, with a good grounding in all associated areas including Governance Prepare and enrich data for analysis, securing and maintaining analytics assets and manage semantic models with associated documentation Experience in building dashboards, reports, and cubes using SQL, MDX, DAX, Power BI, or other visualisation tools Experience in developing Robotic Process Automations using Blue Prism Experience of establishing and maintaining collaborative relationships with stakeholders, developers, analysts, and data scientists internally and externally Must have resided in the UK for at least the last 5 years and pass national security vetting checks Responsibilities: Transform, test, and document raw data to create clean reliable data models related to Robotic Processes and automation Develop Robotic Processes using Blue Prism to automate repetitive, rule-based tasks across the organization Design processes to prepare, enrich, and document data for use by developers and analysts using semantic models, Lakehouses, and data warehouses Ingest or access data through various pipelines or dataflows using multiple automation technologies to enable visualization and insights Transform and test data with dataflows, procedures, and notebooks to create user-facing visualisations combining multiple data sets Design and implement the storage and querying of data in Lakehouses and data warehouses Communicate effectively with technical and non-technical stakeholders to understand business requirements and associated risks/benefits Test and accuracy check data lists and aggregations, creating UAT parameters and checklists Collaborate with team members to design and document solutions, ensuring strong governance and control processes Ensure agreed business benefits are met by working with business assurance colleagues Analyse and document available data flows ensuring corporate standards are met Collaborate with colleagues in identifying and designing solutions that meet established business needs Represent the department at stakeholder engagement events and meetings, making key decisions for design and development phases Technologies: Business Intelligence Cloud DAX Fabric Power BI SQL Security AI MuleSoft More: We are Service Care Solutions, currently looking for an experienced Business Intelligence Developer to join our team. This is a full-time, remote role for a law enforcement body based in Surrey, with a requirement to collect necessary equipment on your first day. The position offers a competitive pay rate of £700 per day, PAYE (inside IR35). Candidates will need to successfully pass national security vetting checks and have resided in the UK for the last 5 years. Join us to help transform and enhance data processes within law enforcement, making a real impact in our communities. last updated 12 week of 2026