Senior/Lead BI Developer, London, £65K

Overview of the company
Our client is an award winning, innovative and fast growing business consultancy who works for some of the best known brands in the UK. We pride ourselves in developing high quality products and solutions and deliver value for our clients by combining the latest technologies with the best ways of doing business.  Our ability to bring together advanced analytics and software development enables us to design, build and deploy customised products that have a positive impact on our clients’ bottom lines.   We are team players with a can do culture, who are undergoing rapid expansion and have recently grown our management team in order to achieve our growth plans.
We have achieved Microsoft Gold Partner status in recognition of our dedication to providing quality solutions, establishing and maintaining professional relationships and most importantly our belief in the continued development of our employees.

Overview of role
To be the lifeblood of our data-driven and analytical projects, providing data modelling for complex projects; design and build out data warehouses; and design and build out ETL solutions to extract, clean, conform, and design and built of multidimensional cubes, and deliver data to the warehouse.  As one of the BI Team Leads, you will have responsibility for timely delivery of projects, solution architecture, pre-sales technical expertise and influencing team direction.
Key responsibilities and accountabilities
1.         Development and Delivery

• Lead teams of 2-6 people to deliver superior clients results using an Agile development methodology
• Perform data modelling for custom solutions projects 
• Design and develop data warehouses and ETL solutions
• Design and develop multidimensional cubes
• Design and develop data mining solutions (and advanced algorithms depending upon experience)
• Design and develop business intelligence applications and objects (reports, dashboards, scorecards, etc.), including customising of off-the-shelf solution
• Design and develop dynamic dashboards, reports, and other BI delivery solutions (e.g. SMS alerting).

 
2.         Personal and company growth – c. 20%

• Support the sales process by identifying leads, identifying opportunities for project extensions and add-ons, and by supporting proposal development (pre-sales solution architecture)
• Drive intellectual capital by getting involved with internal projects and personal projects, including personal research, white papers, pro bono, etc.

 
3.         Team engagement

• Mentoring and support of junior members of team
• Assist in growing the organisation by getting involved with recruiting
• Leading the team with technical expertise and project experience
• Bring best-practice BI to the team, improving internal team processes and increasing team knowledge

 Other

• Ad hoc duties as reasonably expected by your manager
• Liaising with clients, managing expectations and being the technical point of contact

 
 
Desired personal characteristics
Knowledge

• Degree (2:1 or above) in computer science, mathematics or related subject
• Expert knowledge of Business Intelligence / Data warehouse theory (Kimball method strongly preferred)

Skills

• Technical skills including: 
• Microsoft SQL Server Database engine
• Microsoft SQL Server Integration Services
• Microsoft SQL Server Analysis Services
• Microsoft SQL Server Reporting Services
• Strong analytical thinking
• Attention to detail
• Other database platforms, including Oracle, MySQL (helpful but not required)
• Other BI applications, including Tableau, QlikView, Spotfire (helpful but not required)
• C#.NET, ASP.NET, or other traditional coding (helpful but not required)

Experience 

• Extensive experience in the Microsoft BI Tool Stack – minimum 6 years
• Hands on success delivering business intelligence is required
• Experience of creating OLAP cubes required
• Responsibility for leading projects/teams required
• Evidence of solving complex development problems on projects required.

SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball SQLServer SSRS SSAS SSIS OLAP Kimball 

ALL APPLICANTS MUST BE FREE TO WORK IN THE UK FREE FROM THE RESTRICTIONS OF VISA'S AND WORK PERMITS.
Exposed Solutions is acting as an employment agency to this client.
Please note that no terminology in this advert is intended to discriminate on the grounds of age, and we confirm that we will gladly accept applications from persons of any age for this role.