Compensation will be provided in accordance with the role’s requirements and market standards, reflecting the candidate’s qualifications and experience level.
Gross remuneration for this position ranges from KES 80,000 to KES 100,000 per month.
Position Summary
The Data Analyst will gather, evaluate, and translate business data to inform strategic management decisions, ensuring actionable insights are derived from complex datasets. This position will collaborate extensively with Operations, Finance, Sales, Procurement, Supply Chain, Production, and HR teams to enhance reporting precision, streamline operational processes, and drive measurable improvements in overall business performance.
Oversee and execute core responsibilities including the development and implementation of strategic initiatives, ensuring alignment with organizational objectives. Facilitate cross-functional collaboration to streamline processes and enhance productivity. Monitor performance metrics to identify areas for improvement and drive data-driven decision-making. Provide leadership and guidance to team members, fostering a culture of accountability and continuous development. Maintain compliance with industry regulations and internal policies while upholding the highest standards of professionalism and ethics. Serve as a primary point of contact for stakeholders, addressing inquiries and resolving issues in a timely and effective manner.
Gather, refine, verify, and interpret substantial datasets to extract meaningful business insights.
Design and oversee the creation and upkeep of dynamic dashboards, comprehensive reports, and critical management KPIs to ensure accurate data visualization and strategic decision-making support.
Evaluate operational, sales, production, inventory, and financial data to identify trends, insights, and opportunities for improvement.
Compile regular management reports, including daily, weekly, and monthly updates, as well as ad-hoc analyses as requested.
Analyze data to uncover emerging trends, pinpoint inefficiencies, and assess opportunities for enhancing operational processes.
Collaborate on the development, monitoring, and refinement of budgets, financial forecasts, and long-term strategic plans to drive organizational growth and efficiency.
Develop and implement automated solutions to streamline reporting workflows, enhancing both efficiency and precision.
Oversee the consistency and reliability of data throughout various systems by actively monitoring its quality and integrity.
Collaborate with department heads to discern their reporting needs and deliver tailored analytical solutions.
You will effectively communicate findings and recommendations to management, ensuring clarity and conciseness in your presentation.
Facilitate internal audit processes by conducting thorough data analysis and generating detailed exception reports.
Create performance monitoring tools and business intelligence reports to analyze and present data effectively.
Bachelor’s degree in Computer Science, Engineering, or a related field is required, along with a minimum of five years of experience in software development. Proficiency in programming languages such as Java, Python, or C++ is essential, along with experience with databases and cloud services. Strong problem-solving skills and the ability to work collaboratively in a team environment are also necessary. Familiarity with Agile methodologies and experience in full-stack development are highly desirable. Excellent communication skills and a passion for continuous learning are key attributes for this role.
A Bachelor’s degree in Data Analysis, Statistics, Data Science, Mathematics, Computer Science, Information Systems, or a closely related discipline is required.
Seeking candidates with a minimum of five years of hands-on experience in a Data Analyst, Business Analyst, or comparable analytical position.
Proven expertise in handling extensive datasets and generating comprehensive business reports.
Proficiency in agriculture, manufacturing, export, logistics, or supply chain operations is highly beneficial.
We require proficiency in specific technical and professional skills as essential prerequisites for this role. Candidates must demonstrate expertise in [list mandatory skills, e.g., project management, data analysis, or software proficiency], along with strong communication abilities to collaborate effectively within a team environment. A thorough understanding of [relevant industry standards, tools, or methodologies] is also necessary to ensure seamless integration and performance. Additionally, applicants should possess [any required certifications or qualifications] to meet the position’s foundational criteria.
Proficiency in Microsoft Excel is an essential requirement for this role.
Advanced proficiency in Microsoft Excel is required, encompassing a comprehensive skill set that includes but is not limited to complex data analysis, pivot tables, advanced formulas, and macros. Familiarity with Excel’s advanced features, such as Power Query, Power Pivot, and VBA scripting, is highly desirable. Candidates should demonstrate the ability to manage large datasets efficiently, create dynamic reports, and automate repetitive tasks to enhance productivity and accuracy.
Proficiency in Pivot Tables is essential, enabling data summarization and dynamic analysis through customizable groupings and calculations. Candidates should possess the ability to transform large datasets into actionable insights by leveraging filtering, sorting, and aggregation features. Experience with Excel or Google Sheets is required, along with a solid understanding of data relationships and structures. Responsibilities include creating and maintaining Pivot Tables to support reporting needs, ensuring accuracy, and optimizing performance for efficiency. Familiarity with advanced functions, such as calculated fields, slicers, and timelines, is a valuable asset. Strong analytical and problem-solving skills are necessary to interpret trends and present findings effectively.
Experts in Power Query are tasked with extracting, transforming, and loading data efficiently to support business intelligence and reporting initiatives. Proficiency in Power Query is essential for developing robust data models, automating data workflows, and ensuring data accuracy and consistency across systems. This role involves collaborating with cross-functional teams to understand data requirements, designing and implementing data transformation processes, and optimizing query performance. Candidates must demonstrate a strong understanding of data structures, query optimization techniques, and Power Query’s integration with other Microsoft tools such as Power BI and Excel. Familiarity with M language, error handling, and best practices for data governance is also required.
Proficient in utilizing LOOKUP and LOOKUP functions to efficiently retrieve and cross-reference data across multiple spreadsheets or databases, ensuring accuracy and minimizing manual errors in reporting and analysis.
INDEX MATCH is a powerful function combination used in spreadsheet applications to retrieve data from a specific location within a table or dataset. It operates by first locating the desired row or column using the MATCH function, which identifies the position of a specified value, and then extracting the corresponding data using the INDEX function based on that position. This method offers greater flexibility than LOOKUP or LOOKUP, as it can perform both vertical and horizontal lookups without requiring a fixed reference column.
Utilizes sophisticated formulas to perform complex calculations, data analysis, and automate workflows within various software applications. Requires proficiency in spreadsheet tools, particularly advanced Excel functions, as well as experience with data validation and error-checking techniques. Responsibilities include designing intricate models, applying conditional logic, and generating insightful reports to support decision-making processes. Must demonstrate strong analytical skills, attention to detail, and the ability to troubleshoot formula-related issues efficiently. Familiarity with VBA or other scripting languages is a plus for optimizing and extending functionality.
Data validation ensures the accuracy, consistency, and reliability of information by systematically reviewing and verifying collected or processed data. This process involves checking for errors, completeness, and adherence to predefined standards or rules to maintain high-quality datasets. Key responsibilities include identifying discrepancies, validating data integrity, and ensuring compliance with organizational policies or regulatory requirements. Professionals in this role may employ automated tools, manual checks, or a combination of both to perform validation tasks efficiently and accurately. Strong attention to detail, analytical skills, and proficiency in data validation techniques are essential for success in this position.
Develop interactive dashboards to visualize and analyze data, ensuring they meet user requirements and business objectives. Design, build, and maintain dashboards using industry-standard tools and technologies, such as Tableau, Power BI, or similar platforms. Collaborate with stakeholders to understand their data visualization needs and translate them into functional, user-friendly interfaces. Ensure dashboards are optimized for performance, accessibility, and responsiveness across different devices and screen sizes. Implement best practices for data security, governance, and compliance to protect sensitive information. Monitor dashboard usage and performance, gathering feedback to identify areas for improvement and implementing enhancements as needed. Stay updated with emerging trends and advancements in dashboard development to deliver innovative solutions.
We are seeking a skilled professional to oversee data analysis and reporting functions, ensuring accurate collection, processing, and interpretation of data to drive informed decision-making. The ideal candidate will possess expertise in data visualization tools, statistical analysis, and database management, alongside strong analytical and problem-solving abilities. Responsibilities include generating comprehensive reports, identifying trends, and presenting actionable insights to stakeholders. Proficiency in tools such as SQL, Excel, or Power BI is required, along with a minimum of three years of relevant experience in a data-focused role. Excellent communication skills are essential to convey complex findings clearly to non-technical audiences.
Demonstrated expertise in data visualization tools, specifically Power BI, or equivalent platforms, is essential.
Proficiency in SQL and database management systems is required.
Demonstrated proficiency in analytical reasoning and the ability to effectively resolve complex issues.
Demonstrates a keen eye for detail and a commitment to delivering precise and error-free work.
Exceptional ability to articulate ideas clearly and engage audiences through compelling presentations.
Demonstrates strong self-management skills and consistently delivers work within established deadlines.
We provide a comprehensive compensation and benefits package designed to support your professional growth and personal well-being. Our offerings include competitive salaries, performance-based bonuses, and a range of health and wellness benefits. Eligible employees may also receive retirement savings plans, paid time off, and other valuable perks. Additionally, we offer flexible work arrangements, professional development opportunities, and employee assistance programs to foster a balanced and rewarding work experience.
A monthly gross salary ranging between KES 80,000 and KES 100,000 is offered for this position.
Providing comprehensive inpatient medical coverage valued at KES 1,000,000 ensures financial protection against significant healthcare expenses incurred during hospitalizations. This benefit extends to a wide range of medical treatments, procedures, and accommodations deemed medically necessary, offering peace of mind during unforeseen health challenges.
Lunchtime meals are included as part of the benefits package.
Monthly allocations for airtime are provided, ensuring the employee can effectively manage communication expenses and remain connected for work-related purposes. This allowance is intended to cover costs associated with business calls, mobile data usage, and other necessary telecommunications services. The specific amount granted may vary based on job role, location, and company policy. Employees are expected to utilize this benefit responsibly and adhere to any relevant expense reporting guidelines.
Professional growth and career development prospects represent key components of this role, offering avenues for continuous learning, skill enhancement, and long-term advancement.
Interested applicants are encouraged to submit their most current curriculum vitae to monik@keitt.co.ke, with a carbon copy to the same address. The subject line of the email should clearly indicate the position being applied for, specifically: “Application for Data Analyst Position.”
Qualifications
BA/BSc/HND
Experience Required
5 years
