Analytics Engineer / Data Analyst
AI summary
HerVest, a social enterprise focused on financial inclusion for women, is hiring an Analytics Engineer / Data Analyst in Lagos. The role involves owning the Metabase BI layer, writing advanced SQL across PostgreSQL and MySQL, building dashboards, optimizing queries, and partnering with engineering and business teams to translate data models into business metrics.
- Own the Metabase BI instance and build dashboards for non-technical users
- Write advanced SQL with CTEs, window functions, and JSONB extraction
- 3+ years of production-grade SQL experience required
- Work at a mission-driven fintech focused on women's financial inclusion
AI job guide
Use this guide to check salary signals, requirements, documents, application steps and safety before you apply.
AI salary guide
Not enough public dataNot enough public salary data is available for this exact role. Before applying, prepare to ask about gross pay, benefits, contract length, probation period, transport and any allowances.
Can you qualify for this role?
- Required3+ years of relevant experienceThe job post includes a minimum experience signal.
- PreferredPractical evidence in technology, Data Analytics, Business IntelligenceThe tags and summary point to skills connected with this role.
- RequiredAvailability to work in Not specifiedThe vacancy is associated with this location.
Documents to prepare
- Likely requiredUpdated CV
- Role specificCover letter or short employer message
- OptionalProfessional references
- VerifyID or passport only after verifying the employer
Application tips for this job
- Place your strongest Analytics Engineer / Data Analyst evidence in the first half of your CV.
- In your cover letter or employer message, connect your experience to HerVest and the role in Not specified.
- Add concrete examples related to technology, Data Analytics, Business Intelligence, ideally with measurable outcomes or clear responsibilities.
- Follow the instructions from Jobzilla Nigeria; avoid sending documents to unofficial contacts or copied links.
- Confirm the deadline, interview location and employer contact before sharing personal documents.
- Prepare a polite question about pay, benefits and contract terms for later interview stages.
Source and safety check
- Jobzilla Nigeria
- Original source link available
- Application method is clear
- Deadline not specified
- No major risk signal was detected in the captured text.
Never pay for interviews, shortlisting, medical checks, uniforms, or job placement. Confirm every application at the original source before sharing personal documents. Report suspicious listing.
Interview preparation
- What experience makes you a strong fit for this Analytics Engineer / Data Analyst role in technology, Data Analytics?
- How have you handled responsibilities similar to those in this job post?
- Are you available to work in Not specified under the listed contract or schedule?
- Prepare examples with clear responsibilities, tools used and measurable outcomes.
- Review the source and research HerVest before the interview.
Ask what the first priorities will be in the role and how success will be measured.
Similar jobs to consider
Use AI to apply better
After confirming the original source, use Career Assistant to check role fit, tailor your CV and prepare a cover letter or employer message.
Original source description
Analytics Engineer / Data Analyst at HerVest
⏲
Sep 28, 2026, 12:08 PM
⋕
View all Banking & Financial Services jobs
HerVest is a social enterprise providing financial inclusion for women through a Gender Lens Investment (GLI) approach. We are committed to improving women’s lives through greater access to and use of financial services.
We are recruiting to fill the position below:
Job Title: Analytics Engineer / Data Analyst
Location: Lagos
The Role
You won't just be dragging and dropping charts; you will be writing raw, optimized queries across PostgreSQL and MySQL, modeling data, and owning our Metabase instance from top to bottom.
We are looking for a highly technical Analytics Engineer / Data Analyst who lives and breathes SQL and loves building intuitive data experiences. In this role, you will bridge the gap between our raw database architecture and our business intelligence layer.
If you love writing clean CTEs, optimizing query execution, and translating software engineering data models into business metrics, we want you on our team.
What You’ll Do
Own the BI Layer: Serve as the primary administrator for our Metabase instance. You will build comprehensive dashboards, configure native SQL queries into reusable Metabase Models, and set up field filters for non-technical users.
Cross-Functional Partnership: Act as the translation layer between our software engineering team and business stakeholders. When engineering ships a new feature, you will be right there to map the new tables and expose the data in Metabase.
Advanced Data Modeling: Write complex, performant SQL (CTEs, Window Functions, JSONB extraction) in PostgreSQL and MySQL to transform raw application data into clean reporting tables.
Query Optimization: Ensure our databases stay fast and healthy. You will use EXPLAIN ANALYZE to identify bottlenecks, suggest indexing strategies, and write queries that don't lock up production environments.
Data Governance: Manage SSO, user permissions, and data dictionaries to ensure the right people have access to the right data securely.
What We’re Looking For
SQL Mastery: 3+ years of experience writing advanced, production-grade SQL. You must be highly proficient in both PostgreSQL and MySQL dialects.
Self-Starter: You are comfortable working independently in a fast-paced environment and taking full ownership of the data visualization pipeline.
Database Fundamentals: A strong understanding of relational database architecture, foreign keys, normalization, and the performance implications of querying live replicas.
Metabase Expertise: Deep experience building dashboards, writing native SQL within Metabase, configuring variables, and managing Metabase environments.
Analytical Mindset: The ability to take a vague business question (e.g., "What is our month-over-month active user retention?"), find the right tables, and visualize the answer accurately.
Nice-to-Haves
Previous experience working in a fast-growing startup environment.
Familiarity with data transformation and orchestration tools like dbt (data build tool).
Experience with version control (Git) for managing SQL scripts alongside software engineering teams.
Experience extracting or working with data via Python (Pandas/FastAPI) or TypeScript.
Salary Range
N200,000 - N300,000 / Month.
How to Apply
Interested and qualified candidates should forward their CV to:
people@hervest.ng
using the position as the subject of the email.
Application Deadline:
10th October, 2026.
View all Jobs in Nigeria
Lagos State