BI Developer

SUMMARY:
Our client has an exciting opportunity for a BI Developer to join their team. They are dynamic leaders in Business Process Outsourcing, based in the vibrant heart of Umhlanga.

POSITION INFO:
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

• 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 API’s
• Intermediate SSIS knowledge / Experience
• Advanced understanding of Data structures (JSON, XML, CSV etc.)

• Ability to create reports in Excel Power BI and forecast results
• Intermediate to advanced level DAX / M (Power Query Formula Language)