Business Intelligence Developer at TechStream Group

One of South Africa's leading Retail brands are in search for a passionate Business Intellingence Developer to join there very sophisticated team of developers. The ideal candidate is very detail oriented, self-driven, and curious and has appreciation for data driven-driven systems.
Responsibilities:

•  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

•  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)
•  Experience with creating and maintaining cubes (SSAS) would be advantageous
•  Working experience with relational and dimensional database structures.
•  Working experience with design and development of data marts and data warehouses.
•  Experience in interacting with business users to understand requirements and producing solutions
•  Experience working in AWS Cloud implementation would be an advantage
•  Experience with Jira and GITLab would be an advantage.
•  Exposure to PostreSQL and PowerBI would be an advantage