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 Datawarehouse Developer to add to their growing team.

Overview of role:

To be the lifeblood of their 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. 

What they are looking for:

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

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. Work on teams of 2-8 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

Other

1. Ad hoc duties as reasonably expected by your manager

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 methodology strongly preferred)

Skills

1. Technical skills including:
   1. Dimensional Modelling (Kimball)
   2. Microsoft SQL Server Database engine
   3. Microsoft SQL Server Integration Services
   4. Microsoft SQL Server Analysis Services
   5. Microsoft SQL Server Reporting Services
   6. Microsoft PerformancePoint, Power Pivot, PowerView
2. Data Visualisation tools such as Tableau, QlikView, Spotfire very useful
3. Strong analytical thinking
4. Attention to detail
5. Experience of other database platforms, including Oracle, MySQL (helpful but not required)
6. Experience of other BI applications, including Cognos, Business Obj., Hyperion (helpful but not required)
7. C#.NET, ASP.NET, or other traditional coding is a bonus

Experience

1. Extensive experience in the Microsoft BI Tool-stack on Data Warehousing projects
2. Hands on success delivering business intelligence/data warehouse  solutions is required
3. Strong Database knowledge/experience, including maintenance, optimisation, trouble-shooting
4. Experience of creating OLAP cubes (desirable but not essential)
5. You must be a self-starter, able to work with minimal supervision as well as being a strong team player

Relationships/Interactions

External

• Input external contacts and levels this person will interact with

Internal

• Input the key internal contacts and levels this person will interact with

Ref: RA012 | Published: 06th Mar 2015