P(
Data Analyst
Psybergate (Pty) Ltd
Knysna · On-site Contract Senior 6d ago
About the role
About Psybergate
Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.
Role Overview
We are looking for a Data Analyst to join our financial services client in Sandton on a 12-month contract role.
Responsibilities
- Perform deep-dive analysis across diverse datasets to identify trends, anomalies, and business opportunities
- Translate business and project requirements into actionable data solutions and insights
- Manage and deliver multiple ad hoc reporting requests with accuracy and relevance
- Design and maintain scalable data models to support analytics and reporting
- Understand and manage end-to-end data flows, from source systems to reporting layers
- Develop and optimise data pipelines and integrations using modern development practices
- Work with enterprise databases including IBM DB2, Oracle, Netezza, and SQL Server to extract, transform, and analyse data
- Collaborate with stakeholders to define technical specifications and reporting frameworks
- Create dashboards and reports using Power BI and advanced MS Excel techniques
- Support AI/ML initiatives by preparing data and contributing to model development and deployment
- Apply strong analytical thinking to solve complex business problems and generate insights
- Document data logic, methodologies, and findings for both technical and non-technical audiences
- Manage workload independently, ensuring timely delivery of high-quality outputs
- Communicate insights and technical concepts clearly to business stakeholders
Requirements
- Relevant degree in Computer Science, Data Science, Engineering, or a related field
- 8+ years' experience in data analytics, software development, and systems architecture
- Strong proficiency in SQL, Python, and/or R
- Extensive experience working with enterprise databases (DB2, Oracle, Netezza, SQL Server)
- Solid understanding of data modelling, ETL processes, and system design principles
- Experience working with cloud platforms such as Azure, AWS, or GCP
- Familiarity with AI/ML concepts, model lifecycle, and data preparation
- Advanced skills in MS Excel (pivot tables, formulas, macros)
- Experience with Power BI for data visualisation and reporting
- Exposure to tools such as Tableau or similar is advantageous
- Strong analytical and problem-solving skills
- Ability to work independently and manage multiple priorities
- Excellent communication skills with the ability to bridge technical and business teams
Desired Skills
- AI / ML Data Preparation
- SQL
- Python Development
- Data Analysis
- Database Management
- Cloud Platforms
Application Note
Please note if you do not hear from us within 3 weeks, please consider your application unsuccessful.
Follow for the Latest Vacancies
Join Psybergate Careers Channel here: Psybergate Careers
Requirements
- Relevant degree in Computer Science, Data Science, Engineering, or a related field
- Strong proficiency in SQL, Python, and/or R
- Extensive experience working with enterprise databases (DB2, Oracle, Netezza, SQL Server)
- Solid understanding of data modelling, ETL processes, and system design principles
- Experience working with cloud platforms such as Azure, AWS, or GCP
- Familiarity with AI/ML concepts, model lifecycle, and data preparation
- Advanced skills in MS Excel (pivot tables, formulas, macros)
- Experience with Power BI for data visualisation and reporting
- Strong analytical and problem-solving skills
- Ability to work independently and manage multiple priorities
- Excellent communication skills with the ability to bridge technical and business teams
Responsibilities
- Perform deep-dive analysis across diverse datasets to identify trends, anomalies, and business opportunities
- Translate business and project requirements into actionable data solutions and insights
- Manage and deliver multiple ad hoc reporting requests with accuracy and relevance
- Design and maintain scalable data models to support analytics and reporting
- Understand and manage end-to-end data flows, from source systems to reporting layers
- Develop and optimise data pipelines and integrations using modern development practices
- Work with enterprise databases including IBM DB2, Oracle, Netezza, and SQL Server to extract, transform, and analyse data
- Collaborate with stakeholders to define technical specifications and reporting frameworks
- Create dashboards and reports using Power BI and advanced MS Excel techniques
- Support AI/ML initiatives by preparing data and contributing to model development and deployment
- Apply strong analytical thinking to solve complex business problems and generate insights
- Document data logic, methodologies, and findings for both technical and non-technical audiences
- Manage workload independently, ensuring timely delivery of high-quality outputs
- Communicate insights and technical concepts clearly to business stakeholders
Skills
AWSAzureDB2GCPIBM DB2MS ExcelNetezzaOraclePower BIPythonRSQLSQL ServerTableau
Don't send a generic resume
Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.
Get started free