BI Developer

Responsibilities: Design and develop database systems Support and write complex and optimized SQL queries Support existing applications and reports (trouble shooting, correction, implementation) Translate business, operational and functional requirements to management Write reports using SSRS, SSIS, and Power BI Ensure the accuracy of MS SQL database information Make changes to the reports necessary to make certain management decisions Extract, load and transfer the necessary data according to business needs Clean and prepare data for reporting Recommend techniques and strategies to optimize data storage, reporting, and analysis Document the solutions being considered Ensure the quality of deliverables Monitor daily jobs and act when needed Notifications are sent all day with the status of the SQL jobs execution Monitor and act on the new requests Take part in the daily SCRUM and act on the assigned tasks Requirements: Minimum of 2 years of experience as a BI Developer Degree, Diploma or IT related certification Intermediate to advanced understanding of the SQL Server Environment and relational database modeling Intermediate to advanced level Transact-SQL Intermediate understanding of C# and APIs Intermediate SSIS knowledge / Experience Advanced understanding of Data structures (JSON, XML, CSV etc.) Advantageous: Ability to create reports in Excel Power BI and forecast results Intermediate to advanced level DAX / M (Power Query Formula Language)

Location: Durban, ZA

Posted Date: 1/11/2025