As a Data Integration Engineer at Prophix, you will contribute to connecting clients’ ERP and financial systems with Prophix to unlock the full potential of their data. You will help design, build, and maintain integration solutions that automate the retrieval, transformation, and delivery of financial data. This is a hands-on technical role focused on API integrations, SQL-based data processing, cloud-hosted environments, and financial data workflows.
What You'll Do
- Integration Development: Build and support integrations between client ERP/accounting systems (e.g., NetSuite, Sage Intacct, D365, SAP, SunSystems) and Prophix.
- API Integration: Develop and enhance REST and SOAP API connections using JavaScript-based scripting.
- Data Processing & ETL: Write SQL queries to transform, validate, and stage financial data in relational databases (MySQL/PostgreSQL).
- Cloud & File Integrations: Support secure SFTP workflows and cloud storage integrations (AWS/Azure).
- Troubleshooting & Optimization: Investigate integration issues, reconcile data discrepancies, and improve reliability and performance.
- Collaboration & Documentation: Document integration logic and contribute to improving internal best practices.
What We're Looking For
- Proven experience in integration development, particularly between financial/ERP systems.
- Strong proficiency with REST and SOAP APIs and JavaScript-based scripting.
- Strong proficiency in SQL and experience with relational databases like MySQL or PostgreSQL.
- Hands-on experience with secure file transfer protocols (SFTP) and cloud platforms (AWS, Azure).
- Experience troubleshooting data integration issues, reconciling discrepancies, and optimizing performance.
- Excellent documentation skills and a collaborative approach to improving team practices.
Technical Stack
REST API, SOAP API, JavaScript, SQL, MySQL, PostgreSQL, SFTP, AWS, Azure, NetSuite, Sage Intacct, D365, SAP, SunSystems
Team & Environment
Working closely with Professional Services and cross-functional teams. Our culture is one where people guide each decision with clarity and purpose, and you will be supported by experienced team members through mentorship and collaboration.
Work Mode
This is a hybrid role based in Lisbon or Brussels. Fully remote work within the respective country is an option.
