BI ANALYST - Cape Town Verfied

Salary Negotiable Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 07-03-2018 12:13:30 PM
02-05-2018 12:13:30 PM
A vacancy for a Junior Business Intelligence Analyst has become available in our Business
Intelligence Team in Cape Town.
The purpose of the role is to develop, maintain and support the business intelligence and
reporting systems used to provide information to the firm and to support client requests for
information.

KEY RESPONSIBILITIES
System Analysis and Design
o Assist in determining requirements
o Design reporting interfaces
o Design standard reports
System Development
o Develop ad-hoc data extracts using Business Objects, SQL and SQL Server
Integration Services
o Develop front end systems based on requirement specifications
System Implementation
o Ensure accuracy of extracted data prior to sending the results out
o Implement new solutions including ETL projects, Business Objects Reports and
SQL extracts
System Testing and Quality Assurance
o Perform testing to ensure information meets the requirements and accurately
reflects the data of the source system
o Ensure the output data is accurate
o Liaise with applicable people to ensure source data discrepancies are rectified.
§Support and Training
o Provide reports as requested by practitioners
o Give day-to-day support and training to internal clients on: Business Objects
report, data definitions on extracted data and data definitions of available data
System Maintenance
o Perform tests to ensure the warehouse and source system data remains
aligned
o Monitor system performance and exceptions
o Attend to technical problems experienced on reporting systems
§Administration
o Ensure system documentation is in place
o Manage all aspects of scheduled reporting
o Administer security on reporting systems
o Co-ordinate provision of Performance Enhancement Discussion documentation

KNOWLEDGE AND SKILLS
Ability to communicate with and understand the needs of non-technical internal clients so as to
offer creative, workable and innovative solutions
Ability to gather and synthesise large volumes of information from varying sources
? Ability to conceptualise, design and develop multiple system/requests in a concise
manner
? Ability to resolve technical problems in a systematic manner
? Be proficient in office administration and relevant computer software packages e.g.
Microsoft Word, Outlook, Excel, PowerPoint, SQL Server and Business Objects
? Strong administrative and organisational skills as well as the ability to multi-task
? Proven team player, professional, flexible and friendly
? Possess well developed interpersonal and communication skills and the ability to
negotiate
? The ability to work and cope under pressure in a deadline driven environment
? Self-motivated with the ability to display initiative
? Must be able to work under minimum supervision
? Solid analytical skills and attention to detail
? Experience with IDU an advantage

EDUCATIONAL QUALIFICATIONS AND REQUIREMENTS
Relevant university degree required
BI products, preferably Business Objects and Microsoft SQL Server
Minimum one year work experience in a business intelligence environment
Minimum one year experience in SQL programming
Demonstrated knowledge of data warehouse design methodologies
Knowledge of SQL Server Integration Services
This is a demanding but stimulating position which will require working outside of normal office
hours, when necessary