The following content displays a map of the jobs location - Chelmsford

Business Intelligence Analyst

Job Reference 7175

The job has expired.

Number of Positions:
1
Contract Type:
Full Time
Salary:
£25,000 to £30,000
Location:
Chelmsford
Closing Date:
03/01/2019
Job Category:
PTS Management
Region / Division:
UK & Ireland
Business Unit:
UK Central Government Services

Main Responsibilities

Business Intelligence Analyst - Patient Transport Services

Chelmsford, CM1 1GU

£25,000 to £30,000 per annum

Full Time, 40 hours per week 

Job Outline:

You will join a small, growing team who are broadly responsible for business reporting & analysis to support business in decision-making. The successful candidate will manage and automate all manual reports in SQL Server (relational database) using advanced SQL scripts. Integrate various open sources of data for seamless business reporting and analysis. Perform data analysis, build predictive modelling etc. and publish business insights in the form of dashboards using Tableau/Power BI tool on a regular basis. Introduce various automated solutions for data cleansing, data quality and data transformation.

 

Responsibilities: 

  • Preparing and sharing various MI reports with key insights and visualisations to internal/external stakeholders through dashboard using Tableau/Power BI tool
  • Automating various manual reports into SQL Server under SSRS targeting/ moving towards no manual reporting
  • Identifying various open sources of data, constantly integrating open data sources for seamless automated MI reporting and constantly improving data quality
  • Creating new metrics and KPIs effectively guiding the business and deploying effective dashboards to surface them to senior leadership/management
  • Performing data analysis, hypothesis testing, bringing deep insights and building various predictive models in supporting business decision making
  • Providing informal direction and guidance to other team members on all aspects of analytics from business context and prioritization to technical coaching
  • Expanding MI reporting support to other business units within the organisation
  • Managing and administering a account-wide reporting infrastructure based on MS SQL Server Reporting Services and MS SQL Server Analysis Services
  • Developing and constantly improving SSIS, SSAS and SSRS on a regular basis
  • Analyse, develop and deliver a wide variety of reports (external, internal as well as ad-hoc queries) required across all areas of the business
  • Developing and maintaining tools for automating ETL processes of large volumes of data from various sources
  • Maintaining detailed in-depth knowledge of the data architecture and structure of main software system(s)
  • Perform data analysis using Tableau/ Power BI tool for various business requirements on a regular basis
  • Strong data visualisation skills together with experience of creating dashboards such as Tableau/ Power BI

The Ideal Candidate

Key Competencies:

  • Understanding the organisation environment
  • Dealing and adapting changing circumstances while supporting and working with other Business Units
  • Delivering business objectives and constantly improving
  • Dealing with day today complexities and simplifying
  • Delivering great customer service and experience while managing stakeholders internally and externally

Essential Skills: 

  • Strong analytical skills with the ability to collect, organise, analyse and disseminate significant amounts of information with attention to detail and accuracy
  • Knowledge and experience in relational database concepts, design, constraints, stored procedures, functions and optimization
  • Strong command of SQL, for both Data Definition Language and Data Manipulation Language
  • Commercial Tableau/Power BI experience in creating reporting dashboards and data visualisations
  • Strong Data Analysis experience using SQL skills
  • Strong data manipulation and task automation skills are highly desirable
  • Commercial experience in managing and working with large data sets
  • Advanced Excel, Macros, VBA Skills
  • Pro-active, self-driven, analytical and critical to use the power of analytics to solve large, unstructured business problems, validate hypothesis and challenge the status quo breaking tradition way of working

Desirable Skills:

  • Data Analysis experience using R/Python
  • Introduction of Machine Learning based solutions
  • Good experience/ understanding of Cloud environments like AWS, Azure and Google
  • Collaborating experience within various teams/ departments for day today data requirements and business process understanding to automate and fix potential the gaps
  • Deploy technological solutions in all aspects of businesses and automate manual tasks to optimise overall productivity and performance