Lead BI Analyst Developer

This job has now expired please search on the home page to find live IT Jobs.

SUMMARY:

The UK’s fastest growing and largest independent energy supplier is seeking Lead BI Analyst Developer with experience in the SQL Server database and BI Suite to join their expanding team.We are a technology led company and this role sits within the Business Technology Group. Within the BTG you will spend time on research days and you will actively contribute to formal knowledge share sessions and to informal 121 knowledge transfer.

This opening comes at an exciting stage of the business’s development and offers a fantastic opportunity to be part of a team hungry to make a difference.

We are the ‘Growing Business Awards’ Growing Business of the Year 2014 and the only energy company to have been listed in the fast track 100 for four consecutive years. We have recently been listed in the top ten of the Top Track 250 and are the highest ranking energy company on the list.

ROLE OVERVIEW:

This is an opportunity to manage a small team within a department of over 20 BI Analyst Developers, including many experts in the latest MS SQL Server technologies.You will develop processes to bring new data into the Warehouse, create new "golden" versions of the truth in our marts and enable user access through reporting technologies including; SSRS, QlikView and Roambi.

Team resources are organised into; strategic projects, ad hoc requests and business partnerships with key departments. Whichever team you work in, you will find that for every hour of your time you spend as a "developer"; creating new windows on the data, you will spend 7 hours on "analysis"; working with clients to get them comfortable with unexpected results, to work around quirks in the data and to resolve data quality issues.

AREAS OF SPECIFIC RESPONSIBILITY:

Lead and inspire a small team of BI Analyst Developers to deliver accurate and insightful business intelligence

Contribute to the design and development of Data Marts including the development of TSQL and SSIS based processes to populate Marts with new information

Report development and productionisation in; SSRS, QlikView, Roambi and other potential technologies under investigation

Perform ad hoc "slice and dice" data analysis to inform business decisions

Authoring technical and user documentation

THE DESIRABLE CANDIDATE WILL HAVE:

Essential:

Expert level skills with TSQL in a data warehousing, data mart reporting environment.

Experience with MS SQL Server BI Suite 2012 (Enterprise Edition) and SSRS

Proficient in the SSIS and SSAS MS SQL Server packages

Successful experience in managing high performance from small teams of analyst developers

Successful experience in stakeholder management through the delivery cycle; agreeing requirements, estimating work, prioritising across competing demands, planning and scheduling, overseeing delivery and user acceptance

"Hands on" able to drop into the technical detail to get the job done but also able to communicate technical detail in ways that non-technical business users can understand

Desirable:

Familiarity with Oracle and/or Postgres PLSQL

Familiarity with alternative reporting technologies e.g. Tableau, QlikView, Roambi

Experience in managing delivery to a wide range of end users including Sales and Marketing, Finance, Customer Services, Billing, etc.

Experience of the Energy Supply market

THE BENEFITS:

As well as a rewarding career, development opportunities and competitive salary, you’ll also enjoy 25 days holiday (plus Bank Holidays), pension, option to purchase childcare vouchers, and become eligible for our staff energy tariff along with other great ad-hoc offers

We believe in putting energy into looking after our teams, so you’ll benefit from BUPA Private Healthcare, cycle to work scheme, a great working environment with relaxation areas to recharge your batteries and free soft drinks available all day. We also have "Fruity Friday" where fresh fruit is available every week for all employees.

OTHER:

All applicants must be eligible to live and work in the UK and ideally be within commutable travelling distance of Warwick.

To apply for this role, click the APPLY button below.