Intelligence Match
Match: ??%
Unlock Your Personalized Match
Sign in to see your exact score breakdown and personalized insights.
Team Tagline
About the role
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 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.
Required Skills
Preferred Skills
Similar Skills not Listed
Responsibilities
- Own the BI Layer: Serve as the primary administrator for our Metabase instance. 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. 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, 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.
analytics Market Intelligence Beta
Based on similar roles
Salary ranges vary based on experience, location, and the specific requirements of the role. For the most accurate information, please discuss compensation directly with the employer during the interview process.
Job Application Safety Disclaimer
Your security and privacy are our top priorities. Please be aware that InStreamIQ will never ask you to pay any fees for job applications, placements, or training as a condition of employment.
Furthermore, legitimate employers will not ask for sensitive personal identification such as your Bank Verification Number (BVN), National Identification Number (NIN), or Passport details during the initial application phase. Do not share financial information or make any payments to individuals or organizations claiming to represent an employer. If you encounter any suspicious requests, please report the listing immediately via our support channels.