Senior Data & AI Analytics Specialist

rag-talent; Cape Town; Hybrid; ZAR 900,000 - 1,300,000; Full time

Benefits offered by this job

Group risk benefits (Life & Gap Cover)

Flexible remote/hybrid work options

Professional development and work-life

Job summary

rag-talent is seeking a Senior Data Analytics Engineer to bridge traditional BI with AI-driven automation in a fintech context. You will design automated AI workflows, write complex SQL queries and Python scripts for data transformation, and craft interactive dashboards for cross-functional teams.

The role emphasizes prompt engineering, RAG architectures, and API-driven automation, with hybrid remote work options and a strong focus on accuracy, efficiency, and business impact.

Qualifications

• Degree or higher in a quantitative field (data science, CS, finance, etc).
• 5+ years in data analytics/BI or similar roles.
• Experience with AI agents, LLM integrations, or automated workflows.
• Strong SQL (PostgreSQL) and Python for data transformation and analysis.
• Proficiency with Power Query/Power Pivot and data modelling.
• Experience with Docker, APIs, and GitHub workflows.
• Excellent English and Afrikaans communication.

Responsibilities

• Construct, deploy, and manage automated AI workflows and LLM integrations to enhance operational efficiency.
• Design, execute, and optimise PostgreSQL SQL queries and Python scripts for data transformation.
• Build, maintain, and refine interactive BI dashboards and reporting solutions for cross-functional stakeholders.
• Develop prompt engineering strategies, agent frameworks, and RAG architectures with evaluation protocols.
• Perform advanced data modeling and analytics with Power Query/Power Pivot.
• Configure and maintain integration components using containerisation, APIs, and version control.

Skills

Data analysis

Analytical thinking

Communication

Education

Bachelor’s degree or higher in Data Science, Computer Science, Business Analysis, Finance, or related field

Tools

SQL (PostgreSQL)

Python

Power Query

Power Pivot

Docker

GitHub

APIs

BI tools

Job description

This role merges core business analytics with artificial intelligence architecture to transform raw organisational data into actionable operational insights. Situated within a collaborative fintech environment, the position involves designing automated AI workflows, developing interactive dashboard reports, and running complex database queries. The key focus is bridging traditional business intelligence and modern LLM-driven automation to enhance overall performance and efficiency. Working hours are full-time, standard business hours (37.5 to 40 hours per week), with flexibility tailored around output and core deliverables.

Key Responsibilities

• Construct, deploy, and manage automated AI workflows and LLM integrations to enhance operational efficiency.
• Design, execute, and optimise complex SQL database queries (specifically PostgreSQL) and Python scripts for data transformation and analysis.
• Build, maintain, and refine interactive business intelligence dashboards and reporting solutions for cross-functional stakeholders.
• Develop prompt engineering strategies, agent frameworks, and Retrieval-Augmented Generation (RAG) architectures while applying model evaluation protocols.
• Perform advanced data modeling, data manipulation, and analytics utilising Microsoft Excel features such as Power Query and Power Pivot.
• Configure and maintain integration components, relying on containerisation tools, version control platforms, and API-driven automation systems.

Requirements

• Bachelor’s degree or higher in Data Science, Computer Science, Business Analysis, Finance, or a related quantitative field.
• Minimum of 5 years of professional experience in a Data Analyst, Business Intelligence, or data-centric analytical role.
• Hands-on experience developing or implementing solutions with AI agents, LLM integrations, or automated workflow systems.
• Strong technical command of SQL (PostgreSQL) and Python for data transformation, scripting, and analytics.
• Practical understanding of prompt engineering techniques, agent frameworks, RAG architectures, and evaluation standards.
• Proven background in utilising data visualisation/BI tools alongside advanced Excel capabilities (Power Query, Power Pivot, data modeling).
• Operational experience with web APIs, automation engines, Docker containerisation, and GitHub workflow management.
• Strong analytical, problem‑solving, and organisational skills with strict attention to detail.
• High proficiency in professional written and spoken English and Afrikaans.

Preferred Qualifications

• Prior experience operating within the Fintech or Software‑as‑a‑Service (SaaS) industries.
• Exposure to the South African financial services or financial planning landscape.
• Proficiency in Afrikaans.

Required Software Skills

• SQL (PostgreSQL)
• Python
• Advanced Excel (Power Query, Power Pivot)
• Make Docker
• GitHub
• Data Visualisation / BI Tools

Benefits

• Group risk benefits including Life Cover and Gap Cover.

Flexible working hours with remote and hybrid arrangement options centered on measurable outcomes.

Supportive, inclusive team culture prioritising professional development and healthy work-life balance.