Talent.com
SQL Database and Reporting Analyst - (PERMANENT)

SQL Database and Reporting Analyst - (PERMANENT)

PM ConnectionWorkFromHome, Gauteng, South Africa
13 days ago
Job description

Overview

Our client is seeking to hire a SQL Database and Reporting Analyst to ensure the stability, security, and performance of the SQL database environment while driving data analysis to support informed decision-making. This hybrid role combines database administration with data analytics, requiring strong technical proficiency in SQL Server management, data modelling, and visualisation, along with excellent analytical and problem-solving skills. The successful candidate will play a critical role in maintaining data integrity and delivering actionable insights to stakeholders across the business.

Responsibilities

  • SQL Database Administration
  • Install, configure, and maintain SQL Server databases to ensure optimal performance, availability, and security.
  • Monitor database performance and implement tuning, indexing, and optimisation strategies.
  • Manage database backup, recovery, high availability, and disaster recovery solutions.
  • Implement and maintain database security policies, access control, and compliance measures.
  • Collaborate with development teams to support database design, deployment, and integration.
  • Maintain accurate documentation of database configurations, standards, and procedures.
  • Data Analysis and Reporting
  • Extract, transform, and analyse data from multiple sources to deliver accurate insights.
  • Develop and maintain SQL queries, reports, and dashboards to support business requirements.
  • Conduct trend analysis and data interpretation to identify patterns, risks, and opportunities.
  • Support stakeholders with ad hoc data requests, ensuring accuracy and clarity.
  • Ensure data quality, integrity, and consistency across systems and processes.
  • Use BI and visualisation tools (Power BI, Tableau, SSRS, SSIS, etc.) to create and present dashboards and reports.

Stakeholder Collaboration

  • Partner with business units to understand data needs and translate them into technical solutions.
  • Present insights and recommendations in a clear, business-friendly manner.
  • Provide technical support and training to users for accessing and interpreting reports.

    • Key Skills and Competencies

  • Advanced SQL and data analysis skills with attention to detail.
  • Strong analytical and problem-solving ability.
  • Ability to translate complex data into meaningful insights for business stakeholders.
  • Excellent communication and presentation skills, both written and verbal.
  • Strong organisational and time management skills with the ability to manage competing priorities.
  • Ability to work independently as well as collaboratively in a team environment.
  • Proactive, adaptable, and solution-driven approach.

    • Qualifications

  • Matric
  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Statistics, or a related field.
  • Minimum 3 years’ experience in SQL Server administration and data analysis.
  • Strong proficiency in T-SQL, SQL Server Management Studio (SSMS), and database optimisation.
  • Experience with BI and data visualisation tools such as Power BI, Tableau, SSRS, and SSIS.
  • Knowledge of ETL processes, data modelling, and data governance frameworks.
  • Familiarity with SSAS is advantageous.
  • Previous experience in fintech, , or payments industry is desirable.

    • Kindly regard your application as unsuccessful if you have not heard from the agency within 2 weeks.

    #J-18808-Ljbffr

    Create a job alert for this search

    Reporting Analyst • WorkFromHome, Gauteng, South Africa