BI Technical Lead
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.
