Senior BI and Data Solutions Architect

AVI Limited; Wes-Kaap; On-site; USD 50,000 - 85,000; Full time

Job summary

AVI Limited is seeking a Senior BI and Data Solutions Architect for its IT Shared Services Division. This role involves defining architecture, guiding development, and mentoring a BI team to build a scalable BI landscape. Candidates must have extensive experience in BI solutions, strong problem-solving skills, and relevant certifications. Join a team dedicated to driving innovation and efficiency in industry-leading brands.

Qualifications

• 8-10 years’ experience in Information Technology in the BI area.
• Solid 6 years as a BI developer.
• Experience with SQL stored procedures and relational/multidimensional databases.

Responsibilities

• Architect and maintain enterprise-wide BI and data warehouse solutions.
• Lead best practices for data integration and visualization.
• Mentor BI developers and ensure adherence to SDLC standards.

Skills

Data acquisition (ETL)

Problem solving

Effective communication

Teamwork

Customer service oriented

Governance and rule following

Results focused

Education

Bachelor’s degree in Management Information Systems

Professional Microsoft certification

Tools

SSIS

SSAS

SSRS

SQL Server

Power Pivot

Excel 2013 Power View

Job description

GROW A GREAT CAREER WITH THE COMPANY THAT GROWS GREAT BRANDS!

At our company, we believe in collaboration and innovation to drive exceptional results. Our Shared Services departments—spanning IT, Finance, HR, Logistics, Digital, Marketing, and Field Marketing—are essential to the growth of our industry-leading brands. We foster a high-performance culture where teamwork, accountability, and creative problem-solving are celebrated.

Our AVI IT Shared Services Division is the backbone of AVI’s operational efficiency. As a proud SAP house, we utilise world-class ERP solutions to streamline operations and ensure seamless integration of technology across our businesses. The team is dedicated to maintaining robust systems and infrastructure, driving automation, improving processes, and safeguarding cybersecurity. By leveraging SAP and other cutting-edge tools, IT empowers our teams to work smarter, innovate, and deliver exceptional results.

Why Join Our Shared Services Team?

• Drive Growth: Support and contribute to the success of our industry-leading brands.
• Collaborative Culture: Thrive in a team-oriented environment that values accountability and innovation.
• Impact & Growth: Play a key role in our brands' success while advancing your career in a supportive setting.
• Shape the Future: Make a meaningful difference and help us shape the future of our business.

Your Next Career Move Starts Here! Join our AVI IT Shared Services Divisioneither at our offices in Bryanston, Johannesburg or at the Waterfront, Cape Town as a Senior BI and Data Solutions Architect and play a key role as a key technical leader; shaping the future of analytics at AVI — defining architecture, guiding development, and mentoring a high-performing BI team. You will report to the Business Analytics Manager, working across IT and business teams to build a scalable, robust BI landscape that delivers actionable insights.

Reporting Structure:

• Reports to: Business Analytics Manager
• Direct Reports: None

Key Areas of Impact:

• Architect and maintain enterprise-wide BI and data warehouse solutions
• Lead the adoption of best practices for data integration, visualization, and governance
• Deliver and optimize dashboards, reports, and mobile BI solutions
• Mentor BI developers and ensure adherence to SDLC standards
• Collaborate across teams to enable self-service analytics and elevate data literacy

What It Takes to Succeed:

Experience that set you up for success:

• 8-10 years’ experience in Information Technologyin the Business Intelligence area.
• Solid 6 years as a BI developer designing and building reports, dashboards, scorecards, self-service BI, and mobile solutions
  • Experience working on data warehouse projects
  • Experience working with BI tool architectures, functions, and features
  • Data acquisition (ETL)
  • Testing/quality assurance
• Microsoft certification with experience in the full stack of Microsoft Business Intelligence stack Microsoft stack: SSIS, SSAS, SSRS, SQL Server, Power Pivot, and Excel 2013 Power View).
• Experience working with SQL stored procedures, and relational/multidimensional databases

Qualifications & Certifications that will contribute to your success:

• Bachelor’s degree in Management Information Systems, Computer Science, or related degree is required.
• Professional Microsoft certification with experience in the full stack of Microsoft Business Intelligence stack Microsoft stack: SSIS, SSAS, SSRS, SQL Server, Power Pivot, and Excel 2013 Power View).

Additional Requirements that will enhance your impact for success:

• Applying and developing technical/functional skills
• Problem solving
• Effective communication
• Working with others / teamwork
• Customer service oriented
• Governance and rule following
• Results focused

Take the Next Step with Us!

At the heart of our AVI Shared Services Divisions is a commitment to excellence, collaboration, and continuous improvement. Here, you’ll have the opportunity to work with talented professionals across multiple disciplines, allowing you to grow professionally. If you are passionate about making an impact, solving complex problems, and collaborating with others to drive excellence, this is the place for you.