KEY RESULT AREAS

Data Preparation and Integration

 Develop and/or maintain ETL/SSIS processes for data warehousing, data Integration and data dissemination to various business units.

 Develop and/or maintain Stored Procedures, Views and Tables to aid in the timeous dissemination of data and/or leads.

 Develop and/or maintain table level objects such as Triggers, Indexes and Constraints.

 Extract data according to specifications accurately and deliver within specified time frame repeatable and automatable.

 Develop Solutions geared toward automation and tracking of Failures/Successes.

 Investigate data quality issues and implement appropriate solutions according to policy.

 Reviewing and analysing data from multiple internal and external sources including business partners.

 Develop high quality code and documentation with minimal supervision.

 Comply with development standard and best practices including corporate governance and directives from management.

 Participate in team problem solving efforts and offer ideas to solve general day to day issues.

 Ability to deliver results under demanding timelines to real-world business problems. Reporting and Tracking

 Execute, monitor and refine processes to produce BAU reporting for daily and monthly performance reporting and tracking

 Ensure data is usable for MIS into the department’s daily, weekly and monthly reports allowing for flexible and user friendly insights.

 Utilise automation for creating data required for daily reports
Data Quality;

 Ensure adherence to the systems in place to ensure data quality

 Ensure adherence to data quality standards to ensure that the required qualities of the data are met: o Accurate, Consistent, Duplication, Enhanced, Legally compliant; Complies with laws such as POPI and opt-in, Secure, Segmented Execute data clean-up measures when required.

 Maintain a record of original data and corrected data.

 Identify areas of improvement to achieve data quality.

 Analyze, query and manipulate data according to defined business rules and procedures.
Data Governance

 Ensure adherence to set out standard operating procedures and policies
Data Processing

 Effectively run processes that require the flow of data for leads generation, segmentation , routing as per business specifications

 To incorporate new data sources as well as third party incorporation of process for the Execution of campaigns e.g. SMS
campaigns.

 Manage the flow and routing of leads from generation to nurturing.  Provide data to the Strategy and Analytics teams as per specifications.  Analyse results and set up processes as required by management.  Assist with data as required for meetings.

 Maintain backups of all processing code as per departmental policy.

 Test and validate functionality of the new implemented data processes.

 Maintain complete documentation of any follow up changes
Customer  Provide ad-hoc assistance where and when necessary.

 Communicate effectively with other stakeholders such as team members and other departments.

 Manage projects so that deliveries are met and results are presented in a professional manner by means of presentations and or reports.

 Build a positive image by exceeding client expectations at all times.

 Treat internal and external customers fairly at all times
Learning and Growth

 Own development plan.

 Continuous learning on company techniques, products, processes, policies and procedures related to their job function.

 Continuously develop sales, interpersonal, self-management and EQ qualities and capabilities in the team.