Blue-Chip investment firm in Cape Town, looking for an experienced BI Reporting / Integration Developer. Ideally coming out of the Financial Services industry, degreed.
The team is currently around 45 members, covering a range of skills and responsibilities including Business Analysts, Developers (.
NET and SQL), Report Developers and IT Operations. This team is responsible for the systems that support their asset management function.
There is plenty of opportunity to learn about the asset management industry and technology.
We are looking for a developer with at least 5 years’ experience in the Financial Services industry to join a team responsible for developing integration and reporting solutions for the Institutional business.
Working as part of a larger IT team which is comprised of Business Analysts, Integration & Report developers and .Net developers using the Scrum methodology.
Interact with business users, Business Analysts and other developers to understand user requirements.
Write technical specifications where required.
Developing integration solutions using SQL and other vendor integration tools (Markit).
Developing reporting solutions; write SQL stored procedures to manipulate the data supplied by the source system and prepare it for reporting.
Design and create SSRS report definitions to present the data.
Assist with the migration of existing Crystal reports onto SSRS reports.
Optimising SQL queries to improve performance.
EXPERIENCE AND QUALIFICATIONS
Essential : Analytical degree or diploma (ComSci, BBusSci or Bcom with IS / Actuarial, BSc (Eng, Math) or similar.
Knowledge of financial concepts and terms, particularly Asset Management knowledge.
Exceptional skills in writing SQL for Microsoft SQL server, including stored procedures, UDF’s and other T-SQL Querying.
Experience in analysing data and performing complex data manipulation using Microsoft SQL.
An understanding of relational database structures.
Experience in interacting with business users to understand their requirements and managing the implementation of system changes.