Business Intelligence Technical Lead

**We Want You**:
If your superpower is combing through data and making recommendations to optimise and improve business processes, you’re our missing link As a BI Technical Lead who is highly skilled in systems architecture, data structures and data sources, you will work in close collaboration with the BI Team Lead to plan, design, lead, and execute technical solutions and improvements.

**You Bring**:

- Bachelor’s degree in Computer Science, Engineering, or a related field.
- 8-10 years’ experience in a 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 organisational abilities.
- Willingness to build professional relationships with staff and clients.
- Excellent communication, motivational, and interpersonal skills.

**What You’ll Do**:
**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.
- 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 downtime and perform at maximum efficiency during peak periods of usage; consider security at its highest level (third party attacks, data protection etc.).
- Drive the adoption of processes within the Team, which consider and meet the expectations of technical throughput rates and responses; processing times; effective resource utilisation 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 with 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 number 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.
- Ensure technical problems and opportunities are anticipated and dealt with immediately considering any technical dependencies.
- Take an active involvement in problem resolution and, where necessary, work after hours to ensure that problems are resolved.
- Show foresight to prevent errors or delays in projects.
- 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.

**Knowledge Share**
- Identify Team Members requiring specific knowledge, skill or understanding and seek ways to upskill these Team Members through coaching and mentorship.
- Verify that the knowledge has been imparted successfully and if not, take steps to rectify gaps in knowledge share.

**The Company We Keep**:
At BET Software, we don't just recruit talent, we cultivate it. Our learning and development programmes, our various opportunities for growth, and our well-deserved incentives are what keep our All-Star Team the best amongst the rest.