Data Integration Engineer

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., * 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., * 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, owning deliverables end to end, and building relationships across functions and regions.
• 6 months: Your fingerprints are on something real. You’ve improved a process, shipped something meaningful, or earned a seat at the table on a decision that matters., * Hybrid set-up from our Paddington office or fully remote with flexible working hours
• Private medical insurance through Vitality including mental health support and talking therapies
• Income protection at 75% of earnings and death in service at 3x salary
• NEST pension with 3% employer contribution
• 25 days of annual leave, 10 sick / personal days on full pay, and 1 volunteer day
• Total Wellness Benefit of £550/year
• Professional development support and financial assistance for learning
• Opportunities to participate in Environmental, Social, and Governance (ESG) initiatives
• Quarterly Town Halls and Kickoffs that bring teams together to celebrate wins, share updates, and look ahead at what’s next

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., 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.

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., Joining Prophix in the UK means working as part of a genuinely global team with colleagues across Europe, North America, and Australia who bring different perspectives and work on shared problems. You’ll build breadth: cross functional experience, international exposure, and direct access to customers in a range of industries. We invest in learning and development, support flexible and hybrid working, and give people real ownership from day one. Our values are Pursue Excellence, Build with Purpose, Create Wins for All, and Drive Continuous Innovation. These shape how we work, not just what we say.