Data Analyst
Job Overview.
We are seeking a Data Analyst with strong technical skills and a deep interest in using data to drive decisions, to join our team and help transform data into actionable insights that support decision-making across the organization. This role is suited for someone who is skilled in working with structured data using SQL and Python, and who has experience working in cloud environments such as Azure or AWS.
The ideal candidate has a strong analytical mindset, is detail-oriented, and can communicate findings clearly to both technical and non-technical stakeholders. This is a technical, hands-on role, not a data science position.
Why Join Us.
- Work with a collaborative, data-driven team
- Opportunity to make a tangible impact on business outcomes
- Flexible work environment with opportunities for growth
- Work with cutting-edge tools and a modern cloud data stack
Key Responsibilities
- Write complex SQL queries to extract, clean, and transform large datasets using SQL and Python.
- Develop and maintain dashboards and reports for business users using BI tools such as Power BI or Tableau.
- Conduct exploratory data analysis to identify trends, patterns, and outliers.
- Collaborate with business and technical teams to gather data requirements and deliver insights.
- Construct ERDs, DFDs and any other relevant artefacts, in conjunction with the Data and Solution Architects, to best represent the environment.
- Work with cloud-based data platforms (Azure or AWS) to source and manage datasets.
- Ensure data quality, consistency, and integrity in all analytics outputs.
- Construct test cases and conduct testing on all outputs.
- Document data sources, processes, and analysis logic to ensure reproducibility and transparency.
Required Skills & Qualifications
- 7+ years of experience as a Data Analyst in a data-rich environment. Beneficial if this is in insurance, finance, or regulated industries.
- Advanced proficiency in SQL for querying and manipulating large datasets.
- Solid experience with Python for data wrangling, analysis, and automation (e.g., using pandas, numpy, matplotlib, seaborn).
- Hands-on experience working with Azure (e.g., Azure Data Lake, Synapse, SQL Database) or AWS (e.g., S3, Redshift, Athena).
- Familiarity with BI tools such as Power BI or Tableau.
- Strong grasp of modern data concepts (data lakes, CI/CD, warehouse layers) I copied this from somewhere.
- Strong analytical mindset with attention to data accuracy and business relevance.
- Excellent written and verbal communication skills, with the ability to explain technical findings to non-technical stakeholders.
Nice to have:
- Experience with data pipeline tools (e.g., Airflow, dbt, Azure Data Factory).
- Knowledge of version control (e.g., Git).
- Background in business analysis, finance, or operations.
- Exposure to regulatory reporting or compliance requirements.
- Experience in data quality management, meta-data management and master data management.
Job Category: Data Analyst
Job Type: Full Time
Job Location: Cape Town Johannesburg