Report Writer and Database Administrator

BDO South Africa; Gauteng; On-site; ZAR 300 000 - 600 000; Full time

Job summary

An established industry player is seeking a talented Report Writer and Database Administrator to enhance their data management capabilities. This role involves designing and maintaining reports and databases, ensuring data integrity, and optimizing performance. The ideal candidate will have a strong background in SQL Server BI tools and Python, coupled with a proactive approach to problem-solving. Join a dynamic team that values growth and collaboration, where your contributions will directly impact the organization’s success. If you're passionate about data and eager to make a difference, this opportunity is for you.

Qualifications

• 3-5 years of experience in report and database development.
• Proficient in MS SQL Server BI tools and Python.

Responsibilities

• Design, develop, and maintain reports and databases.
• Optimize database performance and ensure data integrity.
• Collaborate with teams to provide necessary data for reporting.

Skills

Data Analysis

Report Writing

Database Management

Problem-Solving

Attention to Detail

Team Collaboration

Proactivity

Learning New Technologies

Education

Grade 12

Degree or Diploma in Computer Science

Tools

MS SQL Server BI Stack

SSRS

SSIS

TSQL

Power Query

Power BI

DAX

Crystal Reports

Job description

Report Writer and Database Administrator

Company: BDO South Africa

Date: 2023-08-01

Location: Gauteng

Job Ref #: SASZDTJHB28NOV22VS

Industry: Professional

Job Type: Permanent

Positions Available: 1

At BDO, we believe in investing in our people to help them grow, both professionally and personally. The foundation of our business is strong relationships, with colleagues, clients, and other stakeholders, and we work hard every day to make this a reality. Our commitment is to create unlimited growth by giving our people continuous opportunities and our client's unparalleled support.

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, analyzing large data sets, and managing databases.

Main Duties and Responsibilities:

• Create backups and restore databases.
• Minimize 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, and apply new patches and versions when required.
• Write ad-hoc queries, create stored procedures, functions, and views.
• Establish ODBC connections between different types of databases and platforms.
• Develop and maintain dashboards and reports to support 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 developers on projects to assist with database structure and relationships.

Job 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.
• 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.
• 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.