Junior Business Analyst at IIE MSA and IIE Varsity College

Duties and Responsibilities:

Sales Analysis & Reporting:

• Implement sales report for each campus and ensure consistency throughout each of them for reporting purposes.
• Compile and maintain current sales report and sales funnel reports on a weekly, monthly, and annual basis for year-on-year reference, reporting, and audit.
• Identify sales report that require greater efficiencies and build them accordingly.
• Implement sales dashboards based on KPI’s and metrics to assess campus and national performance against targets.
• Assist Senior Sales Analyst with detailed insight into conversation rates, priority splits, individual performance, and campus performance.
• Collaborate with sales management team to improve overall analysis and reporting.
• Work with campuses to outline sales performance against year-on-year and target year-to-date data with a detailed breakdown across various areas.
• Work with Senior Sales Analyst to conduct an annual competitor analysis to benchmark the business against the market from a quantitative and qualitative standpoint.
• Create ad-hoc sales reporting templates and dashboards as and when required.

Database Management:

• Work with campuses to maintain campus database on SIS and excel-based files, ensuring accurate, timeous and thorough practices in capturing data fields on data platforms used. 
• Use data management techniques to ensure accurate version management and minimal data loss.
• Leverage Power Query and ETL methodology to manage data in a manner that is efficient and effective for campus and national use.

Training & Support:

• Provide campuses and sales staff with training and support on a variety of reports and tools.
• Host regular training sessions with marketing assistants and campus sales managers to provide refreshers on best practices in terms of reporting.
• Assist new joiners within the sales team with report training and onboarding. In addition, provide them with a holistic view of all essential reports whereby they are directly involved.
• Follow a training script with new marketing assistants in terms of data capturing and reporting.
• Run comprehensive training on data integrity so all sales staff understand the process.

 Data Integrity & Security:

• Monitor accuracy of data across a variety of sales reports and address areas of concern.
• Run and manage quarterly data integrity audits with each campus to ensure they remain aligned to best practices and benchmarks.
• Engage on a weekly basis with campuses to understand their challenges around data integrity with a specific focus on CRM challenges and its impact on reporting.
• Maintain data quality standards based on pre-determined criteria set out by management.
• Identify and investigate data quality issues with campuses and provide workable solutions to resolve it.
• Use validation tools that can automate data integrity processes for enhanced efficiency and accuracy.
• Maintain records on the company’s secure platform to remain compliant with POPIA.
• Ensure that all sensitive data contained in reports and files are encrypted and password protected in line with AdvTech IT policies.

Competencies Required:

• Excellent attention to detail and high level of accuracy.
• Strong time management skills to manage and deliver on deadlines.
• Good communication and presentation skills.
• Confident to work independently and within a team.
• Great interpersonal skills and problem-solving abilities.

Technical Skills & Proficiencies:

Essential:

• Strong understanding of IM systems from a workflow and analytical view.
• Microsoft Excel skills at an advanced level – i.e. formulas, pivots, and data models.

Beneficial:

• Basic / intermediate understanding of Microsoft VBA – i.e. automation scripts and macros.
• Foundational understanding of building relational data models to provide in-depth analytical insight.
• Basic / intermediate understanding of Power Query – i.e. transforming and structuring large datasets with DAX.
• Basic / intermediate understanding of PowerBI – i.e. data visualizations.
• Excellent attention to detail and high level of accuracy.
• Strong time management skills to manage and deliver on deadlines.
• Good communication and presentation skills.
• Confident to work independently and within a team.
• Great interpersonal skills and problem-solving abilities.

Minimum Qualification Required:

• Bachelor’s Degree at NQF 7 in Business, Commerce, Marketing, Information Systems, or Computer Science.
• Postgraduate Degree at NQF 8 with a focus on Business, Commerce, Marketing, Information Systems, or Computer Science(advantageous).
• Professional Courses in the field of data analysis, business analysis, and information systems.(advantageous)

Minimum Work Experience Required:

• A minimum of 2-3 years professional work experience within the field of analytics and reporting.