Lead SQL BI Developer - SSIS, Kimball, SSAS, SSRS

Our client an established Technology Organisation is urgently looking for a Lead SQL BI Developer. This is a fantastic contract opportunity, I have interview slots booked for this week, please apply ASAP.

OBJECTIVE OF THE LEAD SQL BI DEVELOPER ROLE:

To be the lifeblood of their data-driven and analytical projects, providing Datamodelling 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 SQL BI Team Leads, you will have responsibility for timely delivery of projects, solution architecture, pre-sales technical expertise and influencing team direction.

You will need to have Expert knowledge of Business Intelligence/Data warehouse theory (Kimball method strongly preferred)

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 Datamodelling 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 (eg SMS alerting)..

2. Team engagement

-

Mentoring and support of junior members of team
-

Leading the team with technical expertise and project experience
-

Bring best-practice BI to the team, improving internal team processes and increasing team knowledge

LEAD SQL BI DEVELOPER KEY SKILLS:

-

Technical skills including:

-

Microsoft SQL Server Database engine
-

Microsoft SQL Server Integration Services, SSIS
-

Microsoft SQL Server Analysis Services, SSAS
-

Microsoft SQL Server Reporting Services, SSRS

-

Strong analytical thinking
-

Attention to detail
-

Other database platforms, including Oracle, PostGreSQL (helpful but not required)
-

Other BI applications, including Tableau, QlikView, Alteryx (helpful but not required)
-

C#.NET, ASP.NET, or other traditional coding (helpful but not required)

EXPERIENCE REQUIRED:

-

Extensive experience in the Microsoft BI Tool Stack - minimum 6 years
-

Hands on success delivering Business Intelligence/data warehouse solutions is required
-

Experience of creating OLAP cubes required
-

Responsibility for leading projects/teams required
-

Evidence of solving complex development problems on projects required.
-

Extensive Experience of client engagement and management
-

Experience of defining development and best-practice standards

If you are a Lead SQL BI Developer with the above skill set please reply with your latest CV ASAP