Senior Power BI Developer - GLD - G7
Government Digital & Data -
The Government Legal Department is the largest provider of legal services across government, working on high profile matters that are frequently scrutinised in Parliament and the media. Our work includes:
- Developing and drafting legislation
- Providing legal advice on policies
- Securing our economic and trade relationships
- Ensuring value from commercial contracts worth billions of pounds
- Providing the Civil Service’s employment law advice
We are at the heart of delivering the Government’s priorities and our success depends on our people.
GLD is a non-ministerial government department, sponsored by the Attorney General. We are headed by the Treasury Solicitor, our Permanent Secretary and employ nearly 3000 people, including over 2000 legal professionals. Our offices include London, Leeds, Bristol, Croydon and Manchester as well as overseas. We provide specialist legal services including Litigation, Employment and Commercial Law as well as advising most Government Departments on the policies and services they deliver.
GLD also depends on a range of vital corporate services. These are essential to the smooth and efficient running of the Department and provide the foundation to enable GLD to deliver outstanding legal services. Our corporate functions include Strategy, HR, Finance, Digital, Data and Technology, Communications, Security, Commercial and Project delivery.
Our vision is to be an outstanding legal organisation and a brilliant place to work where everyone can thrive and fulfil their potential. This is an exciting time for GLD, with cutting edge legal work on global issues and a transformation agenda which is ensuring the Department exemplifies the Modern Civil Service.
To find out more about what we do visit the Government Legal Department’s webpage or have a look at this short film which showcases the breadth of work government lawyers and legal trainees are involved in.
Job description
About the Digital, Data and Technology
This is an unprecedented time for Digital, Data and Technology specialists as government harnesses digital technologies, skills and tools to transform public services. There have never been more opportunities to work collectively and creatively as a profession to respond to the changing needs and expectations of millions of people and deliver services that are simple and easy to use.
The Digital, Data and Technology profession comprises of over 25,000 colleagues across Government and is rapidly scaling up nationwide in line with our strategy.
In your capacity as PowerBI developer at GLD you will join a network of Digital, Data and Technology professionals that has developed into an essential forum for co-ordinating and driving transformation across government.
With your senior colleagues from other government departments, you will set standards and maintain a shared vision to deliver transformation.
You will share best practice and drive collective efficiencies wherever possible; support and guide our cross-government programmes to build digital, data and capability; and make government a destination of choice for Digital, Data and Technology professionals. And you will be a role model and a relentless champion of government as a place where everyone can thrive and where diversity can flourish; a place that reflects the public we serve.
The potential to shape our society’s future is enormous and our purpose is to ensure the profession is equipped and inspired to deliver real, meaningful change for users; to do the work of transformation that makes government work better for everyone.
Find out more about the Digital, Data and Technology Profession here.
About the Role
The Role
We are looking for a PowerBI developer to join our Digital, Data and Technology team at Government Legal Department. You will be an experienced developer who can manage multiple deliverables from data extraction to report delivery.
Reporting to the DevOps Manager, you will join the Digital team who are responsible for the maintenance and continuous improvement of existing products and services, and the development of new digital services to support GLD staff working across government. Your main day-to-day responsibilities will include:
- Analysing and reporting test activities and results, supporting data engineers and stakeholders on data analysis issues, managing the development pipeline for Power BI products including development, test and production workspaces.
- Analysing problems and experimenting with possible solutions to find the underlying causes of issues or discrepancies to identify problems and to assist in the development of innovative solutions in Power BI.
- Designing and implementing a data streaming service, including the development of new data models and ETL processes.
- Ensuring the successful delivery of completed data loads for customers, and Data Engineers, troubleshooting where required.
- Designing, building and testing data products and solutions that are complex or large scale, through full development, test and deployment lifecycles.
- Applying concepts and principles of data modelling and producing relevant and varied data models across multiple subject areas and providing guidance on how to use them.
- Delivering continuous improvement by identifying positive changes that can be carried out to improve performance e.g. to improve data quality and storage capacity.
- Designing, writing, iterating and optimising code from prototype to production-ready.
- Leading work on database management and mapping data to the agreed data model.
- Translating and presenting clear insights from data profiling and source system analysis to support the end use of the data, while being an advocate for the team.
- Reviewing requirements, specifications and defining test conditions.
- Documenting and updating reporting solutions to produce and maintain an archive of product functionality.
- Working with data privacy and information security staff to assure that security and privacy requirements are identified and addressed in solutions
Key Responsibilities:
The key responsibilities required align with the cross-government Digital, Data and Technology Profession Capability Framework: Technical and Data job families.
- Agile working. You can identify and compare the best processes or delivery methods to use, including measuring and evaluating outcomes. You can help the team to decide the best approach. You can help teams to manage and visualise outcomes, prioritise work and adhere to agreed minimum viable product (MVP), priorities and scope.
- DDaT perspective. You can demonstrate a working understanding of design, technology and data principles. You can understand the variety and complexity of users’ digital needs, and how the product will meet those needs. You can show an awareness of assisted digital support and can explain why it’s important. You can design services and make decisions to meet user needs.
- Development process optimisation. You can explain the importance of developing process efficiency and the common ways in which processes are optimised. You can support specific activities to improve development processes. You can spot or identify obvious deficiencies.
- Information security. You can understand information security. You can design solutions and services with security controls embedded, specifically engineered with mitigation of security threats as a core feature.
- Modern standards approach. You can competently apply a modern standards approach and guide others to do so.
- You can approach prototyping as a team activity, actively soliciting prototypes and testing with others. You can establish design patterns and iterate them. You can use a variety of prototyping methods and choose the most appropriate.
- Service support. You can help fix faults following agreed procedures. You can carry out agreed maintenance tasks on infrastructure.
- User focus. You can collaborate with user researchers and can represent users internally. You can explain the difference between user needs and the desires of the user. You can champion user research to focus on all users. You can prioritise and define approaches to understand the user story, guiding others in doing so. You can offer recommendations on the best tools and methods to use. (Skill level: practitioner)
Person specification
Behaviours- Essential
Below are details of the Success Profiles that make up this role. Demonstrating all the behaviours listed below is essential.
You will be expected to provide evidence to show how you meet the criteria at interview and/or selection stage.
We'll assess you against these behaviours during the selection process:
- Changing and Improving (Lead behaviour)
- Delivering at Pace
- Making Effective Decisions
For further information about Civil Service recruitment processes and Success profiles, please visit:
https://www.gov.uk/government/publications/success-profiles
Experience
Essential-
- Working autonomously, while managing multiple deadlines and responding to changing priorities
- Engaging colleagues who are less familiar with product management
Desirable-
- Familiarity with the Government Service Standard
Technical - Essential
- Extensive experience of Agile working
- Expert Power BI skills
- Confident and demonstratable Database development
- Exposure and Implementation of Microsoft Fabric
Security Clearance
- If successful you must hold, or be willing to obtain, security clearance to SC security clearance level, however, candidates will be able to start in role with BPSS More information about the vetting process and UK footprint can be found here
Behaviours
We'll assess you against these behaviours during the selection process:
- Changing and Improving
- Delivering at Pace
- Making Effective Decisions
Technical skills
We'll assess you against these technical skills during the selection process:
- The first stage is a telephone interview. This is to test your technical skills. A list of questions will be asked, and this will take no longer than 20 minutes. This will be scored.
