Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.
We are looking for a Senior BI Developer to join our financial services client based in Sandton.
What you will be doing:

  • Interact with business and system analysts to resolve problems.
  • Collaborate with analysts to understand source structures, evaluate requirements and finally deliver a solid solution.
  • Conduct data analysis on various source systems as part of the solution development process.
  • Develop and maintain SSIS packages.
  • Create required database structures.
  • Develop and maintain T-SQL code.
  • Analyse SQL execution plan to optimise performance.
  • Develop SSAS models.
  • Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications.
  • Contribute to the development of architectural guidelines and standards.
  • Prototyping, Research and Development of new techniques and solutions
  • Team engagement champion
  • Scheduling business processes via ETL tools
  • Excel Reporting and scripting – advanced charting, conditional formatting.
  • Understand and resolve complexities working across multiple database platforms.
  • Develop PowerBI and SSRS reports.
  • Must be able to read and maintain code not written by yourself.
  • Have experience following a formal SDLC as part of solution delivery.
  • Optimise ETL processes as well as SQL queries by analysing query execution plans.
  • Maintain code repositories for version control of developed solutions.
  • Peer review of code and solutions developed.
  • Create and maintain metadata repositories.
  • Implement database structures according to specifications and guide on improvements (indexes/partitioning etc.) where necessary.
  • Perform ETL support on a standby basis to ensure that the ETL batch completes within SLA.

What we are looking for:

  • Completed IT degree / BSc degree or other related fields
  • Microsoft Business Intelligence certifications will be an added advantage
  • 5 years’ experience in BI with over 3 years’ experience in implementing complete BI solutions within an enterprise data warehouse.
  • Ability to design and implement complete ETL processes using SSIS and T-SQL.
  • Strong ETL experience in loading slowly changing dimensions as well as transactional and snapshot fact tables.
  • Strong reporting experience using Microsoft data technology stack such as (, SSRS, Power BI)

Please note that if you do not hear from us within 3 weeks, consider your application unsuccessful.

Desired Skills:

  • SSIS
  • T-SQL
  • SQL
  • ETL

Learn more/Apply for this position