Avenews is a trusted partner providing fast and reliable financing solutions for Kenyan agribusinesses. We are seeking a Lead Analytics Engineer to drive our RevOps and Business Intelligence initiatives. This role is pivotal in bridging the gap between raw data and business strategy, focusing on data infrastructure, high data quality, and delivering actionable insights to stakeholders across the company. You will be responsible for building trusted data models, designing advanced dashboards, and automating data workflows to support our growth and operational efficiency.
Key Responsibilities
Data Ownership
- Build and maintain canonical tables providing a single source of truth for core concepts such as leads, applicants, clients, loans, and partners.
- Define and enforce data contracts, establishing clear rules for field names, types, valid values, and refresh times.
- Track and document data lineage for every metric and table design.
- Build Python scripts via Jupyter/API to overcome platform limitations and push processed data back to analytics tools.
- Identify and source new data opportunities and propose novel data capture methods beyond current sources.
Dashboards and Reporting
- Ship production-ready BI assets and scheduled reports that provide actual value to stakeholders.
- Provide curated, self-serve data views for non-analysts to filter and pivot data without needing SQL knowledge.
- Design high-impact dashboards for department heads and executive audiences with a strong focus on usability.
- Ensure dashboards serve real decision-making needs across the organization.
GTM (Go-To-Market) Analytics
- Report on funnel and portfolio performance using marketing, operational, and customer data captured across various platforms.
- Build channel and campaign views to track CAC, payback period, LTV, and attribution for various industry pipelines.
- Design lift studies (test vs. control) to estimate true incremental impact.
- Support monthly market expansion with segment-specific dashboards and insights.
- Manage a ticket queue with defined SLAs, scoping projects, and communicating changes effectively.
SQL, Python, and Pipelines
- Write and tune complex SQL queries and develop Python scripts for data processing tasks.
- Connect and troubleshoot REST APIs; set alerts and data quality tests; document runbooks.
- Implement dbt-style modeling and CI/CD practices including versioned SQL models and automated testing.
- Maintain an automation inventory and progressively eliminate manual data workflows.
Data Quality & Validation
- Design and implement monthly audit methodologies for CRM loan data (principal, markup, repayment schedules, etc.).
- Coordinate with CRM Ops and QA Engineers on validation processes and remediation workflows.
- Build automated verification checks for core analytics tables to identify nulls, outliers, and anomalies.
- Own the error reporting and remediation workflow.
Strategic Growth & Automation
- Assess ad-hoc requests for recurring value and convert them into automated reporting solutions.
- Maintain an automation inventory with a clear improvement roadmap.
- Present findings to stakeholders and institutionalize valuable recurring insights.
Requirements and Qualifications
- Education: BA/BSc/HND degree in a relevant field.
- Experience: At least 3 years of experience in analytics, BI, or analytics engineering, specifically working with GTM-facing (Go-To-Market) teams.
- SQL Proficiency: Advanced SQL skills (CTEs, window functions, query optimization, and performance tuning).
- Python Skills: Strong Python skills for data tasks, including pandas, data processing, and API connections.
- BI Tools: Proven track record of delivering production-grade dashboards; experience with Zoho Analytics is strongly preferred.
- Domain Expertise: Marketing analytics expertise including funnel modeling, attribution, and CAC/LTV analysis.
- Technical Operations: Hands-on experience with REST APIs and job orchestration (scheduling/managing pipeline execution).
- Data Quality: Experience building data validation and quality assurance programs.
.png){kind=logo}