SQL BI Developer - Dashboards & Data Warehousing Expert

Boardroom Appointments; Cape Town; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Boardroom Appointments is seeking a BI Developer to join the BI team. You will design and build reports, dashboards and analytical tools, collaborating with Product Development to capture requirements and interface designs for existing applications.

You should have at least 5 years of software development experience and practical knowledge of SQL Server Analysis Services; prior exposure can be learned during the internship programme.

Qualifications

• Minimum 5 years related experience.
• Experience with data warehousing and BI tools.
• Ability to translate requirements into technical specifications.

Responsibilities

• Be familiar with development best practices and troubleshoot issues.
• Review technical specifications drawn up by other developers.
• Work with SQL Server stored procedures, SSIS, SSRS and TFS.
• Understand data modelling to differentiate between alternatives and choose best suited solutions.
• Create accurate source to target data mappings, including translations.
• Design and develop data exploitation systems delivering dashboards and reports from MS SQL databases and data warehouses.
• Design and develop efficient high-volume data load strategies.
• Re-engineer and optimize existing data sourcing routines.
• Translate business processes into technical specifications.

Skills

SQL Server

SSAS

SSIS

SSRS

TFS

Data Modelling

Dashboards

Education

Bachelor's degree in Computer Science

Tools

TFS

SQL Server

Job description

Boardroom Appointments is seeking a BI Developer to join the BI team. You will design and build reports, dashboards and analytical tools, collaborating with Product Development to capture requirements and interface designs for existing applications.

You should have at least 5 years of software development experience and practical knowledge of SQL Server Analysis Services; prior exposure can be learned during the internship programme.