Data Analyst
Johannesburg, South Africa
Standard Bank Group
The Standard Bank group is a leading financial services provider that supports Africa’s growth and development.Company Description
Standard Bank Group is a leading Africa-focused financial services group, and an innovative player on the global stage, that offers a variety of career-enhancing opportunities – plus the chance to work alongside some of the sector’s most talented, motivated professionals. Our clients range from individuals, to businesses of all sizes, high net worth families and large multinational corporates and institutions. We’re passionate about creating growth in Africa. Bringing true, meaningful value to our clients and the communities we serve and creating a real sense of purpose for you.Job Description
To extract, transform and load correct customer contact information and research reporting using approved relevant sources for extraction/analysis as defined by Market Research: Customer Data Management in order to support market research contact requirements.
To ensure that the data loaded for Research Agencies to use when contacting customers is in line with defined criteria and reconciles back to the relevant sources that it was extracted from.
The MIS Data Manager is responsible for supporting the PBB SA Market Research team with timely Extraction/Reporting/Analysis/Dashboard solutions using PowerPoint/Excel/Word/SQL Server/SSIS/SSRS/QlikView/Power BI, MS Excel, SAS and similar Business Intelligence tools.
Qualifications
First Degree or Diploma in IT or Computer Sciences
Certifications (Advantage)
Certifications (Advantage)
- Qlik (QlikView/QlikSense)
- Power BI
- MS SQL SSRS/SSIS/SSAS
- Teradata
- Business Intelligence
- Data Analysis
- Agile 101
Additional Information
Extracts, transforms and loads customer contact data in line with governance standards.
Adheres to the customer information extraction governance standards that are defined in line with business rules that are built into the data source.
Measures:
No variance between the extracted and distributed customer data and data in the original source
No violation of customer information access protocols
Adherence to the customer data extraction governance standards
Data requirements execution
Extracts, transforms and loads customer data from relevant sources in order to satisfy customer data requirements as defined by Business and Market Research.
Ensures that the extracted data is loaded onto the approved file sharing systems that comply with customer data protection and privacy standards.
Reports any technical malfunctioning of the customer data extraction that threatens adherence to business and compliance requirements to the line manager.
Measures:
Timeous escalation of customer data extraction technical malfunctioning
Timeous data availability, accessibility, and usability for CHNW SA Market Research
Loading of customer contact data onto the external research supplier file share platform
Loads customer contact data from relevant sources (e.g. SAS libraries, SQL, manual files, etc.) in order to ensure a single input source for Market Research measurement.
Validates and reconciles the data back to the relevant sources (e.g. SAS libraries, SQL, manual files, etc.). Adheres to validation standards as stated in the governance framework.
Ensures that the data extracted, transformed and loaded is automated where possible and writes automation codes accordingly.
Measures:
Stakeholder feedback on quality of data
Availability of customer contact data to answer business questions
No variance between data sources data and data loaded onto supplier file share platforms
Reporting & Automation
Creation and maintenance of customer data extraction scripts and reports as required for Market Research measurement
Manages the consolidation of all relevant customer information for Market Research purposes.
Provides and adheres to customer data reporting requirements and standards as stipulated in the service level agreement (SLA); measurement governance framework
Provide continues improvement customer data extraction, reporting and distribution.
Continuous generation of both periodic and ad hoc customer data extraction requests.
Analyze business customer data information requirements to identify process improvements for increasing business efficiency and effectiveness.
Puts plans in place to automate all standardized reporting functions
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Business Intelligence Data analysis Data management Excel Market research MS SQL Power BI Privacy Qlik QlikView Research SAS SQL SSIS Teradata
Perks/benefits: Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Senior Data Architect jobs
- Open Product Data Analyst jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Sr. Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Big Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Quality Analyst jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Data Analyst Intern jobs
- Open Junior Data Engineer jobs
- Open Research Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open GCP-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Java-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open PhD-related jobs
- Open NLP-related jobs
- Open CI/CD-related jobs
- Open Data governance-related jobs
- Open Kubernetes-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open Data warehouse-related jobs