DM.Data Analyst – Digital Marketing
|Company||Digital Outsource Services|
|Location||Century City, Western Cape, South Africa|
This position requires a motivated, energetic, inquisitive and highly numerate person who has a solid technical base, but who also possesses an appreciation for numbers. Someone who understands the value that can be derived from interrogating numbers and adding value and solutions to the Digital Marketing team and the rest of the business. The successful candidate will be a data warehouse specialist, who is proud to design and implement a dimensional model and present the findings, derived from the data it contains. This position reports to the Digital Marketing Operations Manager.
|Job Functions||Analytics,Information Technology|
Duties will include, but not limited to:
•Integration of new sources of data into Company databases, so that it can also be analyzed and included in relevant reports
•Integration of data into relevant workflow processes, with the specific aim of continuously adding value to business data
•Conceptualizing, defining and delivering new reports, as well as improving existing ones
•Analysis of data from various sources in order to ensure that the Business acts proactively on the information at its disposal
•Continually searching for new and useful ways to obtain, integrate and analyze data that is relevant to the Company’s business model
•Education of report end-users, so as to ensure a maximum spread of expertise around the Company
•Minimum of 12 months experience with SQL (MSSQL, MySQL, Oracle Database)
•Minimum of 12 months experience with reporting and analytics using vast amounts of data or reporting cube(s)
•Experience in creating management reports
•Advanced Excel skills (pivot tables, graphs, formulas, functions)
•Degree with majors in IS / math / stats / engineering or similar. Alternatively, at least 3 years relevant work experience will be considered
•Experience in Online marketing from branded display to direct response channels
•Knowledge of relational databases, MS Office, VBA, data mining and stats software
•Experience with SQL (e.g. MS-SQL Server 2008 r2, 2012, 2014), OLAP (e.g. MS-Analysis Services (SSAS)), reporting tools (e.g. MS-Reporting Services (SSRS)), data transformation (e.g. MS-Integration Services (SSIS)) and data warehouses
•Experience with statistical software such as R, Matlab, Octave, Python, Statistica, etc
•Solid knowledge and understanding in Stats, spreadsheets and graphs
•Solid knowledge and understanding of Business metrics and processes.
•Solid knowledge and understanding of Digital Marketing and search engine optimization best practices.
•Solid knowledge and understanding of CSC systems & technology
•Working knowledge of Excel spreadsheets, graphs and formulas
•Knowledge of online marketing and writing for websites
•Good Interpersonal & relationship building skills
•Excellent planning & organizational skills
•Proven analytical and problem solving ability
•Ability to work in a fast paced, pressurized environment
•Excellent communication skills; verbal & written skills
•Strong decision-making skills and able to take accountability
•Good interpersonal and communication skills
•Strong numerical skills
•Logical & ability to solve problems
•Excellent time-management skills
Shortlisted candidates may need to complete an assessment
"This position requires trust and honesty it has access to customers financial details - therefore a credit and criminal record check will be conducted."
"By applying for this role, and supplying the necessary details, you hereby grant us permission to apply for these checks. This will be done in a confidential manner, and solely for the purposes of verification."
|Job Closing Date||31/12/2017|