Senior Data Analyst
Executive Placements · Stellenbosch, Western Cape
Stop applying one at a time.
JobAlertsZA auto-applies to South African jobs like this one for you, overnight. Upload your CV once — we do the applying.
Start free — we apply for you →Key Responsibilities: • Data Architecture & Documentation: • Analyse and document SQL Server data structures, flows, and relationships. • Maintain a data dictionary and catalogue for technical and business users. • Identify gaps, redundancies, and risks in the data model.
- Business Analysis & Reporting:
- Partner with Finance and Operations to translate reporting needs into data solutions.
- Write and optimise SQL queries for extraction, aggregation, and validation.
- Build and improve Excel-based dashboards and reports.
- Perform ad hoc analysis to support decision-making.
- Database Improvement & Data Modelling:
- Propose structural and performance improvements to SQL Server databases.
- Design new normalised data models aligned with business requirements.
- Collaborate with data engineering on schema changes.
- Testing & Quality Assurance:
- Develop and execute test plans for database updates.
- Validate data integrity before and after deployments.
- Contribute to ongoing data quality checks and monitoring routines.
- User Enablement & SQL Support:
- Coach business users in SQL and self-service analytics.
- Act as the first point of contact for Finance and other stakeholders.
- Champion good data practices across the organisation.
Job Experience and Skills Required
- Degree in a quantitative field (Information Systems, Computer Science, Mathematics or Statistics).
- 810 years in a Data Analyst, Business Analyst, or similar role.
- Strong T-SQL skillscomplex queries, joins, aggregations, and window functions.
- Hands-on experience with SQL Server.
- Experience documenting data architecture, models, or data dictionaries.
- Skilled in building and maintaining Excel-based dashboards and reports.
Apply now!
.special-hidden { display: none; }