Data Analyst

NwRealite ltd is a real estate company based out of Kenya.

Data Analyst (Probation → Contract/Permanent)

Type: Full-time (6-month internship)
Remuneration (Stipend): KES 20,000/month for the first 6 months. Upon successful performance, the contract may be extended or converted to permanent with a revised salary.

Role Summary

We’re hiring an experienced Data Analyst to turn messy, real-world data into clear, decision-ready insights. You’ll clean and validate data, write robust SQL for relational datasets, build intuitive dashboards (Power BI or equivalent), and use Python to develop predictive and explanatory models that drive business outcomes.

Key Responsibilities

• Data Cleaning & QA: Identify and resolve obvious data issues, outliers, duplicates, and inconsistencies; maintain data dictionaries.
• SQL & Data Manipulation: Write efficient queries, joins, aggregations, and transformations; prepare analysis-ready tables/views.
• BI & Visualization: Build interactive dashboards (Power BI or similar), define KPIs, write DAX/measures, and automate refresh schedules.
• Analytics & Modelling (Python): Use pandas/scikit-learn (or equivalent) for feature engineering, modelling, and evaluation; communicate findings clearly.
• Stakeholder Communication: Translate data insights into business recommendations; present to both technical and non-technical teams.
• Documentation: Keep queries, models, and dashboards well-documented and reproducible (version control is a plus).

Required Skills & Experience

• Proven data cleaning skills and a sharp eye for “obvious” data issues.
• Strong SQL for relational databases (joins, unions, string concatenation, window functions is a plus).
• Power BI (or equivalent like Tableau/Looker Studio): data modelling, DAX/measures, visuals, and publishing.
• Python for data analysis/modelling (pandas, numpy, scikit-learn, basic stats).
• Solid understanding of data modelling concepts, KPIs, and BI best practices.
• Excellent communication and documentation habits.

Nice to Have

• Advanced Excel (pivot tables, Power Query).
• Git/version control; task tracking (Jira/Trello/Excel).
• Experience with MySQL/PostgreSQL and basic ETL.