SQL Developer

MAP Human Capital Management; Remote; ZAR 300 000 - 400 000; Full time

Job summary

A leading recruitment consultancy is seeking a Senior SQL & Data Integration Engineer. This fully remote position requires accountability for SQL-based data pipelines within a municipal ERP context, ensuring data accuracy and performance across various modules. Candidates must have 5–8+ years of SQL development experience and a strong understanding of BI integration and municipal finance systems. Apply via LinkedIn, or send your CV to [e-mail] with 'SQL Developer' in the subject line.

Qualifications

• 5–8+ years hands-on SQL development experience.
• Advanced SQL expertise including complex joins and window functions.
• Experience supporting audit-sensitive reporting environments.

Responsibilities

• Ensure data integrity, performance, and governance of SQL pipelines.
• Design and optimise SQL queries over large datasets.
• Collaborate with BI developers to ensure alignment between technical logic and finance definitions.

Skills

SQL development

Data warehousing

Business Intelligence (BI) integration

Complex SQL queries

Execution plan analysis

Job description

Senior SQL & Data Integration Engineer

Municipal ERP & Finance Focus

This role is a senior, hands-on technical position responsible for the integrity, performance, and governance of all SQL-based data pipelines feeding the Business Intelligence (BI) environment within a municipal ERP context. The incumbent is accountable for ensuring that data extracted from municipal transactional systems is accurate, performant, auditable, and consistently represented across BI dashboards and statutory reports.

This role is explicitly aligned to municipal finance and ERP environments, including General Ledger, Billing, Payroll, Supply Chain Management, Asset Management, and Budgeting modules. Experience in municipal finance, MFMA-aligned reporting, and audit-driven data environments is a strong advantage.

Reporting & Accountability

Direct reporting line: Head of BI Development

Functional accountability: Head of Business Intelligence

Role Outcomes

• Trusted BI figures aligned with municipal ERP source systems
• Accurate financial and operational reporting suitable for management, council, and audit use
• Optimised SQL queries supporting high-volume municipal data
• Standardised and governed data models across ERP modules

Municipal ERP Data Ownership

• Take full ownership of SQL queries, views, stored procedures, and transformations feeding BI from municipal ERP systems
• Ensure consistent interpretation of municipal finance data across BI
• Reconcile BI outputs to ERP modules including but not limited to the General ledger, Billing, Payroll, SCM, Assets, and Budget
• Investigate variances impacting financial statements, management reports, and council packs
• Support audit queries with traceable data lineage and evidence

SQL Engineering & Performance

• Design and optimise complex SQL queries over large municipal datasets
• Analyse execution plans and address performance bottlenecks
• Implement indexing and optimisation strategies appropriate to ERP workloads
• Support both warehouse-based and live-query BI models
• Ensure BI refresh cycles and dashboards meet operational and executive SLAs

Data Architecture & Governance

• Design and maintain staging, transformation, and presentation layers for municipal ERP data
• Decide which data should be materialised versus queried live based on performance and audit risk
• Eliminate duplicated calculation logic across BI assets
• Implement control totals, validation rules, and reconciliation frameworks
• Document data models, SQL logic, and ERP dependencies

Stakeholder & Audit Engagement

• Work closely with BI developers to ensure alignment between technical logic and municipal finance definitions
• Collaborate with ERP application teams when source logic or structures change
• Act as the primary escalation point for BI data discrepancies impacting decision-making

Required Experience & Skills

• 5–8+ years hands-on SQL development experience
• Advanced SQL expertise including complex joins, window functions, CTEs, and execution plan analysis
• Strong data warehousing and BI integration experience
• Demonstrated experience working with ERP or financial systems
• Experience supporting audit-sensitive reporting environments

Advantageous Experience

• Municipal ERP systems experience
• Municipal finance exposure (GL, Budget, Billing, SCM, Payroll, Assets)
• Understanding of MFMA-aligned reporting and audit processes
• Experience with large, highly normalised transactional databases

Personal Attributes

• Strong sense of ownership for data correctness
• Comfortable operating under audit and finance scrutiny
• Detail-oriented with a strong control mindset
• Able to challenge assumptions and push back on incorrect data interpretations
• Disciplined approach to documentation and standards

Other

• This role is fully remote, work from anywhere in South Africa (occasional travel to the Western Cape may be required).
• Only open to South African citizens
• Please apply via LinkedIn, or send your CV to [e-mail] (SQL Developer in Subject Line)