BI Tech Lead (DBN)

Apply Now

Job Description

Duties & Responsibilities

BI Technical Lead

We are on the lookout for a (BI Tech Lead) Business Intelligence Technical Lead who will take charge of one of our clients technical Teams. They are looking for a Team player that will ensure the smooth functioning of technical operations – someone who will be responsible for helping their Team Members with technical aspects of their jobs.


Bachelor’s degree in Computer Science, Engineering, or a related field.
8-10 years of experience in a senior technical role.
Experience in creating robust ETL pipelines.
Experience in Python or any other object-orientated languages (C#, Java, scala etc), experience with Spark, in-depth knowledge of SQL development.
Proven ETL experience using SSIS.
The ability to create efficient T-SQL objects and processes according to spec (databases, tables, stored procedures, business rules and functions).
Advanced experience in T-SQL query optimisation, troubleshooting and debugging.
In-depth understanding of database management systems, online analytical processing and ETL framework.
Advanced knowledge of the Kimball Data Warehouse Lifecycle.
Expert experience in creating and maintaining multidimensional cubes using SSAS.

What You’ll Do:

Engage regularly with software architects in order to ensure the development within the Team is according to architectural guidelines.
Work with other developers, designers/analysts, and architects to make sure that the solutions meet application requirements and performance goals.
Ensure that all technical solutions that are rolled out consider compatibility with other environments and dependencies, have a high usability factor, are reliable to reduce downtime and perform at maximum efficiency during peak periods of usage, and consider security at its highest level (third-party attacks, data protection etc).
Demonstrate initiative by understanding, acquiring and implementing new knowledge and skills both within the Team and to the wider group.
Incorporate new abilities into the day-to-day operational activities to improve the performance of products and systems.
Ensure techniques, technologies, tools and processes used are in line with industry best practices.