ENVIRONMENT:
A dynamic investment firms seeks a meticulous & self-driven BI Developer who is passionate about data-driven systems to join its team. Your role will entail developing new and supporting existing integration and reporting solutions which will include testing and deployment. The ideal candidate must possess a Degree/Diploma in Information Science or related technical discipline, have at least 5 years’ SQL including Stored Procedures, UDFs, T-SQL, performance tuning and optimization, RDBMS, error handing & logging, SSIS, SSRS, Power BI and able to interact with business users to understand requirements and produce effective solutions. Please note this is an Employment Equity position.
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 and other vendor integration tools.
– ETL development to load Data warehouse.
– Maintain existing SSRS 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.
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.
– Data integration, validation and reconciliation (SSIS or similar).
– Expert knowledge of reporting technologies (SSRS, PowerBI or similar)
– Working experience with relational and dimensional database structures.
– 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 –
– Financial Services industry experience.
– Exposure to PostgreSQL.
– Experience working in AWS Cloud implementation.
– Creating and maintaining cubes (SSAS).
ATTRIBUTES:
– Attention to detail and quality.
– Problem Solving.
– Willing to take initiative and responsibility.
– Ability 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.
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.