Compensation for this role is set at a competitive annual salary of $85,000 to $110,000, contingent upon qualifications and experience. The position offers a comprehensive benefits package, including health, dental, and vision insurance, as well as a 401(k) retirement plan with company matching. Additional perks include paid time off, professional development opportunities, and flexible work arrangements where feasible.
A gross monthly salary ranging from KES 80,000 to KES 100,000 is offered for this position.
Position Summary
The Data Analyst will gather, evaluate, and interpret business data to provide insights that inform management decisions. This position will collaborate with Operations, Finance, Sales, Procurement, Supply Chain, Production, and HR departments to enhance reporting precision, streamline operational workflows, and drive overall business performance.
Key responsibilities involve overseeing project execution, ensuring alignment with organizational objectives, and managing cross-functional teams to achieve predetermined milestones. The role demands a proactive approach to problem-solving, meticulous attention to detail, and the ability to prioritize tasks effectively in a fast-paced environment. Additionally, the position requires strong communication skills to facilitate collaboration among stakeholders, stakeholders, and external partners while maintaining transparency throughout the process.
Gather, refine, sanitize, and interpret substantial datasets to extract meaningful insights for business decision-making.
Design, construct, and oversee dynamic dashboards, reports, and key performance indicators (KPIs) for management to facilitate data-driven decision-making.
Examine operational, sales, production, inventory, and financial data to identify insights and trends.
Compile regular management reports on a daily, weekly, monthly, and as-needed basis to support informed decision-making and operational oversight.
Analyze data to uncover emerging trends, pinpoint inefficiencies, and evaluate opportunities to enhance operational processes.
Collaborate on the development and execution of budgeting, forecasting, and strategic planning efforts to drive organizational growth and efficiency.
Enhance operational efficiency and precision by developing automated systems for generating reports.
Oversee and maintain the accuracy and reliability of data throughout all integrated systems to ensure consistent data quality and integrity.
Collaborate with department heads to identify reporting needs and deliver tailored analytical solutions.
Deliver findings and proposed solutions to management with clarity and brevity.
Engage in internal audit functions by conducting comprehensive data analysis and generating detailed exception reports to identify and address discrepancies.
Design and implement performance monitoring utilities and analytical dashboards to generate business intelligence reports.
Seeking individuals with a Bachelor’s degree in Computer Science or a related field, coupled with a minimum of five years of hands-on experience in software development, including proficiency in multiple programming languages such as Java, Python, or C++. Strong problem-solving skills and a proven track record in designing and implementing scalable systems are essential. Ability to work collaboratively in cross-functional teams, lead project initiatives, and deliver high-quality solutions within tight deadlines is required. Excellent communication skills, both written and verbal, to articulate technical concepts to non-technical stakeholders are also necessary. Familiarity with Agile methodologies and cloud platforms like AWS or Azure is a definite advantage.
A Bachelor’s Degree in fields such as 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 a Data Analyst, Business Analyst, or comparable analytical position.
Proficient in handling extensive datasets and generating comprehensive business reports.
Candidates with prior involvement in agriculture, manufacturing, export, logistics, or supply chain sectors will receive additional consideration.
Proven expertise in a variety of critical technical competencies is required for this position. Candidates must demonstrate proficiency in key areas, including [insert specific skills], with a strong emphasis on [insert specific skill]. Additionally, applicants should possess [insert years] of hands-on experience in [relevant field] and a demonstrated ability to [specific task or responsibility]. Familiarity with [specific tool, framework, or industry standard] is also expected.
Proficiency in Microsoft Excel is a non-negotiable requirement for this role.
Advanced proficiency in Microsoft Excel, encompassing sophisticated functionalities such as pivot tables, LOOKUP/LOOKUP, advanced charting, data validation, and macro development via VBA, is essential. Candidates must demonstrate expertise in building dynamic dashboards, performing complex data analysis, and creating automated reports to streamline workflows. Strong familiarity with Excel’s Power Query, Power Pivot, and Power BI integration is highly desirable.
Construct and manipulate pivot tables to analyze and summarize complex datasets, enabling data-driven decision-making across various departments. Proficiency in Excel or Google Sheets is essential, with a strong understanding of data structures, aggregation functions, and filtering techniques. Responsible for creating dynamic reports that highlight key trends, identify discrepancies, and support strategic initiatives. Collaborate with cross-functional teams to gather requirements, validate data accuracy, and ensure alignment with organizational goals. Capable of translating raw data into clear, actionable insights for stakeholders at all levels.
Power Query serves as the backbone for data extraction, transformation, and loading (ETL) processes, enabling efficient integration of information from diverse sources. This tool is essential for professionals tasked with consolidating, cleaning, and structuring data to support informed decision-making. Candidates must possess a strong proficiency in Power Query, particularly in automating workflows and resolving complex data challenges. Responsibilities include designing and maintaining queries, optimizing performance, and ensuring data accuracy across interconnected systems. Collaboration with cross-functional teams is often required to align data solutions with business objectives.
Proficient in utilizing LOOKUP and LOOKUP functions within spreadsheet applications is essential. These tools enable the efficient retrieval and cross-referencing of data across multiple datasets, ensuring accuracy and streamlining analytical processes.
Utilizing advanced lookup functions, develop dynamic data retrieval solutions by integrating INDEX and MATCH methodologies to efficiently extract precise information from extensive datasets, ensuring accuracy and adaptability in varying analytical contexts.
Develops sophisticated spreadsheet formulas to analyze intricate data sets and automate complex calculations, ensuring accuracy and efficiency in financial modeling, forecasting, and reporting tasks.
Responsible for ensuring the accuracy, integrity, and consistency of data through thorough verification and validation processes, this role involves meticulously reviewing datasets to identify discrepancies, errors, or inconsistencies. The position requires a keen attention to detail, strong analytical skills, and proficiency in data validation tools or software. Key duties include cross-referencing data sources, validating input against predefined rules or standards, and reporting findings to relevant stakeholders to facilitate corrective actions. Collaboration with teams such as IT, operations, or quality assurance may be necessary to resolve issues and maintain high data quality standards. Familiarity with data validation methodologies and experience with database management systems are essential for success in this role.
Design and construct dynamic, data-driven dashboards that deliver clear, actionable insights through intuitive visualizations and interactive elements. Utilize advanced tools and technologies to aggregate, process, and present complex datasets in a user-friendly format. Collaborate with stakeholders to identify key performance indicators and translate business requirements into functional dashboard solutions. Implement robust data validation and security measures to ensure accuracy, reliability, and compliance with organizational standards. Troubleshoot technical issues, optimize performance, and maintain dashboards to align with evolving data needs and user expectations.
Data analysis and reporting involve collecting, processing, and interpreting data to generate meaningful insights and support informed decision-making. This role requires proficiency in data manipulation tools, statistical analysis, and visualization techniques to transform raw data into actionable reports. Responsibilities include identifying trends, creating dashboards, and ensuring data accuracy and integrity. Strong analytical skills, attention to detail, and the ability to communicate findings clearly to stakeholders are essential. Experience with programming languages such as Python or R, as well as tools like SQL, Excel, and Power BI is typically required.
Demonstrates expertise in Power BI or comparable data visualization platforms.
Proficient in SQL and database management systems, with hands-on experience in designing, querying, and optimizing databases to ensure efficient data retrieval and storage.
Demonstrates exceptional proficiency in analytical thinking and effective problem resolution.
Demonstrates exceptional precision and meticulousness in all tasks performed.
Excellent verbal and written communication abilities, along with the capacity to deliver compelling presentations, are essential for this role.
Proven capacity to operate autonomously while consistently adhering to established deadlines and deliverables.
Paragraph:
This position offers a competitive compensation package along with a comprehensive benefits program designed to support both professional and personal well-being. Benefits include health, dental, and vision insurance, retirement savings plans with employer contributions, paid time off, and flexible spending accounts. Additionally, eligible employees may receive performance-based bonuses, professional development opportunities, and other wellness incentives. The company prioritizes work-life balance and strives to provide a robust total rewards package that aligns with individual and organizational success.
The monthly gross salary for this position ranges from KES 80,000 to KES 100,000.
As the provider of inpatient medical coverage, you will ensure financial protection up to KES 1,000,000 for all eligible hospital admissions. This benefit applies to necessary medical treatments received during inpatient stays, including surgeries, emergency care, and specialist consultations as outlined in the policy terms. Your role involves verifying coverage limits, coordinating with healthcare facilities, and guiding policyholders through the claims process to ensure seamless access to high-quality medical care within the specified financial parameters.
Daily meals are included as part of the employment package to support your well-being throughout the workday.
We provide a monthly allocation for airtime expenses, ensuring employees have the necessary communication resources. This allowance supports essential connectivity needs for both professional and personal use, as outlined in our benefits package. Eligibility for this benefit requires active employment status and compliance with company policies regarding expense reimbursement. Employees must submit receipts or documentation to validate their airtime usage, adhering to the established reimbursement process. The allowance amount is determined based on role-specific requirements and company guidelines.
The organization provides avenues for professional advancement and skill enhancement, fostering an environment conducive to long-term career progression. Employees are encouraged to pursue continuous learning and development, with structured programs designed to support their growth trajectory within the company. These initiatives aim to empower staff to expand their expertise, take on new challenges, and achieve their long-term professional aspirations.
Interested candidates are invited to submit their updated CV to monik@keitt.co.ke, with a copy to the designated recipient. The email subject line should explicitly state: “Application for Data Analyst Position.”
Qualifications
BA/BSc/HND
Experience Required
5 years
