
Data Analyst
- Cape Town, Western Cape
- Permanent
- Full-time
- Analyse the stakeholder reporting requirements from a data and functional perspective
- Identify, analyse and interpret trends in data sets and provide actionable insights
- Investigate and resolve data issues by identifying issues and liaising effectively with appropriate business and tech teams
- Build and maintain dashboards and reports using data visualisation packages.
- Transform, load and ensure smooth integration of the data into our standard database structure
- Aggregate or consolidate data while maintaining quality assurance of data output to stakeholders
- Monitor production runs to ensure accuracy and on-time delivery of reports
- Adjust, maintain and configure existing ETL processes to ensure efficient data flow within the data warehouse
- Engage in regular interaction with internal stakeholders to ensure that they're being kept up-to-date with respect to data insights
- Ask questions or escalate issues when necessary to find solutions where appropriate
- Co-ordinate and produce bespoke data sets tailored for specific business needs
- Process, cleanse, and verify the integrity of data used for analysis
- Collaborate with Data Scientists, Analytics Engineers and Data Engineers on several projects
- BSc degree or similar field (or equivalent)
- Demonstrated work experience in data analysis and reporting within financial services or the fintech space
- Strong SQL skills (3+ years experience) - required to write and debug SQL, experience with functions, stored procedures, tables, views, etc.
- 2+ years of Python experience. Particularly data-related packages such as Pandas and Numpy.
- Experience building business dashboards
- Understanding of version control tools like Git and Github.
- Experience with DBT and Snowflake is a bonus.
- Excellent understanding of databases, data structures and concepts
- Experience with Agile methodologies