Data Analyst

Data Analyst

Cape Town (Fully remote is possible)

A Fintech technology company has a new role available for skilled Data Analyst to join their Team. The organisation builds and offers various products and services from for small and medium enterprises from instant access to funding to all-in-one business banking accounts and cutting-edge financial analysis tools.

The company strives to support SME’s in building their business and hope to find individuals who want to make a difference. As a company our Values are focused around Collaboration, commitment, being curious, connected and compassionate.

Overall Purpose

We are looking for a confident Data Analyst to join our team. This role calls for an inquisitive and discerning individual with a true passion for data.

As a member of the Data Science team, your primary focus will be to extract valuable insights from data, and create visualisations and reports for internal stakeholders, with a heavy focus on data quality and governance. You will not only enable enhanced business performance through data-driven insights, but also help us make smarter decisions to deliver even better products.

Responsibilities:

• Analyse the stakeholder reporting requirements from a data and functional perspective
• Identify, analyse and interpret trends in data sets
• Investigate and resolve data issues by identifying issues and liaising effectively with appropriate business and tech teams
• Transform and load the data into our standard database structure
• Acquire new data from various data sources and 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 required data is made available 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 to find solutions where appropriate
• Co-ordinate and produce bespoke data sets
• Process, cleanse, and verify the integrity of data used for analysis
• Collaborate with Data Scientists and Data Engineers on several projects

Requirements:

• 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 – required to write and debug SQL, experience with functions, stored procedures, tables, views, etc.
• 3+ years experience with PostgreSQL and MSSQL
• 3+ years of Python experience
• Experience with visualisation tools, Mixpanel and Google Data Studio will be advantageous
• Excellent understanding of databases, data structures and concepts
• Experience with Agile methodologies
• Strong analytical skills with the ability to source, organise and analyse significant amounts of information with attention to detail and accuracy
• Can work quickly and accurately, within reasonable deadlines
• Effective communicator (verbal, written and interpersonal) and presentation skills
• Analytical and problem-solving skills
• Able to think creatively and relay insights from data
• Ability to work well in a team as well as individually