BI Tech Lead (DBN) at Xcede

We are on the lookout for a 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.

Requirements:

• 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.