Report Writer and Database Administrator at BDO South Africa

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