SQL BI Developer

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

BI Developer, you'll be working with the Business Intelligence team to design and build new reports, dashboards and analytical tools. Collaborate with the Product Development team on their projects, including defining requirements and designing interfaces for existing applications. You should have at least 5 years of experience in software development. Experience with SQL Server Analysis Services is required but not essential as it can be learnt during your internship programme.

Duties and responsibilities:

• Be familiar with development best practices and be able to troubleshoot technical and performance issues
• Review technical specifications drawn up by other developers in the team
• Be comfortable with SQL Server stored procedures, SSIS, SSRS and TFS
• Understand data modelling techniques so as to be able to differentiate between available alternatives and which are best suited to the current problem
• Create accurate and complete source to target data mappings, including all translations a
• Design and develop data exploitation systems to deliver information to business users, e.g. dashboards and reports, sourcing data, mainly from various sources including Microsoft SQL databases and data warehouses
• Design and develop efficient high volume data load strategies
• Re-engineer and optimize existing data sourcing routines
• Design and develop mechanisms to ensure that data loaded and transformed is accurate and reliable Understand business processes and data and be able to translate requirements into technical specifications

Qualifications and experience:

• Bachelors degree in Computer Science or related field
• Minimum 5 years related experience
• Prove the accuracy of own work delivered by writing own test scripts Qualification and experience
• Conduct systems integration testing by understanding the flow of data between system components and where data is transformed and/or translated