Business Intelligence Developer

Business Intelligence Developer

Job Title: Business Intelligence Developer
Location: Gauteng
Salary: 540000.00
Reference: JN -052017-8409
Job Published: October 19, 2017 08:44

Job Description

Business Intelligence Developer

As a Business Intelligence Developer, you will work to deliver analytics to the business using QlikView, SQL Server Reporting Services (SSRS) and Salesforce.
We are looking for an enthusiastic, bright individual with a good sense of business. A quick learner, who will take an active interest in all information systems. The position will be based in Bryanston and will have significant interaction with Exco and management.

3.Role description

Requirements gathering and analysis:
  • Facilitate BI business requirements and design review sessions
  • Perform detailed analysis of source systems data
  • Create report, dashboard and QlikView app specifications
  • Provide input on proposing, evaluating and selecting appropriate design alternatives
Design, Development and testing
  • Extract Transform and Load (ETL)
  • Data Modelling in QlikView from multiple data sources
  • Design advanced SQL queries for ad hoc reporting
  • Design and deploy reports and dashboards in Salesforce
  • Design and deploy reports and dashboards using SSRS
  • Testing against business requirements
  • Create and maintain technical design documentation
  • On-going monitoring and maintenance of all components that make up the BI infrastructure
  • Perform QlikView system administration and testing of releases and patches
  • Ensure that the QlikView server processes continue to run and operate in the most efficient manner
  • Maintain the referential integrity of the database
  • Act as evangelist for BI benefits across the organization thus promoting BI usage
  • Continuously improve - identify opportunities, suggest and implement solutions.

4.Desired Skills and Experience

  • A bachelor’s degree in computer science , information systems, or a related tertiary qualification
  • Minimum 1 years SQL development experience
  • Minimum 2 years developing BI and analytical solutions using QlikView
  • In depth, hands on experience in QlikView data modelling, scripting, data source integration and GUI development and QlikView concepts including charting, set analysis, reusability, section access security models and expressions
  • Strong Knowledge on SQL Server Reporting Services (SSRS)
  • Knowledge on SQL Server Integration Services (SSIS)
  • Background in development (particularly Salesforce) is highly advantageous
  • Ability to write complicated yet efficient SQL queries and stored procedures
  • Full understanding of the processes of data quality, data cleansing and data transformation
  • Knowledge of formal database architecture and design
  • Experience in sourcing data from disparate systems with a good understanding of their Data Models

5.Personal Traits

  • Enthusiastic about learning large and complex systems and processes
  • Results-driven with the ability to take initiative, handle multiple tasks, shifting priorities and meet deadlines
  • Able to multi-task in a fast-paced, dynamic environment
  • Excellent problem solving skills and logical, clear and calm thinking – especially under pressure
  • Solves complex problems with creative solutions
  • Possess strong communication and analytical skills to effectively elicit, capture, develop and implement business requirements
  • Ability and willingness to learn new applications and business processes
  • Positive, mindful, open and have a growth mind-set

6.Reporting to

Internal Operations Manager