Developer: SQL and Reporting

• Design, develop, and optimize complex SQL queries, stored procedures, functions, and scripts.
• Ensure that all database systems are maintained and enhanced to meet the organisation's requirements for data integrity, security, and availability.
• Create and restore databases
• Monitor database performance, implement changes, apply new patches and versions when required
• Create Server agent jobs
• Build, manage and support data warehousing solution and contribute to the development of data models.
• Ability to establish ODBC connections between different types of databases and platforms
• Develop and maintain operational, financial, and ad-hoc reports using SQL-based reporting tools (e.g., SSRS, Power BI)
• Ensure data accuracy and consistency in all reports and dashboards.
• Design and implement data pipelines and ETL processes for integrating data from various sources.
• Work with large datasets, ensuring data reliability, consistency, and scalability.
• Create and maintain documentation on database design, ETL processes, and report development.
• Work closely with the developers on projects to assistance with the database structure and relationships

• Grade 12
• Degree or Diploma in Computer Science or related field

• Minimum 3- 5 years’ relevant experience
• Proven experience in developing reports and databases

• Advanced in MS SQL Server BI Stack tools and technologies (SSRS, SSIS, TSQL, Power Query, Power Bi, Dax)
• Strong knowledge of Python.
• Strong Microsoft Excel skills including Macros
• Familiarity with cloud platforms (e.g., Azure)

• Excellent knowledge of data backup, recovery, security, integrity, and SQL.
• Experience in Crystal reports or similar business intelligence tools.
• Solid understanding of ETL processes, data warehousing concepts, and data modelling.

• Ability to work independently and as part of a team
• Proactive, self-starter with initiative to find ways to improve solutions, systems and processes
• Excellent analytical and problem-solving skills
• Ability to learn new software and technologies quickly.
• Ability to follow instructions
• Strong attention to detail
• Excellent communication and documentation abilities.

• Relationships and Collaboration
• Exceptional Client Service
• Business Growth
• Engaging people
• Leadership
• Quality, Risk management and Operational performance

BDO