Analytics Engineer / Data Analyst
HerVest · Lagos
Job description
About the role
HerVest, a social enterprise providing financial inclusion for women through a Gender Lens Investment approach, is looking for a highly technical Analytics Engineer / Data Analyst who lives and breathes SQL and loves building intuitive data experiences. The role bridges the gap between the raw database architecture and the business intelligence layer: writing optimized queries, modeling data and owning the Metabase instance end to end.
Key responsibilities
- Serve as the primary administrator of the Metabase instance, building dashboards, configuring native SQL queries into reusable Metabase models and setting up field filters for non-technical users.
- Write complex, performant SQL (CTEs, window functions, JSONB extraction) in PostgreSQL and MySQL to turn raw application data into clean reporting tables.
- Use EXPLAIN ANALYZE to find bottlenecks, suggest indexing strategies and write queries that do not lock up production environments.
- Act as the link between the software engineering team and business stakeholders, mapping new tables and exposing data in Metabase after each feature release.
- Manage SSO, user permissions and data dictionaries so the right people have secure access to the right data.
Required profile
- 3+ years of experience writing advanced, production-grade SQL.
- Deep experience building dashboards, writing native SQL in Metabase and managing Metabase environments.
- Strong understanding of relational database architecture, foreign keys, normalization and the performance implications of querying live replicas.
- Ability to turn a vague business question into accurate visualizations, and comfort working independently in a fast-paced environment.
Nice-to-haves
- Version control (Git) for SQL scripts alongside software engineers.
- Familiarity with dbt and with Python (Pandas/FastAPI) or TypeScript.
- Previous experience in a fast-growing startup.
Salary: N200,000 - N300,000 per month. Applications close on 10 October 2026; candidates send their CV by email to the company's HR contact, naming the position in the subject line.
Questions fréquentes
Why are you reporting this job?
Explore further
Salaries, guides and searches in Nigeria.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
By continuing, you accept our terms of use.
Already have an account? Login
A question about this job?
Ask it here: you will get the full job summary by e-mail, right away.
Published 3 hours ago
Expires 6 days from now
4 views · 0 interested
Boost your chances
Upload your CV — we will match you with relevant openings.
Analyzing your CV...
HerVest
Lagos
Related job offers
-
Senior Product Manager - Banking
FairMoney Lagos -
Core Banking Technical Project Manager
NETFUSION IDEAL & INNOVATIONS SOLUTIONS LIMITED Lagos -
Backend Developer (.NET)
Choice Talents LTD Lagos -
Ingénieur Fiabilité Site (SRE) – Cloud AWS – Télétravail
Ebiyone Global Nigeria Limited Remote -
Programmeur·euse compétitif·ve – Benchmarks IA (Remote)
Vettedlance