Datafin

BI Developer (CPT/JHB)

IT – Software Development
Cape Town – Western Cape ~ Johannesburg – Gauteng

ENVIRONMENT:
JOIN the Retail BI Development team of a renowned Investment Firm seeking the expertise of a proactive, meticulous and strong problem-solving BI Developer. You will be responsible for the systems that support client investment reporting and screening functionality. You will also develop integration solutions using T-SQL, SSIS and other vendor integration tools, ETL Development and maintain existing SSRS and QlikView report definitions to present the data. The ideal candidate must possess a Degree/Diploma in Information Science or related technical discipline, have 5-8 years’ SQL experience – stored procedures, UDF’s, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc. and proficiency with SSIS, C#, Scala, SSRS, QlikView and knowledge of financial concepts and terms.
 
DUTIES:
  • Work as part of a larger IT team using the Scrum methodology.
  • Interact with business users, Business Analysts and other Developers to understand user requirements.
  • Develop integration solutions using T-SQL, SSIS and other vendor integration tools.
  • ETL Development to load Data Warehouse.
  • Maintain existing SSRS and QlikView report definitions to present the data.
  • Support existing integration and reporting solutions in the production environment by analysing problems reported by users and track down their cause through debugging techniques and discussion with other team members.
  • Testing and deployment of new development.
  • 1st Line Support for nightly Data Warehouse integration (on a rotational basis).
 
REQUIREMENTS:
Qualifications –
  • Degree or Diploma in Information Science or related technical discipline.
 
Experience/Skills –
  • 5-8 Years SQL experience (stored procedures, UDF’s, T-SQL, performance tuning and optimization, RDBMS, error handling and logging, etc.) is essential.
  • Experience with data integration, validation and reconciliation (SSIS, C#, Scala).
  • Expert knowledge of reporting technologies (SSRS, QlikView or similar).
  • Working experience with relational and dimensional database structures.
  • Working experience with design and development of data marts and data warehouses.
  • Interacting with business users to understand requirements and producing solutions.
  • Knowledge of financial concepts and terms and interested in attending courses to improve business knowledge.
 
Advantageous –
  • Experience creating and maintaining cubes (SSAS).
  • AWS Cloud implementation.
  • Jira and GitLab.
  • Exposure to PostgreSQL and Power BI.
  • Financial Services industry experience.
 
ATTRIBUTES:
  • Attention to detail and quality.
  • Problem solving.
  • Willingness to take initiative and responsibility.
  • Able to meet deadlines and deal with pressure.
  • Can work effectively as part of a diverse team and cross-train with team members.
  • Strong analytical skills.
  • Good communication.