Job vacancy - BI Developer

Position: BI Developer
Reference: acsCEbidev
Location: Crawley
Salary: £30,000 - £40,000 per annum
GO BACK

Job Title: BI Developer

Do you have technical knowledge of Microsoft SQL Servers (2008/2008R2/2012)? Do you have technical knowledge of dimensional modelling data warehouse designs? Do you have hands-on experience converting ERP software data and integrating data with BI? This is a fantastic opportunity to join a highly experienced team of people.

Key responsibilities

  • Work with business users across all departments to gather reporting requirements.
  • Develop new and existing reports to meet business requirements, presenting data in a clear and concise manner.
  • Develop the data warehouse and cubes to ensure that information required by the business is available to be reported on.
  • Support users of the Targit reporting application.
  • Support business users by investigating queries related to data integrity and by providing definitions for reports or figures where the user is unsure of what it represents.
  • Maintain the reporting solution to ensure that a high level of performance and reliability is upheld.
  • Liaise with the Navision development team to be kept informed of any changes which will result in new data being generated that may need to be reported on.
  • To be involved in IT meetings and bring suggestions and new ideas to the table.
  • Work towards implementing new BI solutions and suggest ideas to improve the current solutions.

Brand Ambassador:

You are an ambassador and role model for our brand; from the way you present yourself to the knowledge you have of our brand and the enthusiasm and motivation that drives everything you do.

The purpose of your role:

You are responsible for maintaining and developing the reporting solution for the business to enable them to make informed commercial decisions.

Those ad hoc duties:

As with all roles, you may at times be required to carry out ad hoc duties; whether that is to support another team member, to take on additional responsibilities or to get involved in project work that may impact not only on your department but also the wider business.

Our expectations:

Technical knowledge of:

  • Microsoft SQL Server (2008/2008R2/2012), including writing queries and creating database objects.
  • Dimensional modelling data warehouse design.
  • T-SQL scripts (read and understand essential, writing new from scratch will be required.)
  • SQL Server Store Procedures, Functions and SQL Agent jobs.
  • SQL Server Report Manager or similar (design and deployment of reports from SQL and Analysis Services sources).
  • Analysis Services cube design and maintenance (architecture and writing MDX queries).
  • Integration Services package maintenance (small scale usage).
  • Experience configuring and supporting End User reporting tools (Targit, Business Objects, Crystal Reports, etc.)
  • Hands-on experience converting ERP software data and integrating data with BI.
  • Data warehouse/ Cube design and development.
  • Strong MS Excel skills (macros, data import from Analysis Services, linked worksheets/workbooks).
  • SSIS, SSRS and SSAS experience.

ACS are recruiting for a BI Developer If you feel that you have the skills and experience required in this advertisement to be a BI Developer please submit your CV including an outline of your experience as a BI Developer It is always a good idea to include a covering letter outlining your experience as BI Developer with your application as this will enhance your chances of selection and improve your prospects of landing the BI Developer role you desire.