EN

Data Analyst SQL

Company MotoVantage
Reference # DAS001
Published 17/10/2019
Contract Type Permanent
Salary Market Related
Location Randburg, Gauteng, South Africa
Introduction
MotoVantage, formed through a partnership between FirstRand Group and The Hollard Insurance Company, brings you innovative vehicle insurance products at competitive prices as add-ons to any finance agreement. We are seeking to recruit a Data Analyst SQL.
Job Functions Analytics,Data Analysis
Industries Insurance,Science & Technology
Specification
JOB DESCRIPTION:
We are looking for a Data Analyst to build extracts and reports using languages (SQL) and technologies of the .NET framework (SSIS).
In this role, you should be able to write functional code with a sharp eye for spotting errors. If you are also passionate about report writing using SQL server, we’d like to meet you.
Your goal will be to work with internal teams to design, develop and maintain SQL scripting.

KEY RESPONSIBILITIES
•Import multiple files off the various MFT/SFTP sites
•Participate in requirements analysis and develop documentation relating to data extraction and report writing
•Write clean, scalable code using SQL server 2012 and above
•Identifies and escalates potential risks
•Test and deploy data extracts and reports (build customer trust and loyalty)
•Assists in business user acceptance testing of systems improvements
•Improve existing SQL scripts, stored procedures and scheduled jobs (Update and modify current processes to align with the changing needs of business.)
•Queries, cleans and mines large data sets, connecting data from disparate sources to identify insights and patterns
•Assist in resolving internal customer dissatisfaction/complaints and takes ownership of the problem
•Ad-hoc/General;
oOverall support the analytics team (Pricing, Leads, Quoting workstreams) and other teams in the company based on requirements and availability (relating to data extraction and distribution)
oGeneral ad hoc queries from business

COMPLIANCE RESPONSIBILITIES:
•Adhering to the Code of Ethics and related policies, including personal account dealing, gifts, inside information, etc.
•Ensuring Compliance forms and declarations are completed and returned on a timely basis
•Ensuring timely completion of Compliance training
•Reporting any possible and actual breaches, errors, or complaints

Requirements
QUALIFICATION / EXPERIENCE:
•Degree in Computer Science / Information systems
•1-2 years working experience (Insurance environment will serve as an advantage)
•Experience in report writing using SQL scripting/stored procedures

SYSTEM SKILLS:
•SQL Server, SSIS, SSRS
•Microsoft Office, Windows
•Familiarity with the ASP.NET framework
•Basics of data visualization

PERSONAL ATTRIBUTES:
•Logical thinking
•Enthusiastic, hardworking and driven
•Desire to learn and make the most of opportunities as they are presented
•Self-starter, with the ability to use own initiative
•Able to work under pressure
•The desire to improve oneself and existing processes
•Excellent communicator and team player
•Good customer service skills
•Good organisation skills
•Able to own an issue from identification to resolution
•Able to handle sensitive information discreetly

Job Closing Date 18/11/2019
Share on
 
Last Updated: 12-9-2019 [19.09.05.00]
Webserver: SkillsMap (NLBC)