Auditing, Enterprise Resource Planning (ERP), Business Intelligence (BI), SQL, Finance, Infor Enterprise Resource Planning (ERP), Data Analytics, Analytics, Business, IT Integration
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
- 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
- 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
- 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
- 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
- 58+ 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
- 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
- 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
- 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 melanie@maphumancapital.co.za (SQL Developer in Subject Line)
