Analytics Engineer

Role Overview

We are seeking a highly capable Analytics Engineer to own and evolve the analytics foundation that supports decision-making across Credit, Marketing, Product, and Finance within a regulated fintech environment.

This role sits at the intersection of Data Engineering and Commercial Analytics, with primary responsibility for building analytics-ready data models, maintaining trusted business metrics, and ensuring high-quality, governed datasets.

Using modern tools such as Snowflake and dbt Cloud, you will enable stakeholders to self-serve insights with confidence, consistency, and speed.

Why This Role Matters

In this role, you will:

• Establish a single, trusted source of truth for business, credit, and financial metrics
• Build scalable, analytics-ready data models for BI and advanced analytics
• Enable reliable self-service reporting across the organisation
• Support regulated reporting through strong governance and documentation

Key Responsibilities

1. Analytics Modelling & Transformation

• Design, build, and maintain fact and dimension tables using dimensional modelling best practices
• Develop transformation logic in dbt Cloud to curate analytics datasets
• Write high-quality, performance-optimised SQL in Snowflake
• Define data grain, business rules, and historical logic
• Apply version control, testing, and deployment best practices
• Collaborate with Data Engineering to modernise ELT processes

2. Data Quality & Governance

• Own the definition and reconciliation of business KPIs
• Ensure accuracy and compliance of financial and operational metrics
• Implement data quality tests (freshness, volume, relationships, business rules)
• Support regulated reporting requirements
• Maintain clear documentation for models and metrics

3. Collaboration & Enablement

• Partner with engineers to optimise pipelines and warehouse performance
• Work closely with BI developers, analysts, and data scientists
• Resolve data issues impacting reporting and compliance
• Contribute to end-to-end data product delivery

4. Innovation & Continuous Improvement

• Improve scalability, performance, and usability of analytics models
• Promote best practices in analytics engineering and documentation
• Support the development of long-term analytics architecture standards

Qualifications & Experience

Education

• Bachelor’s degree in Computer Science, Data Analytics, Engineering, Mathematics, or a related field

Technical Skills

• Advanced SQL and large-scale data modelling experience
• Strong hands-on experience with Snowflake
• Proficiency in dbt Cloud (transformations, testing, documentation)
• Experience enabling BI tools (Power BI, Tableau, Looker)
• Understanding of ELT architectures
• Experience with Git-based version control and CI/CD (e.g., GitLab)
• Exposure to AWS-based data platforms and pipelines

Work Arrangement: Hybrid (3 days in office)
Office Location: Gardens, Cape Town
Salary Range: R60,000 – R70,000 Basic (CTC), plus benefits