Business Intelligence Technical Lead

Betsoftware; Pretoria; On-site; ZAR 800 000 - 1 200 000; Full time

Job summary

A leading software company based in Pretoria seeks an experienced Technical Lead with 8-10 years in the field. Responsibilities include driving team performance, providing technical guidance, and ensuring software quality. Ideal candidates possess a degree in Computer Science or related fields and expertise in SSIS/SSAS. A strong focus on mentoring teammates and improving processes is essential. This role offers an engaging work environment and opportunities for professional growth.

Qualifications

• 8-10 years' experience in a technical lead role.
• Proven ETL experience using SSIS.
• Advanced experience in T-SQL query optimization.

Responsibilities

• Provide technical leadership and collaborate with team members.
• Ensure rigorous testing of solutions before deployment.
• Mentor and train junior team members.

Skills

Technical leadership

Troubleshooting

Communication skills

T-SQL optimization

Data warehousing

Mentoring

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSAS

Job description

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.