Analytics Engineer / Data Analyst
AI summary
HerVest, a social enterprise focused on women's financial inclusion, is hiring a highly technical Analytics Engineer / Data Analyst in Lagos. The role centers on owning the Metabase BI layer, writing advanced SQL across PostgreSQL and MySQL, and building clean data models and dashboards. Salary is ₦200,000–₦300,000/month.
- Full-time role based in Lagos, Nigeria
- Salary range of ₦200,000 to ₦300,000 per month
- Primary owner of the Metabase BI instance and dashboards
- Requires 3+ years of advanced production-grade SQL experience
- Work involves PostgreSQL, MySQL, CTEs, window functions, and query optimization
AI job guide
Use this guide to check salary signals, requirements, documents, application steps and safety before you apply.
AI salary guide
Source salary availableThe source lists ₦200,000 - ₦300,000/month. Confirm the final pay, benefits, contract terms and allowances directly with the employer before accepting an offer.
Can you qualify for this role?
- Required3+ years of relevant experienceThe job post includes a minimum experience signal.
- PreferredPractical evidence in technology, Analytics Engineer, Data AnalystThe tags and summary point to skills connected with this role.
- RequiredAvailability to work in Not specifiedThe vacancy is associated with this location.
- UnclearComfort with the Full Time contract termsConfirm hours, duration, probation and benefits at the original source.
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, Analytics Engineer, Data Analyst, ideally with measurable outcomes or clear responsibilities.
- Follow the instructions from MyJobMag Nigeria; avoid sending documents to unofficial contacts or copied links.
- Confirm the deadline, interview location and employer contact before sharing personal documents.
Source and safety check
- MyJobMag 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, Analytics Engineer?
- 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
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.
Analytics Engineer / Data Analyst
Job Type: Full Time
Qualifications
BA/BSc/HND
Experience
3 years
Location: Lagos
Job Field: Data, Business Analysis and AI
Salary Range
₦200,000 - ₦300,000/month
The Role
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. 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.
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.
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.
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.
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.
Metabase Expertise:
Deep experience building dashboards, writing native SQL within Metabase, configuring variables, and managing Metabase environments.
Database Fundamentals:
A strong understanding of relational database architecture, foreign keys, normalization, and the performance implications of querying live replicas.
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.
Self-Starter:
You are comfortable working independently in a fast-paced environment and taking full ownership of the data visualization pipeline.
Nice-to-Haves
Experience with version control (Git) for managing SQL scripts alongside software engineering teams.
Familiarity with data transformation and orchestration tools like dbt (data build tool).
Experience extracting or working with data via Python (Pandas/FastAPI) or TypeScript.
Previous experience working in a fast-growing startup environment.
Check how your CV matches this job
Method of Application
- Interested and qualified candidates should forward their CV to:
- people@hervest.ng
- using the position as subject of email.
- Build your CV for free.
- Download in different templates.