Data Analyst - Cape Town at Impact

Your Role at Impact:

• The data analyst is responsible for collecting, analyzing and interpreting large and complex datasets to identify patterns and trends, surface facts and develop insights, aiding the team in delivering data-driven recommendations to support business decisions.
• The ideal candidate will have a technical background and experience performing data analysis, building reports and producing forecasting models in a professional environment. The data analyst needs to be a clear communicator that can confidently interact with technical and non-technical stakeholders and present analysis and research findings to the broader team.

Data pun: "which way did the programmer go? He went data way"

What You'll Do:

• Extract and analyze data from various sources including relational databases (mySQL, postgres), big data technologies (BigQuery, Kudu, Impala, SingleStore, Hive), file sources (parquet, ORC, avro, csv, xlsx) and reporting systems (Looker, DOMO)
• Conduct data analysis, surface insights and present recommendations to both technical and non-technical stakeholders in a clear and concise manner
• Create visualizations, dashboards and reports to present data analysis findings
• Use statistical techniques to identify trends and derive patterns and insights embedded in the data
• Assist with the identification, creation and maintenance of master datasets
• Actively participate in and occasionally lead data stewardship initiatives
• Clean and manipulate data to ensure high quality and integrity of reporting outputs
• Help drive adoption of data mart and reporting outputs in the broader organization
• Contribute to and compile technical specifications for new data assets (marts, tables, views, cubes)
• Collaborate closely with data and analytics engineers to close the gap between stakeholders' data needs and development efforts
• Analyze source systems and help identify business logic embedded in the underlying datasets
• Identify and communicate data quality and data validation issues in productionalized datasets
• Build and maintain dashboards to support business stakeholders
• Perform ad-hoc data analysis to determine suitability of a data source for use in data marts and reporting outputs or to assess key performance indicators (KPIs)
• Troubleshoot process failures and identify opportunities for automation
• Help train and up-skill new team members

What You Have:

• Bachelor's degree in mathematics, statistics, economics, computer science or a related field
• 3+ years of experience in a data analysis, business intelligence or data engineering role
• Developed analytical and problem-solving skills
• Python and SQL coding skills
• Developed data analysis and data visualization skills
• Experience with the Google Cloud Platform (GCP) and integrated technologies preferred
• Exposure to DataBricks, PySpark and BigQuery highly advantageous
• Experience with data wrangling (data cleaning, manipulation and preparation)
• Exposure to machine learning libraries, tools and protocols (supervised & unsupervised learning)
• Experience with standard statistical modeling and forecasting methodologies
• Exposure to no-sql data systems beneficial (HBase, Redis, Kafka)
• Experience with data visualization tools such as Tableau, Power BI, SSRS/SSAS, Looker or QlikView
• Good verbal and written communication skills
• Ability to work independently and collaboratively in a fast-paced, dynamic environment
• Experience working in the marketing technology industry beneficial

Nice to have:

• Affiliate & Partnerships Industry Fundamentals Certification by PXA