Senior Business Intelligence Developer X2 at Sanlam Group

What will you do?

• End to End Data Solutions through Microsoft BI Stack
• Create and optimize advanced SQL queries for efficient data retrieval, manipulation and reporting.
• Create and manage stored procs, functions, views & triggers for efficient data processing
• Liaise with End Users & Stake Holders on adhoc requirements logged to discuss possible solutions
• Create Reporting, Dashboards & Value-Adding use cases based on User Requirements
• Automate Manual Business & BI Processes.
• Task and Self Organisation on KANBAN Board and Online Log Tracking Software
• Assist Junior Developers with SQL/DAX Code Optimisation & QC to align with best practice.
• Complete the list of prioritised logs from the Business within current Sprint Cycle.
• Generate financial data required for Revenue Services, Financial Authority, Reserve Bank reports & Actuarial Model Point files.
• Administer Month End procedures and Monthly Commission runs
• Adhoc duties as assigned by Line Manager / Team Leader
• Create and update documentation for the BI environment

Qualification and Experience:

• Bachelors Degree in Computer Science, Information Technology or a related field.
• Microsoft Certifications in Business Intelligence and / or Data Engineering advantageous.  
• Experience with Microsoft Azure, Cloudera, SAP HANNA advantageous.
• Minimum 6 Years’ experience as a Microsoft SQL Developer.
• Minimum 6 Years’ experience in SSIS (ETL Development), SSAS (Data Cube / Mining), SSRS (Report Development) & Power BI (Data Visualisations).

 Knowledge and Skills:

• Query optimization and troubleshooting
• Workflow tools including Atlassian JIRA
• Version control tools including Azure DevOps and Team Foundation Server
• Attention to detail
• Quality, Compliance and Accreditation
• Business Requirements Definition