Lead Analytics Engineer (RevOps & BI)
Revenue Operations
Nairobi HQ, Kenya
The Lead Analytics Engineer will -
• Own revenue, product, and operations data across ~12 sources
• Turn raw data into reliable, reusable canonical tables
• Keep dashboards accurate and up to date
• Run clear interdepartmental analytics request queue
• Automate data flows (SQL + Python); connect APIs (including Zoho Analytics)
• Build and maintain Python scripts via Jupyter/API to overcome platform limitations
• Deliver weekly insights for GTM efforts, with special attention to Marketing
• Own data validation program for CRM data
• Convert recurring ad-hoc insights into automated reporting
Responsibilities
Data Ownership
• Build and maintain canonical tables (single, trusted tables for core concepts like leads, applicants, clients, loans, partners)
• Define and enforce data contracts (clear rules: field names/types, valid values, refresh times)
• Track lineage (document every metric/table and its design)
• Build Python scripts via Jupyter/API to overcome Zoho Analytics limitations and push processed data back to Analytics
• Source new data opportunities beyond current ~12 sources; propose novel data capture methods
Dashboards and Reporting
• Ship BI assets (production-ready dashboards and scheduled reports that stakeholders actually use)
• Provide self-serve looks (safe, curated views so non-analysts can filter/pivot without SQL)
• Design dashboards for department heads and interdepartmental executive audiences
• Ensure dashboards serve real decision-making needs with strong usability
GTM Analytics
• Report on funnel and portfolio performance, based on marketing, operational, and customer data captured in CRM and across various platforms
• Build channel/campaign views for marketing efforts, industries, and various company pipelines, including their CAC, payback, LTV, and attribution
• Design lift studies (test vs. control) to estimate true incremental impact
• Support monthly market expansion with segment-specific dashboards and insights
• Run ticket queue with SLAs, project/task scoping, set ETAs, communicate changes
• Deliver weekly exec/GTM reports with clear recommendations and coverage across Marketing, Sales, Customer Ops, Risk/Compliance, Finance departments
SQL, Python, and Pipelines
• Write and tune SQL; build Python scripts
• Connect and troubleshoot APIs (including Zoho Analytics); set alerts and data quality tests; document runbooks
• Use dbt-style modeling and CI/CD: versioned SQL models, automatic tests on changes, and safe promotion to production
• Maintain automation inventory and progressively eliminate manual data workflows
Data Quality & Validation Program
• Design and implement monthly audit methodology for CRM loan data (including principal, markup, repayment schedules, default interest, discounts)
• Coordinate with CRM Ops Engineer and QA Engineer on validation process and remediation workflow
• Build automated verification checks for core analytics tables (nulls, negative values, outliers)
• Run weekly automated checks and document results
• Monitor data anomalies in CRM-sourced tables and alert CRM Ops Engineer to integrity issues via established pipeline
• Own the error reporting and remediation workflow
Strategic Growth & Automation
• Assess ad-hoc requests for recurring value
• Convert recurring insights into automated reporting (dashboards or weekly digest)
• Maintain automation inventory with improvement roadmap
• Present findings to stakeholders and institutionalize valuable recurring insights
Requirements
Required Technical Skills: 3+ years in analytics/BI/analytics engineering with GTM-facing teams – Advanced SQL (CTEs, window functions, query optimization, performance tuning) – Strong Python for data tasks (pandas, data processing, API connections) – Track record delivering production dashboards (Zoho Analytics experience strongly preferred) – Marketing analytics expertise: funnel modeling, attribution, CAC/LTV analysis, campaign performance – Hands-on with REST APIs and job orchestration (scheduling/managing data pipeline execution order) – Experience building data validation and quality assurance programs
Required Soft Skills: Self-starter mentality: identifies opportunities and proposes solutions proactively – Strategic, innovative thinker; sees beyond immediate requests to recurring value; proactive about delving into data to discover relevant insights – Strong stakeholder management; translates data into actionable business recommendations – Excellent written and verbal communication in English – Comfortable with ambiguity and expanding scope – Eager to own outcomes, not just complete tasks – Thinks big; in the habit of proposing novel approaches to data challenges
Preferred Experience: - Fintech/lending/B2B marketplace experience – Deep Zoho stack knowledge (CRM, Analytics, integration patterns) – dbt or similar frameworks (versioned SQL transformations with automated testing) – CI/CD for analytics – Experience with financial data validation in regulated environments – Background in QA methodologies or systematic testing
A vision for integrating AI.