Lead BI Developer/Consultant

Job Description

Overview of the client:

An award winning, innovative and fast growing consultancy who works for some of the best known brands in the UK is seeking a Lead Datawarehouse Developer to add to their growing team.

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.

What they are looking for:

Regardless of the role within the business there are certain qualities they look for in their employees:

1. Committed... doing what it takes for lasting results.
2. Together... combining our expertise to create smarter solutions.
3. Driven... personally aiming high and wanting better.
4. Smart... being smart with common sense.
5. Passionate... about what we do

Key responsibilities and accountabilities:

Development and Delivery

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

Personal and company growth – c. 20%

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

Team engagement

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

Other

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

Desired personal characteristics:

Knowledge

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

Skills

1. Technical skills including:
   1. Microsoft SQL Server Database engine
   2. Microsoft SQL Server Integration Services
   3. Microsoft SQL Server Analysis Services
   4. Microsoft SQL Server Reporting Services
2. Strong analytical thinking
3. Attention to detail
4. Other database platforms, including Oracle, PostGreSQL (helpful but not required)
5. Other BI applications, including Tableau, QlikView, Alteryx (helpful but not required)
6. C#.NET, ASP.NET, or other traditional coding (helpful but not required)

Experience

1. Extensive experience in the Microsoft BI Tool Stack – minimum 6 years
2. Hands on success delivering business intelligence / data warehouse solutions is required
3. Experience of creating OLAP cubes required
4. Responsibility for leading projects/teams required
5. Evidence of solving complex development problems on projects required.
6. Extensive Experience of client engagement and management
7. Experience of defining development and best-practice standards

Ref: RA013 | Published: 06th Mar 2015