Business Intelligence Technical Lead

Job Description Excellent technical, diagnostic, and troubleshooting skills. Excellent communication, motivational, and interpersonal skills. Responsibilities Technical Leadership Provide technical leadership to the team through collaboration sessions and knowledge sharing initiatives. 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 checked in code is reviewed to ensure standards are met and the code base is sound. 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 down time and perform at maximum efficiency during peak periods of usage; consider security at its highest level (third party attacks; data protection etc). Process Adoption Drive the adoption of processes within the team which consider and meet the expectations of technical throughput rates and responses; processing times; effective resource utilization during operation and where the system or solution ensures maximum operational capacity requirements are met. Quality Of Software Implementation Ensure rigorous testing of any solution before deployment and create standards and processes within the team to align to these. Ensure the delivery of a complete and technically appropriate solution which covers all the agreed specified tasks and user objectives and has been tested thoroughly. Ensure relevant documentation is provided to support teams to reduce development support load. Where possible work to develop and implement a quality mechanism for the solution to analyse its own faults and provide reports prior to a critical failure. Develop the solution in a manner which supports modification for future developers thereby reducing the numbers of defects or negatively affecting system quality. Initiative and Innovation Implement improved processes that have a positive effect on the team's performance and company bottom line. Technical problems and opportunities are anticipated and dealt with immediately considering any technical dependencies. Take an active involvement in problem resolution and where necessary works after hours to ensure that problems are resolved. Shows foresight to prevent errors or delays in projects. Demonstrate initiative by understanding, acquiring and implementing new knowledge and skills both within team and to the wider group. Incorporates the new abilities into the day to day operational activities to improve performance of products and systems. Ensure techniques, technologies, tools and processes used are in line with industry best practices. Knowledge Share Identify team members requiring a specific knowledge, skill or understanding and seek ways to impart or upskill the team members through coaching and mentorship. Verify the knowledge has been imparted successfully and if not, take steps to rectify gaps in transfer of the knowledge. Coaching / Mentoring Provides guidance, training, and problem-solving assistance to other team members. Mentors and contributes to the growth of junior and intermediate team members. Designs and delivers end-user training and training materials. Living The Spirit Actively drives a culture of collaboration and open communication within the team. Actively promotes authenticity and drives the spirit of diversity, inclusion, equity and belonging within the team. Actively drives a culture of versatility and adaptability by modelling and encouraging team members to support each other not only within the department, but within BET Software as a whole. Actively become a change agent and drive continuous learning within the team thus ensuring that the team approaches all tasks or challenges with enthusiasm and proactivity. Qualifications Bachelor's degree in Computer Science, Engineering, or a related field. 8-10 years' experience in technical lead role. Experience in end-user report development. Proven ETL experience using SSIS. Hands-on experience in designing, prepping, configuring, installing, troubleshooting and maintaining complete BI Solutions. Identify and resolve data reporting issues. 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 optimization, 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 Data warehousing experience using fact tables, dimensions and indexing. Experience in Table partitioning and efficient data migration. Expert experience in creating and maintaining multidimensional cubes using SSAS. Relevant Management certification may be required. Excellent technical, diagnostic, and troubleshooting skills. Strong leadership and organizational abilities. Willingness to build professional relationships with staff and clients. Excellent communication, motivational, and interpersonal skills. #J-18808-Ljbffr