Business Intelligence Developer

Service Care Solutions are currently recruiting for an experienced Business Intelligence Developer to work on a full-time, long-term basis for a law enforcement body based in Surrey.

The role is fully-remote, but successful applicants would need to travel to the site in order to collect the necessary equipment on their first day.

Be advised, as this role involves working within law enforcement, successful applicants will need to pass through national security vetting checks.

As such, applicants must have resided in the UK for at least the last 5 years.

The role is paying £700 per day, PAYE (inside IR35).

Job Purpose:

Transforms, tests and documents raw data to create clean reliable data models in relation to Robotic Processes and automation. Key platforms include Blue Prism, MuleSoft (for system integration), Microsoft Fabric as well as automation tools such as Power Automate. Line management responsibility to junior developers

Key Accountabilities:

Using Blue Prism to develop Robotic Processes to automated repetitive, rule-based tasks across the organisation to streamline processes and therefore improve our overall effectiveness and efficiency by releasing capacity whilst improving data quality and insights which can be gained by our data holdings.

To be responsible for the design of processes to prepare, enrich and document data for use by developers and analysts using semantic models, Lakehouse’s and data warehouses to enable provide insight

Be proficient in ingesting or accessing data through various pipelines or dataflows, utilising multiple automation technologies from AI ML/GEN, Power Automate and Power Apps to enable developers and analysts to provide visualisation and insights via Power Bi and other tools to stakeholder and business teams to drive data driven informed operational decision making

Be accountable for transforming and testing data with dataflows, procedures, and notebooks to enable developers to design and build user facing visualisations combining multiple data sets to provide organisational insight to previously hidden or hard to reach data assets.

Be responsible for the design and implementation of the storage and querying of data in Lakehouses and data warehouses. Expose and join data for the wider organisation to access with reusable semantic models that become the single version of the truth. This will include data sources in both Surrey and Sussex when appropriate.

Communicate effectively with technical and non-technical stakeholders to clearly understand business requirements and risks/benefits associated with the insight which can be gained. This will be across both Surrey and Sussex as well as regional and national forces where appropriate.

Carefully testing and accuracy checking data lists and aggregations – create UAT parameters and checklists to inform and enable business sign off.

Collaborating with other team members to design and document solutions and to develop strong governance and control processes, this will include working across Surrey and Sussex corporate services and others.

Be responsible for ensuring the business benefits which were agreed are met through working with business assurance colleagues.

Analyse and document available data flows ensuring corporate standards are met and recorded in a consistent manner to ensure the reusability of flows and maximising the insights which can be gained from our data to enable stakeholders to be data informed in their operational decision making.

Be responsible for collaborating with colleagues across the force and Sussex when appropriate in identifying, designing solutions that meet the established business needs to ensure we maximise the effectiveness, efficiencies and insights which can been gained from the wide range of data which is held both locally and corporately.

Represent the department at stakeholder engagement events and meeting, and being a key decision maker in taking concepts forward into design and development phases.

Experience:

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

If this looks like something you could be interested in, please apply now.

Or call (phone number removed) if you have any questions or concerns