Senior Developer: SQL and Reporting (Western Cape)

BDO

Location
Port Elizabeth, Western Cape
Work model
Hybrid
Minimum qualification
Diploma
Closing date

First listed . Last checked at source .

In brief

Overview This role is for a Junior Business Advisor within the Service Charge team at BDO Wave, located in Cape Town (Cape Town CBD). BDO Wave is a South Africa-based extended delivery team that supports BDO UK, operating as an integrated, cross-border team to deliver high-quality work. The Service Charge team is a specialized centre of excellence focused on performing independent reviews and agreed-upon procedures for service charge accounts across various property types, including commercial, residential, and mixed-use developments/estates. What you will do As a Junior Business Advisor, you will work as part of a dedicated team, supporting more experienced team members and assisting in the timely delivery of services to clients. You will build on your experience, participate in more complex tasks, and work closely with real estate clients. You will also gain an understanding of reporting engagements and accountancy guidance provided by real estate bodies. Key responsibilities include: * Preparation of Service Charge Accounts in line with the agreed scope of work. * Reviewing, concluding on, and resolving client responses to audit queries and adjustments. * Following up on outstanding matters via email or as required, escalating to Managers when necessary. * Preparation of accountants’ reports. * Preparation of client required schedules, including both internal documents and those to be issued with draft reports. * Liaising with clients as needed, addressing issues that may arise, and escalating to senior/manager as required. Requirements (from the original advert) **Education and Skills:** * Relevant tertiary qualification (bachelor’s degree in accounting or financial management or Internal Auditing) **Experience:** * 0-2 years’ experience **Skills & Competencies:** * Ability to meet tight deadlines and work well under pressure * Excellent communication skills * Excellent command of English, both written and spoken * Quality & Detail Orientated * Team player * Proficiency in Microsoft Office with specific reference to Excel and Word * Excellent problem-solving abilities * Willingness to learn and develop. Who should apply This role is suitable for candidates with a relevant bachelor's degree in accounting, financial management, or internal auditing, and 0-2 years of professional experience. The ideal candidate will be able to manage tight deadlines and work effectively under pressure, possess excellent written and spoken English communication skills, and demonstrate a quality and detail-oriented approach. Applicants should be team players, proficient in Microsoft Office (especially Excel and Word), have excellent problem-solving abilities, and show a strong willingness to learn and develop within the role. Deadline Not specified Reference Original posting: https://www.myjobmag.co.za/job/bdo-wave-junior-business-advisor-service-charge-cape-town-cape-town-cbd-bdo-south-africa Source: myjobmag

Summary drafted with AI assistance from the original advert. The advert itself is the authority — how we use AI.

At a glance

  • At least 3 years of experience.
  • Python
  • SQL
  • Azure
  • Power BI
  • Microsoft Excel

Extracted automatically from the advert; confirm requirements on the original listing.

Job description

Primary Purpose of the Job * We are hiring a meticulous data professional to fulfil a hybrid role that combines SQL development, report creation, and data engineering. This role is accountable for designing and managing robust data pipelines, developing and tuning SQL queries, and building and maintaining the enterprise data warehouse. The candidate will also produce high‑quality reports and dashboards, translating data into clear, actionable insights that enable informed business decisions across the organization. Main Duties and Responsibilities * Design, develop, and optimize complex SQL queries, stored procedures, functions, and scripts. * Ensure that all database systems are maintained and enhanced to meet the organisation's requirements for data integrity, security, and availability. * Create and restore databases * Monitor database performance, implement changes, apply new patches and versions when required * Create Server agent jobs * Build, manage and support data warehousing solution and contribute to the development of data models. * Ability to establish ODBC connections between different types of databases and platforms * Create linked servers. * Create data integrations with various servers and datasets. * Develop and maintain operational, financial, and ad-hoc reports using SQL-based reporting tools (e.g., SSRS, Power BI) * Ensure data accuracy and consistency in all reports and dashboards. * Design and implement data pipelines and ETL processes for integrating data from various sources. * Work with large datasets, ensuring data reliability, consistency, and scalability. * 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 * Familiarity with cloud platforms (e.g., Azure) Competencies: Technical & Behavioural Technical Competencies * Excellent knowledge of data backup, recovery, security, integrity, and SQL. * Experience in Crystal reports or similar business intelligence tools * Solid understanding of ETL processes, data warehousing concepts, and data modelling. 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 * Excellent communication and documentation abilities. BDO Core Competencies * Relationships and Collaboration * Exceptional Client Service * Business Growth * Engaging people * Leadership * Quality, Risk management and Operational performance

Before you apply

  • Confirm the requirements and closing date on the original listing (myjobmag). SPANi lists vacancies from other sites and may not reflect last-minute changes.
  • Legitimate employers do not charge application, registration or training fees.
  • Don't send your ID or bank details before you have confirmed the employer is real.

Also listed on: myjobmag, myjobmag, myjobmag, myjobmag.

How to spot a job scam

Before you apply

  • Read the full advert and confirm you meet the minimum requirements before applying.
  • Tailor your CV headline and most recent experience to the job title and key skills.
  • Note the closing date and reference number, and keep a copy of what you submit.
  • Apply only through the employer or job board link — never pay to apply.

Similar roles

PermanentIT & Software

Mobile Solutions Architect

iLaunchWestern Cape

Oversee the current delivery, evaluate the existing code and lead the strategic transition of internal processes Design next generation of mobile platform, shifting toward a modern cross-platform framework Design and execute the roadmap to move development from the vendor to an in house team

Get new it & software jobs in western cape by email

Free. No account needed. Unsubscribe with one click.

We only use your email to send this alert. See our privacy policy.