Senior BI Developer (Digital Marketing)

Senior BI Developer (Digital Marketing)

Job Title: Senior BI Developer (Digital Marketing)
Location: Western Cape
Salary: 0.00
Reference: JN -062017-8681
Job Published: June 08, 2017 15:26

Job Description

This role requires a motivated, energetic, inquisitive and highly numerate person who has a solid technical base but also possesses an appreciation for numbers and understands the value that can be derived from interrogating them. 
This role performs ETL tasks, Cube creation and maintenance, investigations on data integrity and identify gaps for improvement for the business and the team itself. This role require a thorough understanding of our business, its needs and weaknesses in order to provide value through the use of Analytics and BI.

Job Functions Information Technology Industries Digital,Information Technology Specification
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 improvement and data optimization 
•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 
•Driving new solutions based on business requirements


Essential Requirements:

•A degree with majors in Information Systems / Mathematics / Statistics / Engineering / Business or similar Alternatively, at least 3 years work experience in a business intelligence role
•Extensive experience in process driven optimization relating to business reporting and analysis
•A minimum of 5 years strong SQL experience with specific reference to creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, incremental data loading, change tracking/cdc. Etc.)
•A minimum of 4 years SSIS experience with specific reference to creation of complex ETL (Extract, Transform, Load) processes, error handling, loading data from various sources (flat files, xml), integration of new data warehouse, precedence constraints, parameterized connections
•A minimum of 4 years SSAS experience with specific reference to creation, implementation and maintenance of multi-dimensional cubes, MDX and DAX
•Advanced MS Excel 

Advantageous Requirements:

•Relevant Post Graduate degree 
•Experience in
•Software dev background
•Service broker queue
•Project management experience

Job Requirements:

•Knowledge of Enterprise Data Warehouses
•SSRS (demonstrated experience in complex reports, master reports and cube reporting) 
•Knowledge of and experience with Enterprise Data Warehouses

Personal Competencies:

•Demonstrates consistent behaviour aligned to the Combiined F and Organizational Culture
•Ability to work in a pressurized environment
•Strategic planning and execution skills 
•Aptitude for self-development
•Ability to work independently as well as in a team
•Ability to problem solve creatively and think laterally
•Solutions orientated
•Ability to work in a pressurized environment
•Willing to take on challenging responsibilities
•Ability to innovate and show initiative
• Strong communication skills & ability to mentor others
•A team player with good interpersonal skills


Get similar jobs like these by email

By submitting your details you agree to our T&C's