Report Writer and Database Administrator at BDO South Africa

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

Experience Required

• Minimum 3- 5 years’ experience developing reports and databases.
• MS SQL Server BI Stack tools and technologies (SSRS, SSIS, TSQL, Power Query, Power Bi, Dax)
• Python
• Microsoft Excel including Macros.
• Data backup, recovery, security, integrity, and SQL.
• Crystal reports or similar business intelligence tools
• 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 processes.
• Excellent analytical and problem-solving skills
• Ability to learn new software and technologies quickly.
• Strong attention to detail

BDO Core Competencies

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