Senior Business Intelligence BI Developer - Finding Patterns in our Data

  • Full-time

Company Description

JJ Food Service Ltd is the UK’s leading food service delivery and collection provider of food items which has shown immense growth since it was established in 1989. JJ serves more than 30,000 customers from eight distribution centres (London, Doncaster, Sidcup, Manchester, Aston, Basingstoke, Bristol and Leeds).

Job Description

 ·         Responsible for the day-to-day operation of the computer installation together with associated functions such as data control and data preparation.

·         Define the Architecture and the various phases to create the data warehouse.

·         Creating the Multi Dimensional data model (STAR Schema) and enhanced it to meet the growing requirements. SSAS Cube design and maintenance

·         Creating the ETL (SSIS) architecture and provide strategy related to data cleansing, data quality and data consolidation

·         Performing data mining to identify significant relationships, find previously undiscovered connections, and form insightful, actionable conclusions and recommendations

·         Analyze customer transactional data across multiple dimensions, including customer segments, product categories and location in order to mine opportunities and drive marketing improvement.

·         Design, built and implement behavioural regression models that predict revenue opportunities for company

·         Creating the Design for Extraction process from legacy systems using combined techniques of Data Replication and Change Data Capture

Qualifications

 ·       The candidate must have minimum MSc degree in ‘Data warehousing and Data mining’ or ‘Distributed Data Warehousing and Data Mining’ or Phd degree in relevant field.

·       Candidate should have research ability and at least one research publication in international journal will be proven that the candidate have research ability.

·       The candidate must have minimum 5 years’ experience in Business Intelligence

·       Good hands-on experience in SSIS, SSAS, SSRS

·       Experience of developing data warehouse and good experience and sound knowledge about Kimball and Inmon’s Data Warehouse methodology

·       Should have extensive experience and knowledge in Data mining algorithms i.e. Microsoft Associations algorithm,  Microsoft Decision tree, Microsoft Neural Network, Microsoft Clustering, Microsoft Sequence Clustering, MS Linear Regression algorithm. Microsoft Naive Bayes algorithm, Microsoft Logistic Regression algorithm

·      Performance Troubleshooting

·      Good ability to use mix of T-SQL / MDX / c# to build reports or report solution to help the company

·      Work with the rest of the IT group to understand the performance of reports and pressure report put on key systems

·    Build dashboards in SharePoint or Excel Web Services

Additional Information

Salary

GBP 45000 - 50000 Annual salary

Career level required

Experienced (Non-Manager)

Experience required

5+ years

Education required

Masters degree or postgraduate certificate/diploma

Job type

Permanent

Job status

Full Time

 

If you fulfil the above requirements and are eligible to work in the UK please apply online by uploading your CV and a cover letter detailing the reasons why you have the necessary skills for this role. 

 

JJ Food Service Limited is an equal opportunities employer.