ERP Data Architect & Automation Lead

Synergy Jobs (Pty) Ltd; Gauteng; On-site; ZAR 420,000 - 660,000; Full time

Job summary

Synergy Jobs (Pty) Ltd seeks a Data Specialist for a 6-month project in Johannesburg to own data architecture across systems, starting with the finance ERP. You will drive automation to replace manual capture, ensure data integrity, and connect ERP to Kiss flow, Salesforce, and Power BI.

You will design data structures for funds, cost centres, and reporting, while collaborating with the Finance ERP Manager and Microsoft Partner on the Business Central migration.

Qualifications

• Strong data architecture or data modelling background, ideally with ERP exposure.
• Documentation of data landscape with up-to-date architecture diagrams is mandatory.
• Hands-on experience building automation with Power Apps and Power Automate.
• Hands-on experience with Power BI and Microsoft Fabric.
• Experience integrating an ERP with adjacent business systems (CRM, procurement, payroll).
• Strong SQL proficiency and stakeholder management across departments.

Responsibilities

• Owns and maintains a data map of the organization’s data flow between systems (ERP, Kiss flow, Salesforce, ResRequest, TallOrder, Sage 300, Jet Reports, Power BI).
• Acts as custodian of the ERP’s financial data, guarding against manual-entry corruption and championing automation.
• Identifies manual data capture processes and assesses where automated capture should be implemented.
• Designs and builds automation using Power Apps and Power Automate to replace manual workflows.
• Designs and builds Power BI dashboards and reports in collaboration with the BI team.
• Builds ERP-integrated budget reporting with write-back capability (e.g., Velixo).
• Leads Phase 2 migration of Jet Reports functionality into Power BI; audits reports and defines rebuilds.
• Leads data-integration design for Business Central integrations (Kiss flow, Salesforce, etc.).
• Designs approach to historical data retention using data lake options rather than a live legacy system.
• Develops training materials and dashboards to help operational users understand data quality and use.
• Collaborates with in-house BI team and Finance for data governance.

Skills

Data architecture

Data modelling

SQL

Stakeholder management

Automation mindset

Data integration

Tools

Power BI

Power Apps

Power Automate

Velixo

Microsoft Fabric

Salesforce

Job description

Synergy Jobs (Pty) Ltd seeks a Data Specialist for a 6-month project in Johannesburg to own data architecture across systems, starting with the finance ERP. You will drive automation to replace manual capture, ensure data integrity, and connect ERP to Kiss flow, Salesforce, and Power BI.

You will design data structures for funds, cost centres, and reporting, while collaborating with the Finance ERP Manager and Microsoft Partner on the Business Central migration.