AMS PSR

On behalf of The Insolvency Service, we are looking for a Data Analyst (Power BI & SQL) (Inside IR35) for a 4 month contract based Remote with occasional travel to main hub locations - Manchester, Birmingham, or London.

The Insolvency Service is partway through a programme of technology transformation, which includes moving away from legacy administrative systems and modernising our reporting and data platforms. As part of this programme, we are in the process of migrating our SAP Business Objects 4.3 content from its legacy environment and redeveloping these reports using Power BI.

Requirement

The Insolvency Service has a requirement for a Data Analyst to replicate a suite of existing reports and dashboards that are currently produced using a data warehouse, SAP Business Objects and related applications. The successful outcome of this work will enable the Insolvency Service to decommission its SAP applications.

As a Data Analyst (Power BI & SQL) your main responsibilities will be to:

• Connect Power BI directly to a range of source SQL databases currently used by SAP Business Objects.
• Build data models to replicate and improve existing report logic used in existing BO/WebLogic reports.
• Where required, confirm specific reporting requirements where there is an opportunity to replicate or replace reporting output with a simpler solution.
• Carry out required data cleaning, transformation and calculation logic using Microsoft Power Query, SQL and Power BI DAX
• Rebuild and improve the existing reporting estate by creating Power BI:
  • Case level operational reports (tabular/detailed outputs used daily by operational teams)
  • Aggregated and management level reports with effective visualisations, filters, slicers, drill through and other interactive capabilities

Essential:

• Advanced hands on experience with Power BI, including data modelling, DAX, visualisation best practices and building reusable semantic models
• Strong working knowledge of SQL, including querying relational databases and understanding data structures
• Ability to interpret and translate existing SAP Business Objects / Weblogic (e.g., queries, joins, calculation contexts) into equivalent Power BI/DAX patterns
• Proven experience working with complex datasets and replicating or modernising existing reporting solutions

Please be aware that this role can only be worked within the UK and not Overseas.

Disability Confident 

As a member of the Disability Confident Scheme, TIS guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply.

Armed Forces / commitment

TIS guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".