Senior Business Intelligence Developer

k0deHut; Johannesburg; Hybrid; ZAR 600 000 - 800 000; Full time

Job summary

A leading tech company in Johannesburg is looking for a Senior Business Intelligence Developer to implement end-to-end data solutions using the Microsoft BI Stack. The ideal candidate will have extensive experience in SQL development and data processing methods including SSIS, SSAS, and Power BI. This hybrid position involves collaboration with stakeholders and assistance in optimizing SQL queries. Enjoy a dynamic work environment with opportunities for growth.

Qualifications

• Minimum 6 Years experience as a Microsoft SQL Developer.
• Minimum 6 Years experience in SSIS, SSAS, SSRS & Power BI.

Responsibilities

• End to End Data Solutions through Microsoft BI Stack.
• Create and optimize advanced SQL queries for efficient data retrieval.
• Generate financial data for Revenue Services and reports.
• Administer Month End procedures and Monthly Commission runs.

Skills

Query optimization and troubleshooting

Workflow tools including Atlassian JIRA

Version control tools including Azure DevOps and Team Foundation Server

Education

Bachelors Degree in Computer Science, Information Technology or a related field

Microsoft Certifications in Business Intelligence and / or Data Engineering

Tools

Microsoft Azure

Cloudera

SAP HANNA

SSIS (ETL Development)

SSAS (Data Cube / Mining)

SSRS (Report Development)

Power BI (Data Visualisations)

Job description

About the job Senior Business Intelligence Developer

Job Title: Senior Business Intelligence Developer

Location: Houghton Estate (Hybrid)

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
• Automation of 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