Business Improvement & Intelligence Technical Advisor x 2 | £34,788 - £37,849
Full time / Temporary

Closing Date: 27/09/2020 | Job Ref: C/50126321 /50126321 | Directorate: Core | Service: Business Improvement, HR & Communications | Location: Westgate, Barnsley, South Yorkshire

Salary: £34,788 - £37,849 Plus laptop and phone

Working Arrangements: Monday to Friday Plus agile working

Hours per week: 37

Contract type: Fixed term for 12 months - potential extension of the contract beyond 12 months will be subject to funding 

Flexible working arrangement

This post is suitable for Job Share 

Suitable for Secondment: Employees wishing to be considered for secondment should agree with their head of service before submitting an application form. 

See our range of Employee Rewards

Closing date: 27/09/2020 at 23:59

 

 

This post requires a Basic Criminal Record Check 

 

 

Prospective employees will be required to give a reasonable account of any significant periods (6 months or more in the past 3 years) of time living abroad.

 

 

Pensions Regulations have provisions to reduce pension payments in certain circumstances of those who return to work within local government service.  If you are in receipt of a pension upon commencing employment with the authority, this may affect your pension entitlements and you should therefore seek advice from the relevant Pensions Authority.

 

 

About the Post: 

BI Technical Advisor 

 

Barnsley Metropolitan Borough Council is recruiting a Fixed Term (12 months) Business Intelligence Technical Advisor. 

 

The Business Intelligence Technical Advisor role will help power the ‘engine room’ for the corporate business improvement and intelligence team. Technically skilled and adept, you will drive forward our #digitalfirst Data Management framework to improve data across the organisation. You will also develop innovative solutions to present the data back as information and intelligence to a wide-ranging audience. The team have been supporting our COVID-19 response, building technical solutions of which you would be an integral part of going forward. The Team work to follow Agile and Scrum principles.

 

Examples of the work you may be doing are:

  • Using FME to create complex data flows – both spatial and non-spatial
  • Use Python to generate PDF maps at the touch of a button
  • Use Microsoft Power Query to extract, transform and load data into an Excel data model.
  • Use Microsoft Power Pivot to manage Excel data models and create Measures using DAX.
  • Use Excel's OLAP Tools to construct advanced formulas.
  • Visualise data using Power BI to demonstrate the effectiveness of our ASB interventions
  • Write an SQL query that joins multiple system tables together to create an Adults Social Care data model
  • Extract data from multiple systems to our Corporate Data Warehouse to create a Vulnerability Model
  • Use API’s to pull data from the web to join with local sources of information, creating a Barnsley view of Active Travel
  • Researching the use of data mining, machine learning and predictive analytics.
  • Integrate spatial data to enrich the intelligence to allow targeted intervention by locality 

 

 

 

You must be willing to adapt and work independently but still be a critical part of the team and work closely with your colleagues to ensure a consistent message is provided to customers. That message is – data, information, performance and intelligence is crucial in driving forward change and improvement. 

 

You will need a relevant level 6 qualification or equivalent to apply for this role. 

 

A Remote / Digital interview will take place early/mid October with a start date as soon as possible after that. 

 

Currently it is our policy to work from home/remotely wherever possible, but you may on occasion need to visit the office within Barnsley town centre.

 

Shape a better future with us 

 

We’re thrilled to have achieved Investors in People (IIP) Gold status for how we lead, support and develop people. Now we’d like you to be part of our success and help us take change further. Join us on our journey to a brighter future. By working together, with each other and with our communities, we can take pride in improving lives. Let’s make a better Barnsley for everyone. 

 

A lot to look forward to 

 

Here at Barnsley, we live and work by four important values: honesty, teamwork, excellent service, and taking pride in what we do. As part of our team, you can be sure we’ll do all we can to support you in being truly excellent. You see, we prioritise learning and enabling you to achieve your potential. So we’ve created a development process that lets you grow in the way that suits you - whether that’s training to be a leader, or learning flexibly online. That’s one of the reasons why we achieved IIP Gold, and why you’ll find your career here inspiring and rewarding. 

 


Please use the documents below to help support you with your application form.

 

 

Job Profile: Business Intelligence Technical Advisor Job Profile.pdf

 

Vacancy Exposure Profile: Exposure Profile.pdf

 

Help with your application form

 

Why work for us?

 

 

 

Barnsley Council is passionate about Equal Opportunities and Flexible Working. We're committed to equality and diversity in all aspects of our work and welcome candidates with a broad diversity of talent. We are committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment. Click here for more information.

 

 

 

CVs will not be accepted.

 

 

www.barnsley.gov.uk/jobs 

 

Vacancy Description
Closing Date: 27/09/2020 | Job Ref: C/50126321 /50126321 | Directorate: Core | Service: Business Improvement, HR & Communications | Location: Westgate, Barnsley, South Yorkshire
 

Salary: £34,788 - £37,849 Plus laptop and phone

Working Arrangements: Monday to Friday Plus agile working

Hours per week: 37

Contract type: Fixed term for 12 months - potential extension of the contract beyond 12 months will be subject to funding 

Flexible working arrangement

This post is suitable for Job Share 

Suitable for Secondment: Employees wishing to be considered for secondment should agree with their head of service before submitting an application form. 

See our range of Employee Rewards

Closing date: 27/09/2020 at 23:59

 

 

This post requires a Basic Criminal Record Check 

 

 

Prospective employees will be required to give a reasonable account of any significant periods (6 months or more in the past 3 years) of time living abroad.

 

 

Pensions Regulations have provisions to reduce pension payments in certain circumstances of those who return to work within local government service.  If you are in receipt of a pension upon commencing employment with the authority, this may affect your pension entitlements and you should therefore seek advice from the relevant Pensions Authority.

 

 

About the Post: 

BI Technical Advisor 

 

Barnsley Metropolitan Borough Council is recruiting a Fixed Term (12 months) Business Intelligence Technical Advisor. 

 

The Business Intelligence Technical Advisor role will help power the ‘engine room’ for the corporate business improvement and intelligence team. Technically skilled and adept, you will drive forward our #digitalfirst Data Management framework to improve data across the organisation. You will also develop innovative solutions to present the data back as information and intelligence to a wide-ranging audience. The team have been supporting our COVID-19 response, building technical solutions of which you would be an integral part of going forward. The Team work to follow Agile and Scrum principles.

 

Examples of the work you may be doing are:

  • Using FME to create complex data flows – both spatial and non-spatial
  • Use Python to generate PDF maps at the touch of a button
  • Use Microsoft Power Query to extract, transform and load data into an Excel data model.
  • Use Microsoft Power Pivot to manage Excel data models and create Measures using DAX.
  • Use Excel's OLAP Tools to construct advanced formulas.
  • Visualise data using Power BI to demonstrate the effectiveness of our ASB interventions
  • Write an SQL query that joins multiple system tables together to create an Adults Social Care data model
  • Extract data from multiple systems to our Corporate Data Warehouse to create a Vulnerability Model
  • Use API’s to pull data from the web to join with local sources of information, creating a Barnsley view of Active Travel
  • Researching the use of data mining, machine learning and predictive analytics.
  • Integrate spatial data to enrich the intelligence to allow targeted intervention by locality 

 

 

 

You must be willing to adapt and work independently but still be a critical part of the team and work closely with your colleagues to ensure a consistent message is provided to customers. That message is – data, information, performance and intelligence is crucial in driving forward change and improvement. 

 

You will need a relevant level 6 qualification or equivalent to apply for this role. 

 

A Remote / Digital interview will take place early/mid October with a start date as soon as possible after that. 

 

Currently it is our policy to work from home/remotely wherever possible, but you may on occasion need to visit the office within Barnsley town centre.

 

Shape a better future with us 

 

We’re thrilled to have achieved Investors in People (IIP) Gold status for how we lead, support and develop people. Now we’d like you to be part of our success and help us take change further. Join us on our journey to a brighter future. By working together, with each other and with our communities, we can take pride in improving lives. Let’s make a better Barnsley for everyone. 

 

A lot to look forward to 

 

Here at Barnsley, we live and work by four important values: honesty, teamwork, excellent service, and taking pride in what we do. As part of our team, you can be sure we’ll do all we can to support you in being truly excellent. You see, we prioritise learning and enabling you to achieve your potential. So we’ve created a development process that lets you grow in the way that suits you - whether that’s training to be a leader, or learning flexibly online. That’s one of the reasons why we achieved IIP Gold, and why you’ll find your career here inspiring and rewarding. 

 


Please use the documents below to help support you with your application form.

 

 

Job Profile: Business Intelligence Technical Advisor Job Profile.pdf

 

Vacancy Exposure Profile: Exposure Profile.pdf

 

Help with your application form

 

Why work for us?

 

 

 

Barnsley Council is passionate about Equal Opportunities and Flexible Working. We're committed to equality and diversity in all aspects of our work and welcome candidates with a broad diversity of talent. We are committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment. Click here for more information.

 

 

 

CVs will not be accepted.

 

 

www.barnsley.gov.uk/jobs