Report Writer and Database Administrator - Gauteng at BDO South Africa

Primary Purpose of the Job

• The Report Writer and Database Administrator is responsible for overseeing the maintenance of company databases, building datasets, analysing raw data and converting comprehensive information into written reports.

Main Duties and Responsibilities

• Create backups and restore databases
• Minimise database downtime and manage parameters to provide fast query responses
• Monitor database performance, implement changes, apply new patches and versions when required
• Manage data to support reporting, including the creation and maintenance of reports, through the use of MS SQL Server, Power Bi, SSRS/SSIS, Visual Basic, Visual Studio, Crystal Reports, and others
• Analytical thinking for translating data into informative reports and visuals
• Ability to write ad-hoc queries, create store procedures, functions and views
• Ability to ODBC connections between different types of databases and platforms
• Build reports/functions to help identify data patterns to scrub/clean our data and maintain good data quality.
• Create dashboards and interactive visual reports from multiple data sources
• Collaborate with business stakeholders to understand their needs
• Familiarity with database design and documentation explanations of algorithms, parameters, models and relationships
• Work closely with the developers on projects to assistance with the database structure and relationship

Requirements

Qualifications, Work Experience, and Knowledge 

Qualifications

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

Work Experience

• Minimum 3- 5 years’ relevant experience 

Knowledge

• Advanced in MS SQL Server BI Stack tools and technologies (SSRS, SSIS, TSQL, Power Query, Power Bi and Dax)
• Strong Microsoft Excel skills including Macros

Competencies: Technical & Behavioural

Technical Competencies

• Excellent knowledge of data backup, recovery, security, integrity and SQL.
• Experience in Crystal reports or similar business intelligence tools
• Strong Microsoft Excel skills including Macros
• Excellent understanding of database relationships

Behavioural Competencies

• Internally motivated, ability to work independently and in a team environment
• 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
• Detail-oriented.