Data Analyst

Data Analyst

Cape Town / Remote

Permanent

A fintech company who build innovative fintech products have Data Analyst role that has opened within their medium sized company. 

The organisation supports small and medium enterprises with the funds to help them grow, and are looking for candidates who love to make a difference and change the game in building the next generation of business friendly fintech products.  The more businesses that succeed, the more jobs, money, and opportunities for all South Africans

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 will include:

• 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

The Competencies We’re After

• 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

The Skills and Experience We’re Looking For

• 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