Location
About the job
Job summary
Job description
We encourage applications from people from all backgrounds and aim to have a workforce that represents the wider society that we serve. We pride ourselves on being an employer of choice. We champion diversity, inclusion and wellbeing and aim to create a workplace where everyone feels valued and a sense of belonging. To find out more about how we do this visit: https://www.gov.uk/government/organisations/ministry-of-justice/about/equality-and-diversity.
https://justicejobs.tal.net/vx/lang-en-GB/brand-2/user-24779/xf-a12525759150/wid-1/ats/recruiter/opportunities/vacancy/75329Job Title: Lead Data and BI Developer
Job Grade: Grade 7
Reporting to: Head of Commercial Systems, Planning & MI
Job Location: National (click HERE to find your nearest location)
Contract Type: Permanent
Business Area: MOJ – Commercial & Contract Management Department
Type of role: Senior Leadership
Working pattern: Flexible working, Full-time
Number of Posts: 1
About the Department
The Ministry of Justice (MoJ) is a major government department, at the heart of the justice system. Responsible for courts, prisons and probation services, we work to ensure sentences are served and offenders are given rehabilitation opportunities to become law-abiding citizens.
The Ministry of Justice (MoJ) has one of the largest and most complex spend profiles in central government. The Commercial and Contract Management Directorate (CCMD) is responsible for coordinating procurement and contract management across the MoJ, its agencies and non-departmental public bodies.
The MoJ spends £3.5bn a year and manages over 1000 active contracts, all of which are sourced and managed by CCMD. We are running some of the most groundbreaking programmes such as Prison Reform and Her Majesty’s Courts and Tribunal Service Reform. The scope of our contracts ranges from building, maintenance and the operation of Prisons, Courts and Young Offender establishments through to food for prison dogs. The directorate also buys and manages contracts for feeding up to 80,000 prisoners, the secure escorting of prisoners from numerous establishments based around the country and translation services.
CCMD is organised into category teams, each with an interesting portfolio of contracts and diverse customers and suppliers to manage. We also have systems, programme management office, supplier relationship and risk management teams who work across all areas.
Scope
Portfolio – Commercial Operating Centre
The post holder will assist the Head of Commercial Systems, Planning & MI alongside the Senior MI & Planning Manager and Senior Systems Manager driving forward the development of a new data platform within the Commercial and Contract Management Directorate (CCMD). The role will focus on designing and building a data quality engine, ETL procedures, orchestration, integration and data warehousing. The post holder will also develop and maintain the commercial data model and provide advice, guidance, and training on Power BI and the broader Power Platform to the MI team as well as themselves undertaking complex Power BI deliveries. Reporting to the Head of Commercial Systems, Planning and MI, this is a national post with occasional travel.
Key Responsibilities
- Designing and building the Commercial Data Quality Engine, Data Warehouse, Intelligence Portal, and ETL
- Managing the Integration Layers/APIs for various commercial systems.
- Working with the Business Analyst to produce per process Data Models
- Maintaining the overall Commercial Data Model
- Designing and building an Orchestration Layer and Enterprise Service Bus to coordinate the ETL from various Data Silo’s into the Data Quality Engine and Data Warehouse
- Development of complex Power BI reports and training advanced Power BI reporting
- Develop calculated measures in the Data Warehouse, integrated into Power BI for the MI Team
- Work closely with the Senior Systems Manager and the Senior Planning & MI Manager to coordinate the activity of the Business Analyst and Data Analysts to support the overall technical delivery
- Developing and maintaining the overall technical delivery plan
- Work closely with the Information Governance Manager to ensure that data is managed and retained according to the information and data governance policies
- Provide high quality technical advice in a busy and challenging environment, working in close partnership with staff at all levels of CCMD.
- Establish and maintain relationships with internal and external stakeholders and teams.
- Become familiar with internal and external resources relating to relevant technical concepts
- Working closely with Data Stewards and Business Analysts to ensure there is a common understanding of data definitions and quality requirements
The duties/responsibilities listed above describe the post as it is at present and is not intended to be exhaustive. The job holder is expected to accept reasonable alterations and additional tasks of a similar level that may be necessary.
Person Specification
Essential Criteria:
We are looking for an individual who understands data engineering, data architecture, business intelligence and data management, is a self-starter, operates efficiently at pace and thrives in a challenging environment.
Knowledge, skills and abilities we are looking for:
- A deep understanding of data architecture, data integration, data engineering and business intelligence
- Advanced Power BI skillset which includes DAX, data modelling, data visualisation, and direct query
- A deep understanding of Microsoft Azure, Power Platform, SQL and a broad data engineering skillset
- The ability to design and build orchestration, integration, warehousing, data quality tests, calculated measures and ETL procedures
- Experience rapidly prototyping the full data stack at a ‘per business process’ level
- Ability to think creatively, network and develop strong working relationships.
- Excellent written and verbal communication skills to suit a range of audiences including senior managers, and ability to address matters sensitively.
- Ability to manage own workload, working accurately and efficiently to fixed deadlines with minimal supervision, and to prioritise a range of competing demands while maintaining attention to detail.
- A willingness to acquire and maintain up-to-date knowledge of product set and policies in relation to data governance
- The ability to self-start and to identify the optimal pathway to deliver change, in an otherwise busy environment with competing priorities
Most importantly we are looking for someone with the right personal qualities – enthusiasm, energy, proactivity, prepared to work under their own initiative and to be flexible and adaptable in a fast-paced environment.
Assessment
We will assess your suitability for this role against the Government’s published Success Profiles. For this role these are:
Application form stage assessments:
An initial sift will be performed against the following elements:
Experience
- CV
- Statement of Suitability (1000 words)
Behaviours
- Developing Self and Others
Interview assessment:
There is one interview stage for this vacancy and as part of the interview process you will be required to provide evidence of the following:
Behaviours
- Communicating and Influencing
- Working together
- Changing and Improving
Technical
- Data Architecture
- Features of Power BI
- Use of Power BI
An initial sift will be performed on your Statement of Suitability and CV against the essential criteria listed above.
Please use STAR approach to structure your examples.
- Situation – Describe the situation you found yourself in and what happened.
- Task – The Hiring Manager will want to understand what you tried to achieve from the situation that you found yourself in.
- Action – What actions did you take and how did you do it. Make sure to use “I”, not “we” to explain how your actions lead to a result.
- Result – Use facts and statistics to demonstrate the results that your actions produced. Explain whether it was a successful outcome, and if not, what you learned from the experience.
Further information on the Success profile elements can be found on Success Profiles – GOV.UK (www.gov.uk)
Person specification
Behaviours
We’ll assess you against these behaviours during the selection process:
- Developing Self and Others
- Communicating and Influencing
- Working Together
- Changing and Improving
Technical skills
We’ll assess you against these technical skills during the selection process:
- Data Architecture
- Features of Power BI
- Use of Power BI
Benefits
- Access to learning and development
- A working environment that supports a range of flexible working options to enhance your work life balance
- A working culture which encourages inclusion and diversity
- A Civil Service pension with an average employer contribution of 27%
- Annual Leave
- Public Holidays
- Season Ticket Advance