IT Engineer - Senior Power BI Developer, Carpenter House, Perth

Job Description

IT Engineer, Senior Power BI Developer - PKC11824
£38,310 - £42,083
Carpenter House, Perth

We are recruiting for an IT Engineer - Senior Power BI Developer to join Perth and Kinross Council's Data Services team, to work on our Data and Analytics programme, a key part of the Council’s Digital Strategy.

This role is responsible for supporting the development of Business Intelligence & Analytics solutions using Microsoft Power BI.

Perth and Kinross Council has a continuously expanding demand for reporting solutions/ data products and is recruiting to support this endeavour.

The Data Services team provides a wide range of data and analytics services to the Council:

• Platform management and support services for our Microsoft Power BI platform.
• Data analytics services, building and managing Power BI Apps, Reports, Dashboards, and other apps based on the needs of the Council and our partners.
• Training, support and advisory services for users.
• Data engineering\modelling services, building data pipelines using SQL, Power Query, DAX and using other Microsoft technologies to produce trusted data products for services.
• Data custodianship services including data quality management, improvement and distribution of datasets to both internal and external users.
• Awareness raising, producing high-quality publications illustrating the value of data and analytics to the organisation.

Reporting to the Business Intelligence & Analytics co-ordinator, you will undertake the role of IT Engineer - Senior Power BI Developer with responsibility for managing the Council’s Power BI platform, gathering customer requirements, producing high-quality reports, providing training\support to users and coordinating the development of intelligence products and workflows.

You will also participate in data management and custodianship services, advising on data quality and standards matters, and ensuring corporate data is managed as planned.

You will work closely with staff responsible for the ESRI ArcGIS Enterprise platform, providing an end-to-end professional analytics service.

We are proud of our track record of providing an excellent and professional service. Our success is in part due to a shared ethos where everyone is involved, and has the opportunity to progress quickly as their skills and experience develops.

We also work collaboratively both internally and externally with partner organisations across the public sector. Therefore these posts offer a great opportunity to develop skills and gain experience that are in high demand using best of breed data and analytics solutions.

For purposes of connection and collaboration with colleagues and with the community we serve, our full-time employees work on site for a minimum of 2 days per week with the arrangements for part time employees being agreed on a basis which will ensure that they benefit to an equivalent degree.

Our FAQs on hybrid working can be found here Hybrid working FAQs.

We are committed to being a more inclusive employer - to ensure we can consider any reasonable adjustments, please either contact the recruiting manager to discuss any individual circumstances, discuss at interview or, if you prefer, after any conditional offer is made.

Requirements

We are keen to hear from you if you have working experience relevant to the roles described above.

You will also have excellent technical, analysis, communication and time management skills, and will be capable of hitting the ground running and quickly become a productive member of the team.

You will be educated to HND level in an appropriate discipline or have significant operational experience in a relevant professional environment.

You will have a creative, positive attitude; working experience of data and analytics technologies and methods; and an informed, professional approach.

You must be able to communicate fluently orally and in writing and should be able to evidence good organisational and facilitation skills.

You must demonstrate a working knowledge and experience across the following technical areas:

• Business Intelligence and Analytics technologies such as Microsoft Power BI, Microsoft Fabric and Microsoft SQL Server.
• Advance Microsoft Power BI skills:
  • data visualisation and storytelling
  • data cleansing/modelling using Power Query, SQL and DAX
  • data modelling using Star Schema
  • Row Level Security.
• Lead the end-to-end lifecycle of Power BI projects, from requirements gathering and design to deployment and maintenance
• Oversee Power BI Developers and provide mentorship and technical guidance to the BI development team
• Communications skills including the ability to translate technical concepts into non-technical language
• Data management with understanding of approaches to data governance and data quality improvement
• Analytical problem-solving skills
• Logical and creating thinking skills
• Statistical methods and data analysis skills
• Basic database design for both transactional and analytical purposes
• Basic data engineering concepts

Experience of some of following is highly desirable:

• Microsoft Fabric: Data Factory, Notebooks (Python), LakeHouses.
• Data standards, data and metadata management.
• Contributing successfully in a customer facing team environment.
• Participating in multi-disciplinary groups.
• Writing for business.
• Data protection law and approaches to compliance.

The Individual

If you would like more information about this vacancy or to discuss the role further, please contact Craig Walker, IT Co-ordinator – Business Intelligence & Analytics at cmcwalker@pkc.gov.uk

When completing your application for this post, please ensure that you provide contact details (including e-mail addresses) for two referees. One should be your current or most recent employer.

Please APPLY ONLINE. Facilities are available at all public libraries in Perth and Kinross. If you have a disability and require reasonable adjustments, please call 01738 475555 to discuss.

As part of our safer recruitment measures, any offer of employment will be subject to the successful completion of mandatory checks including eligibility to work in the UK, Disclosure Scotland or PVG, qualifications, references, and fitness to undertake the post. This may also include an Overseas Criminal Records Check if you have spent time living overseas.

A healthy work life balance is important to Perth & Kinross Council and we provide supportive management and flexible working arrangements to help you achieve a healthy work life balance. You will have access to training and support for continued professional development.

Some jobs may have been traditionally carried out predominately by one gender, but we would encourage you to apply if you meet the requirements, irrespective of your gender.

Perth & Kinross Council welcomes applications from former armed forces personnel/reservists. Many of the skills picked up during your military career could be transferred directly into a role with local government.

At PKC our values and behaviours influence our work and support us in the delivery of the Perth and Kinross Offer. In your application, and should you be invited to interview, you will be asked to describe situations that support the criteria required in the role and which also demonstrate our values and behaviours. Find out more about PKC and you could soon be joining our team!

Find out more about working for Perth & Kinross Council and living in one of the most scenic areas of Scotland Jobs, careers and employment.

What we can do for you

If you are successful in a role with Perth & Kinross Council, you will have access to a range of benefits to help your physical, mental and financial wellbeing.