Key Responsibilities
1. Database Development & Management
- Write and optimize SQL queries, stored procedures, and functions.
- Support database design, schema creation, and data modelling.
- Write and enhance database views for reporting and extraction purposes
2. Data Integrity & Accuracy
- Ensure accuracy, completeness, and reliability of data.
- Conduct data validation, cleansing, and reconciliation tasks.
- Ensure data confidentiality across all clients and systems
4. Reporting & Analysis
- Support creation of reports and dashboards for business users.
- Assist in extracting and transforming data for analysis.
- Produces scheduled and ad hoc reports within agreed turnaround times.
- Prioritizes requests effectively and manages competing deadlines.
5. Documentation & Compliance
- Maintain clear documentation for all database changes and scripts.
- Adhere to data security, privacy, and compliance standards.
6. Collaboration & Learning
- Work closely with software developers and data analysts.
- Demonstrate initiative in improving SQL skills and understanding of business data flows.
7. User & Engineering Support
· Engages with end users to clarify requirements and adjust report outputs.
· Assist engineers with SQL tasks in order to resolve complex support tickets
8. Learning & Professional Development
- Demonstrate growth in technical skills and understanding of the company’s tech stack.
- Stay up to date with new technologies and frameworks relevant to the role.
9.Quality & Delivery
- Deliver assigned tasks on time and according to specification
- Contribute to testing and quality assurance processes
ZA
