Data Integration Engineer

See what you can do with Prophix

Finance teams across 100+ countries use Prophix One™ to replace manual processes with intelligent planning, reporting, and automation. We are a globally connected team with deep UK roots and we are growing. If you are looking for a role where your work reaches customers across industries and borders, and where the people around you are invested in doing great work, this is worth reading.

We have teams and offices across the UK, Europe, North America, and Australia. Trusted by more than 3,000 finance teams across 100+ countries, Prophix One™ is built for organisations that want to plan smarter and move faster.

As a Data Integration Engineer, you will contribute to connecting clients’ ERP and financial systems with Prophix to unlock the full potential of their data. Working closely with Professional Services and cross-functional teams, 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. You will gain practical experience working with ERP systems, secure data pipelines, and scalable integration architecture. You will primarily work on well‑defined integration tasks, gradually building toward more complex problem‑solving and solution design. You will also gain practical experience working with ERP systems, secure data pipelines, and scalable integration architecture while being supported by experienced team members through mentorship and collaboration.

This is a permanent, full‑time position, open to candidates based at commutable distance from our Paddington office in London or fully remote within the UK.

• Integration Development:
  Build and support integrations between client ERP/accounting systems (e.g., Net Suite, Sage Intacct, D365, SAP, Sun Systems) 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.

We hire for potential as much as experience. If this role excites you but you don’t check every box, we still want to hear from you. At Prophix, people who ask good questions, adapt quickly, and bring a fresh perspective often make the biggest impact.

• Degree in Computer Science, Engineering, Data, or related field (or equivalent practical experience).
• Experience with SQL and relational databases.
• Familiarity with REST APIs and JSON.
• Programming knowledge in JavaScript, or a similar scripting language.
• Basic understanding of ETL concepts.
• Strong analytical thinking and attention to detail.
• Must have the right to work in the UK
• Comfortable using AI tools responsibly to support tasks such as research, drafting, and data review
• Able to learn new tools and adapt as technology and workflows evolve.
• Curious, open to new approaches, and motivated to continuously improve.
• Collaborative mindset when working across teams and with AI supported tooling.

• Exposure to ERP or accounting systems.
• Experience working with financial datasets (GL, trial balance, transactions, dimensions).
• Familiarity with API authentication methods (OAuth 2.0, tokens).
• Exposure to cloud platforms such as AWS or Azure.
• Understanding of integration design patterns or data flow architecture.
• Interest or experience in contributing to solution design discussions for client integrations.

• 30 days:
  You know our platform, our customers, and how your team operates. You’ve completed onboarding and are contributing to live work.
• 90 days:
  You’re working independently,…