A growing Online Retail Marketing Company in Cape Town is looking for a Junior Data Analyst (Dialer Team) to join their team. The ideal candidate for this role will be responsible to support, enhance, optimize and automate the current dialer reporting environment by extracting, transforming and loading data from various sources using Excel, TSQL, and SSIS. Furthermore, it is required to develop and enhance reporting and analytical capabilities/solutions, using Excel, SSRS, Power-BI and SSAS, delivering projects that service and support the business’ requirements in an agile manner. Successful incumbent should have a 3-year degree or diploma in relevant field with 2 years data and report processing experience.
Deliver data and information:
Understand business data and information requirements as per technical specifications.
Deliver data and information to the business in line with business priorities, according to quality.
standards, within the agreed time constraints and according to departmental coding practice and standards.
Be involved in the process of gathering and collating data within the Dialer reporting environment.
Offer support to information delivery production environment:
Understand the current production environment and relevant processes.
Support the Dialer Team in maintaining the reporting environment, ensuring delivery of current
information to the business is on time, effectively collected, correctly transformed, audited and
Ensure efficient and effective resolution of production issues.
Ensure that information is delivered according to user expectations.
Monitor the environment to proactively engage in prevention activities and to maintain an environment
that is easy to understand and troubleshoot.
Provide a support service to users on data, information and /or reports to satisfy user needs and
Qualifications & Accreditations:
Relevant 3 years’ degree / diploma.
Experience & Skills:
A minimum of 2 years’ data and report processing experience with a working understanding of Excel,
Pivot tables, and Cubes.
At least 2 years’ experience in ETL processes using SSIS.
Intermediate to advanced skill level in using MS-SQL/T-SQL.
Beginner to intermediate skill level in developing reports using SSRS.
Competent to advanced skill in Microsoft Office (Word, Excel).
The following experience would be advantageous to have:
Exposure to Self-Service BI using Power-BI.
Exposure in working within an agile project environment.
Exposure to call centres and dialers.
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to firstname.lastname@example.org and mention the reference numbers of the jobs.