BI Developer

Company Affinity Health
Reference # 216/2017
Published 20/11/2017
Contract Type Permanent
Location Benoni, Gauteng, South Africa

Core Purpose

The BI Developer position requires a strong understanding of the flow of data throughout the business and a basic understanding of the processes performed on the data to transform this data to support Client knowledge discovery. The position will take accountability for obtaining data from Clients, transforming this data into the format required and loading this into a database environment. From there, specified tests will need to be performed on the data and reports and other data objects generated. A strong emphasis will be placed on the optimisation and improvement of existing data load processes.

Job Functions Accounting,Finance
Industries Accounting,Accounting & Auditing,Financial Services
Key Role Outputs

a)Database discovery
•Discovery of new data sources and analysing relationships in new Client operational databases
•Inferring data relationships from business processes and vice versa
•Reverse engineering Customer reports for which source code may not be available
b)Database development and data processing
•Create, maintain and enhance database structures
•Validating the data, testing for consistency and integrity, verifying data links
•Loading and transforming data from current raw format
•Develop database queries and reports
•Write clean, accurate and optimised SQL query scripts against a variety of databases based on Client reporting requirements
•Design and write ad hoc SQL queries, stored procedures, views, triggers, cursors and functions
•Provide SQL administration support in live and test environments
c)Optimising queries
•Implement solutions in various data formats
d)Technical Modelling
•Develop basic data acquisition and capture tools in Excel
•Development of basic financial models and proof of concept models
•Testing results
•Reporting on results
e)Business Intelligence – Application Development
•Developing end user interactive tools on technologies such as QlikView, QlikSense, Power BI
•Loading data into models and defining the underlying data model
•Assist in troubleshooting and debugging application issues
•Documenting operation of models

•Training Clients on use of models
•Testing and refining output
f)Streaming Data
•Build, develop and maintain streaming data sources
•Build real-time dashboards using event stream data
•Develop, support and maintain data collection agents
g)Data Interpretation
•Understand data contained in Client databases and how this data could be used and reported on
•Evaluate data and derive sensible conclusions from the data
•Testing certain business assumptions using the data available
•Assist Client in deriving insights from their data
•Using and applying data-mining statistical technologies to Client specific requirements
h)Data Mining and Predictive Analytics
•Using and applying data-mining statistical technologies to Client specific requirements
•Documenting operation
•Testing and refining output
i)Client / Industry Interaction
•Interpret Client requests for changes
•Explain results of modelling in easy to understand terms
•Act as subject matter expert on the above
•Be available to provide basic user support
•Effective at agile and deadline driven software development
•Effective users of software version control system
•Effective user of task and time management system
•Daily time logging
•Assist in writing technical procedures and documentation
•Identify opportunities that can improve efficiency of business processes with own area of responsibility
Mandatory Qualifications

a)Grade 12 or NQF equivalent
b)Successfully completed studies in one of the following undergraduate Degree:
•BSc Computer Science
•BCom Informatics
•BSc in Mathematics or Actuarial and Financial Mathematics

Advantageous Qualifications

a)BS in Mechatronics
b)BSc Honors Degree in Applied Mathematics

Mandatory Experience/Exposure

a)A minimum of 2 years’ demonstrable experience appropriate to the task requirements for this job
b)Knowledge of data architecture principles
c)Complementary Mathematical/Accounting background is considered an advantage
d)Experience in the development and implementation of standards, procedures and guidelines to support operational processes
e)Technical experience with systems networking, databases

Advantageous Experience/Exposure

a)Knowledge of data architecture principles
b)Complementary Mathematical/Accounting background is considered an advantage

Knowledge and Skills

a)Extensive knowledge of data processing, hardware platforms, and enterprise software applications
b)Good background in database design in Microsoft SQL
c)Background in Microsoft .NET, Visual Basic, Excel, Word, Outlook and HTML
d)Working knowledge of server, data warehouse and business intelligence applications and environments
e)Strong analytical, logical and problem solving skills
f)Self-motivated with the ability to prioritize, meet deadlines, and manage rapidly changing priorities
g)Proven ability to be flexible and work hard, both independently and in a team environment, in a high pressure on-call environment with changing priorities
h)Good English oral and written communication skills

Desired attributes

a)A passion for computers and technology
b)Attention to detail
c)Loves to work with lots of data
d)Logical and analytical
e)Problem solving ability
f)Team player
h)Inquisitive and a quick learner
i)Good time management skills
j)Strong sense of responsibility
k)Ability to work under pressure and deadline driven
l)Willingness to work occasionally outside of normal business hours
m)A results oriented individual who thrives working in a fast paced environment
Job Closing Date 20/12/2017
Share on