Compensation: The role offers a competitive salary commensurate with experience and qualifications, along with comprehensive benefits including health, dental, and vision insurance, retirement savings plans, paid time off, and professional development opportunities.
Compensation for this role ranges from KES 80,000 to KES 100,000 gross per month.
Position Summary
The Data Analyst will gather, evaluate, and interpret business data to provide actionable insights that guide managerial decision-making. This position will collaborate extensively with Operations, Finance, Sales, Procurement, Supply Chain, Production, and HR departments to enhance reporting precision, streamline operational processes, and drive overall business performance.
Key duties involve overseeing daily operations to ensure smooth workflow, monitoring performance metrics, and identifying opportunities for efficiency gains. Responsibilities include managing a team of professionals, delegating tasks based on individual strengths, and fostering a collaborative work environment. Additional tasks encompass budget tracking, reporting on financial performance, and ensuring compliance with company policies and industry regulations. The role requires strong leadership abilities, exceptional problem-solving skills, and a commitment to delivering high-quality results.
Gather, refine, and verify extensive business data sets, then conduct thorough analytical assessments to extract meaningful insights.
Create and sustain dynamic dashboards, detailed reports, and key performance indicators for executive leadership to facilitate data-driven decision-making and strategic planning.
Examine operational, sales, production, inventory, and financial data to identify trends, assess performance, and support strategic decision-making processes.
Compiles daily, weekly, monthly, and custom management reports as required by stakeholders.
Analyze data to pinpoint emerging trends, assess inefficiencies, and uncover opportunities for streamlining processes and enhancing productivity.
Assist in the development and execution of budgeting, forecasting, and long-term strategic planning efforts to drive organizational decision-making and financial performance.
Transform and streamline reporting workflows to enhance operational efficiency and ensure precision in data output.
Ensure the accuracy and reliability of data throughout all systems by actively monitoring its quality and integrity.
Collaborate closely with department leaders to identify reporting needs and deliver data-driven analytical solutions.
Deliver findings and recommendations to management in a clear, concise format for informed decision-making.
Facilitate internal audit processes by conducting comprehensive data analysis and generating detailed exception reports to identify discrepancies and areas of concern.
Design and implement performance monitoring systems alongside business intelligence reporting solutions.
Seeking a candidate with a Bachelor’s degree in a relevant field, along with at least three years of hands-on experience in a comparable role. Proficiency in industry-standard software and tools is essential, along with strong analytical, problem-solving, and communication abilities. The ideal applicant will demonstrate a track record of delivering results, collaborating effectively in team settings, and adapting to evolving challenges. Additional certifications or specialized training are advantageous but not mandatory.
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 at least five years of professional experience in data analysis, business analysis, or closely related analytical positions.
Proficiency in managing extensive datasets and generating comprehensive business reports is essential.
Candidates with a background in agriculture, manufacturing, export, logistics, or supply chain industries will be given preference.
Seeking candidates with a robust command of essential technical competencies, including proficiency in [specific technical skills, e.g., Python, SQL, AWS], exceptional analytical capabilities, and strong problem-solving acumen. Applicants must demonstrate expertise in [relevant methodologies or tools, e.g., machine learning, data visualization, Agile development] and possess at least [X years] of hands-on experience in [specific industry or field]. The ideal candidate will exhibit meticulous attention to detail, a collaborative mindset, and the ability to thrive in fast-paced environments. Proficiency in [additional required skills, e.g., project management, stakeholder communication] is highly desirable, along with a track record of delivering high-quality solutions under tight deadlines. A commitment to continuous learning and adaptability to evolving technologies is essential for success in this role.
Proficiency in Microsoft Excel is a prerequisite for this role.
Advanced proficiency in Microsoft Excel, encompassing a comprehensive grasp of intricate functions, data analysis tools, and advanced charting capabilities. Demonstrated expertise in utilizing pivot tables, LOOKUP, LOOKUP, INDEX-MATCH, and other complex formulas to efficiently manage, manipulate, and analyze large datasets. Strong capability in automating repetitive tasks through macros and VBA (Visual Basic for Applications) to enhance productivity and accuracy. Familiarity with Power Query for data transformation and Power Pivot for advanced data modeling and business intelligence applications. Additionally, adept at creating dynamic dashboards, implementing data validation, and ensuring data integrity through error-checking and auditing techniques.
Crafting Pivot Tables involves organizing, summarizing, and analyzing large datasets to extract meaningful insights and present them in an easily digestible format. This role requires proficiency in spreadsheet software, particularly Microsoft Excel, alongside a keen eye for detail to identify trends, patterns, or anomalies within the data. Responsibilities include designing and constructing Pivot Tables, applying appropriate filters and calculations, and ensuring the accuracy and clarity of the generated reports. Strong analytical skills and the ability to interpret data effectively are essential, as is the capacity to communicate findings in a clear and concise manner to stakeholders. Familiarity with additional tools or software that complement data analysis tasks may also be beneficial.
Power Query is utilized to streamline the extraction, transformation, and loading (ETL) of data from multiple sources into Power BI or Excel, ensuring efficient data integration. Proficiency in Power Query is essential for developing and refining data models, with a strong emphasis on optimizing queries for performance and scalability. Candidates must demonstrate hands-on experience in cleaning, reshaping, and merging datasets while adhering to best practices for data governance and quality. The role requires the ability to troubleshoot complex data issues, automate repetitive data preparation tasks, and collaborate with cross-functional teams to deliver accurate, actionable insights. Familiarity with M language, advanced Power Query functions, and integration with other data tools is highly advantageous.
As a proficient user of LOOKUP and LOOKUP functions, you will leverage these powerful Excel tools to efficiently retrieve and analyze data from extensive datasets. Your expertise will involve accurately matching and cross-referencing information across different sheets or workbooks, ensuring data integrity and precision. The role demands a strong command of these functions to streamline data retrieval processes, enhance analytical capabilities, and support informed decision-making. Additionally, you will maintain meticulous attention to detail to prevent errors and optimize the performance of data-driven tasks.
The role requires proficiency in using the INDEX and MATCH functions in Excel to efficiently retrieve and analyze data, ensuring accuracy and adaptability in dynamic datasets. Candidates must demonstrate a strong grasp of these functions to cross-reference information across multiple sheets or workbooks, enabling precise data extraction. The position involves creating and maintaining complex formulas that integrate INDEX and MATCH to streamline reporting and decision-making processes. Additionally, the ability to troubleshoot errors and optimize formulas for performance is essential to support data-driven operations.
Crafts sophisticated, dynamic spreadsheets leveraging intricate functions and data validation techniques to ensure precision and efficiency in complex calculations and data management tasks.
We are seeking a meticulous professional to ensure the accuracy and integrity of our data through rigorous validation processes. The successful candidate will systematically review datasets to identify discrepancies, inconsistencies, or errors, and take corrective action as needed. Proficiency in data validation tools and techniques, along with strong analytical skills, is essential. Familiarity with industry-specific standards and compliance requirements is preferred. This role demands meticulous attention to detail, the ability to work efficiently under tight deadlines, and effective communication to report findings and suggest improvements. The position involves collaborating with cross-functional teams to enhance data quality and reliability across the organization.
Design and build interactive, user-friendly dashboards tailored to business requirements, ensuring data visualization is both intuitive and insightful. Utilize advanced tools such as Power BI, Tableau, or similar platforms to transform raw data into meaningful metrics and trends. Collaborate with stakeholders to identify key performance indicators (KPIs) and align dashboard functionality with strategic objectives. Maintain data integrity through rigorous validation and cleansing processes, while optimizing performance for swift, seamless user interactions. Stay current with emerging trends in data visualization and business intelligence to continuously enhance dashboard capabilities.
We compile and interpret data to generate detailed reports, providing actionable insights that drive strategic decision-making. This role involves collecting quantitative and qualitative information, analyzing trends, and presenting findings through clear visualizations and summaries. Proficiency in statistical tools, data visualization software, and advanced Excel is required, along with strong analytical and problem-solving skills. Collaborating with cross-functional teams, we ensure data accuracy and support business objectives through evidence-based recommendations.
Demonstrated expertise in Power BI or comparable data visualization platforms is required.
Proficiency in SQL and database administration is required.
Demonstrated proficiency in analytical thinking and the ability to resolve complex issues efficiently.
Demonstrates a high level of precision and meticulousness in all tasks performed.
Exceptional interpersonal and public speaking abilities are essential.
Demonstrates strong self-management skills and consistently delivers work within established timeframes.
We are pleased to offer a comprehensive compensation and benefits package designed to recognize and reward your contributions. Eligible employees will receive a competitive salary commensurate with experience and market standards, along with performance-based bonuses to incentivize excellence. Our benefits include comprehensive health, dental, and vision insurance, retirement savings plans with company matching contributions, generous paid time off, and flexible work arrangements. Additional perks may include professional development opportunities, wellness programs, and employee assistance resources to support both personal and professional growth.
A monthly gross salary ranging from KES 80,000 to KES 100,000 is offered for this position.
We provide comprehensive inpatient medical coverage with a limit of KES 1,000,000. This benefit ensures financial protection for medical expenses incurred during hospital stays.
Lunch is served daily at no additional cost.
Monthly allocation of airtime credit is provided to facilitate communication needs. Employees are required to utilize this benefit exclusively for professional purposes. The allocated amount varies based on role and tenure, with additional allowances granted for senior positions or extended service. Employees must track usage meticulously and submit monthly reports in adherence to company policies. Excessive or unauthorized use may result in disciplinary action. This benefit is subject to periodic review and may be adjusted at management’s discretion.
Professional growth and career advancement prospects are integral aspects of the role.
Prospective applicants are encouraged to submit their most recent curriculum vitae to monik@keitt.co.ke, with a copy directed to the specified address, ensuring the subject line clearly indicates the application is for the Data Analyst Position.
Qualifications
BA/BSc/HND
Experience Required
5 years
