Business Intelligence Technical Lead (CPT) at BET Software

You Bring:

• Bachelor’s degree in Computer Science, Engineering, or a related field.
• 4 years’ experience in a senior/leadership role.
• Experience in end-user report development.
• A minimum of 7 years’ proven ETL experience, experience with MS Suite, SQL Server, Snowflake etc.
• Hands-on experience in designing, prepping, configuring, installing, troubleshooting and maintaining complete BI Solutions.
• Experience with big data sets and the ability to 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. (Advantageous)
• Excellent technical, diagnostic, and troubleshooting skills.
• Strong leadership and organizational abilities.
• Willingness to build professional relationships with Team Members and Stakeholders 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.
• Collaborate with developers, designers/analysts, and architects to make sure that the solutions meet application requirements and performance goals.
• Review checked-in code to ensure standards are met and the codebase remain sound.
• Ensure all technical solutions rolled out are compatible with other environments and dependencies; have high usability; are reliable to minimise downtime and perform efficiently during peak periods; and prioritise robust security (e.g., protection against third-party attacks, data privacy).
• Drive the adoption of processes that meet expectations for technical throughput, processing times, and efficient resource utilisation ensuring the system operates at maximum capacity when required.

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.