Corporate Staffing Services Trainer – Data Analysis Using Excel Jobs in Kenya

Corporate Staffing Services Trainer – Data Analysis Using Excel Jobs in Kenya



Our Client is a Training institution on digital programs. They are seeking to hire a Data Analysis Using Excel Trainer who will be conducting end-to-end Training, Mentorship and Work Linkages for Data Analysis Module.

Roles and Responsibilities

Mobilisation and Training

  • Mastering the Digital Content and Curriculum and planning lessons to Train Diverse Youth effectively.

  • Mobilizing through communities and other avenues to invite Youth to benefit from the free Training e.g. through pitches, activations or exhibitions of the Program.

  • Organizing and delivering quality Virtual Training and ensuring an 80% completion rate for registered Youth undertaking the Training.

  • Planning and Researching on Training scope accordingly and understanding the audience needs during Training.

  • Developing relatable examples and case study material for use to make training useful and exciting.

  • Assessing objectively, against pre-set criteria, the ability levels of the learners as appropriate.

  • Overseeing the learners in performing practical activities related to online work, advising and assisting where necessary, and ensuring that maximum learning benefit is gained from the practical experience.

  • Ensuring good attendance tracking and providing daily reports on each Training session by marking attendance as per reporting template.

  • Assess individual and group Training needs and provide recommendations.

  • Adapt delivery of course material to meet the needs of the learners

  • Conduct Training of Trainers (ToTs)

    Mentorship and Work Linkages

  • Conduct mentorship for each trained cohort as per the mentorship guidelines

  • Assess the level of skill acquisition of the mentees

  • Ensure active participation of all the mentees in the mentorship sessions

  • Submit weekly reports on the progress of each cohort being mentored.

  • Organize and coordinate job linkages webinars for the trainees

  • Link the trainees/mentees with work opportunities

  • Report on impact stories from the trainees
    Technical skills required

  • Bachelor’s Degree or Diploma in any relevant field.

  • 2+ years of working experience using Excel in Data Analysis.

  • Advanced knowledge of Excel functions and formulas: Being able to use advanced formulas
    and functions like VLOOKUP, HLOOKUP, INDEX, MATCH, SUMIF, COUNTIF, etc., is crucial for data analysis in Excel.

  • Pivot tables and charts: Knowing how to create and manipulate pivot tables and charts to summarize, analyze, and visualize data.

  • Data cleaning and manipulation: Cleaning, transforming, and manipulating raw data to make it ready for analysis. This includes skills like data filtering, sorting, and formatting.

  • Statistical analysis: Knowledge of basic statistical concepts and how to apply them using Excel functions, like mean, median, standard deviation, correlation, regression, and hypothesis testing.

  • Macros and VBA: The ability to write and use macros and VBA (Visual Basic for Applications) code to automate repetitive tasks, manipulate data, and create custom functions and add-ins.

  • Data visualization: The ability to create visually appealing charts, graphs, and dashboards to present data insights in a compelling and easy-to-understand way.

  • Database management: Familiarity with database concepts like data modelling, querying, and management, and being able to work with external data sources in Excel.

  • Data mining and modelling: Ability to use advanced Excel tools like Solver, Forecasting, and What-If Analysis, to create predictive models and optimize business decisions based on data.

  • Understand the utilization of Excel Data Analysis skills in online work and possess the ability to train youths on the avenues of selling Excel Data Analysis skills with a focus on earning a decent income from digital opportunities and platforms.

    How to Apply

    For more information and job application details, see; Corporate Staffing Services Trainer – Data Analysis Using Excel Jobs in Kenya

    Find jobs in Kenya. Jobs - Kenya jobs. Search our career portal & find the latest Kenyan job positions, career opportunities & jobs in Kenya.

    Jobs in Kenya - banking jobs, IT jobs, accounting jobs, NGO jobs, business administration, ICT, UN jobs, procurement jobs, education jobs, hospital jobs, human resources jobs, engineering, teaching jobs, and other careers in Kenya.

    Find your dream job from 1000s of vacancies in Kenya posted and updated daily - click here!

  • Click here to post comments

    Join in and write your own page! It's easy to do. How? Simply click here to return to 3 Best Africa Jobs.