Primary Purpose of the Job

We are looking for a highly skilled and detail-oriented Report Writer and Database Administrator to join our team. This individual will be responsible for designing, developing and maintaining reports and databases for our organization. The successful candidate will be adept at writing high-quality reports, analysing large data sets, and managing databases

Main Duties and Responsibilities

Create backups and restore database
Minimise database downtime and optimize database performance through data analysis, index optimization, and other techniques
Ensure that all database systems meet the organization’s requirements for data integrity, security, and availability.
Monitor database performance, implement changes, apply new patches and versions when required
Ability to write ad-hoc queries, create store procedures, functions and views
Ability to establish ODBC connections between different types of databases and platforms
Develop and maintain dashboards and reports to support the departmental needs.
Troubleshoot data-related problems and resolve them in a timely manner.
Collaborate with other departmental teams to ensure that the necessary data is available for reporting purposes.
Manage deployment of databases and reports to various environments.
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

Requirements
Qualifications

Grade 12
Degree or Diploma in Computer Science or related field

Work Experience

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

Knowledge

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

Technical Competencies

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

Behavioural Competencies

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

BDO Core Competencies

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