Data Integration Engineer

Prophix; Toronto; Hybrid; CAD 80,000 - 95,000; Full time

Benefits offered by this job

Health benefits

RRSP matching

Parental leave

Wellness allowance

Generous PTO

Job summary

Prophix is seeking a Data Integration Engineer to join the Professional Services team. You will design and implement data connections between client sources and the Prophix platform, enabling secure, scalable data flows across cloud and on-prem environments.

Collaborate with engineers and consultants to optimize integrations, build real-time interfaces, and shape the integration strategy while mentoring teammates and advancing enterprise-level data connectivity.

Qualifications

• 3-5 years of software design and development experience.
• 3-5+ years in data integration across disparate platforms.
• Experience creating reusable, standard APIs for real-time integration.
• Fluent in RESTful web services using JSON.
• Scripting languages such as JavaScript.
• Experience interfacing data between Cloud and on-prem applications and data stores.
• Familiar with Java, Python, SQL or SOQL.
• Ability to work with AI tools to support tasks like research or data review.

Responsibilities

• Design, develop, test, deploy, maintain and enhance data connections following best practices.
• Manage project priorities, deadlines, and deliverables.
• Provide day-to-day support and technical guidance to engineers and stakeholders.
• Propose architecture and automation options to streamline integrations.
• Lead IT alignment by representing the integration team to IT and business.

Skills

Software design

Data integration

RESTful APIs

JSON

JavaScript

Cloud & on-prem

AI tools familiarity

Education

CS degree or related field

Tools

SnapLogic

Java web services

Job description

See What You Can Do With Prophix

Prophix helps finance teams work with greater flexibility and confidence through Prophix One™, our Financial Performance Platform. We bring planning, reporting, and automation together so people can focus on higher-value work instead of repetitive tasks. As we introduce more AI-enabled capabilities, you will be part of a human-centered innovation journey where intelligent tools support better outcomes while people lead the decisions that matter.
We're headquartered in the Greater Toronto Area, with teams and offices across North America, Europe, and Australia.
A Prophix Data Integration Engineer enables seamless, automated connections between client data sources and the Prophix platform. Working on the Professional Services team and with Consultants, this role focuses on integrating, exploring, and optimizing customer data to support critical business solutions. The position plays a key role in helping customers transition from on-premise environments to cloud-based systems, ensuring secure, scalable, and efficient data flows. Amazon Web Services (AWS) is at the forefront of this cloud transformation, and a critical piece of this puzzle is data.
Leveraging strong technical expertise, the engineer designs and builds reliable data integrations across cloud and on-premise systems, including real-time interfaces. They contribute to integration strategy and architecture while collaborating with technical and business stakeholders to deliver effective solutions. This role requires a strong foundation in data systems, cloud technologies, have a background in Windows and/or SQL Server, and API best practices to support enterprise-level data connectivity. A successful candidate will bring fresh ideas on things like information retrieval, large-scale data design, networking and data storage, and security.

What You Will Do

• Design, develop, test, deploy, maintain, and enhance data connections utilizing Integration Best Practices
• Manage individual projects priorities, deadlines, and deliverables
• Provide day to day support and technical expertise to other engineers, project owners and stakeholders
• Provide strategy, architecture, design and automation options to increase efficiency and simplify integration across multiple platforms
• Provide IT leadership by representing the integration team to IT and the business
• Mentor other team members
• Build real-time interfaces between systems
• Design and build reliable processes
• Participate in developing integration strategy, architecture, and frameworks for the organization
• Create and enforce programming standards and techniques across the organization
• Connect Prophix's Cloud environment to the many other environments that our customers bring

What You Will Bring

If this role excites you but you don't meet every requirement, we still encourage you to apply. At Prophix, curiosity, adaptability, and diverse perspectives matter. Your experience may be exactly what we need.

Required Qualifications

• 3-5 years of related experience in software design and development
• 3-5 or more years working with integration of data across disparate platforms and applications;
• Demonstrated experience creating reusable, standard APIs for real-time integration
• Fluent in RESTFul web services using JSON
• Experience with scripting languages, JavaScript is preferred
• Experienced in interfacing data between a mix of Cloud and on Prem applications and data stores
• Familiar with Java, Python, SQL or SOQL
• Comfort using AI tools responsibly to support tasks such as research, drafting, or data review
• Ability to learn new tools and adapt as technology evolves
• Collaborative mindset when working with teams and technology
• Must be legally entitled to work in the country where the role is located. Must be able to travel to the United States, Canada and/or internationally, and have a valid passport

Preferred Qualifications

• Successful completion of a Post-Secondary Degree in Computer Science or related field
• Experienced in Snaplogic and/or Java web services for integration between applications a plus
• Academic or practical knowledge of Accounting and/or Financial concepts (i.e. planning, budgeting, forecasting, or consolidation) is preferred
• Ability to function productively on multiple project teams simultaneously
• Ability to work independently without any supervision
• Experienced working in a high paced environment and ability to work effectively under pressure/stressful conditions to meet tight deadlines
• Ability to work well in a team and interact effectively, including the ability to mentor and provide leadership to other team members
• Ability to provide a level of effort estimates and to perform tasks within the estimated level of effort and schedule
• Excellent oral and written communications skills

What Success Looks Like

• 30 days: You understand our tools, product, and people
• Within 90 days: You work independently on meaningful tasks
• Within 6 months: You contribute ideas, improvements, and measurable impact

Why Join Prophix?

Prophix builds technology that helps organizations plan, forecast, and make better decisions through Prophix One™, our Financial Performance Platform. You'll work with colleagues and customers across multiple regions, contribute to a platform used by thousands of organizations, and help advance our AI-enabled capabilities that support smarter, more human-centred work. You'll also have opportunities to grow your skills, learn modern tools, and collaborate with leaders who value continuous improvement.
We offer flexibility depending on team needs and employee location, and our work is anchored in our values: Pursue Excellence, Build with Purpose, Create Wins for All, and Drive Continuous Innovation.

What's Included for You?

• Comprehensive health, dental, vision, and mental-health coverage
• Retirement savings with employer contributions
• Parental leave top-up
• Annual wellness allowance
• Generous paid time off including vacation and sick time
• Social events, team activities, and opportunities to build community
• 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

Compensation

The total target compensation for this role is $80,000 CAD to $95,000 CAD, in accordance with applicable pay transparency laws in Canada and the United States. Actual compensation will be determined based on factors such as skills, experience, location, and internal equity.

Accessibility & AI Transparency

Prophix promotes an accessible hiring process. If you need accommodation at any stage, we'll work with you. Some interviews may be recorded so our hiring team can review and assess responses fairly and consistently. As part of our commitment to Responsible AI, we use a small number of AI-supported tools to help with tasks like resume review, shortlisting, or creating interview summaries. AI is never used as the sole basis for hiring decisions, and your personal data is never used to train AI models. If you'd prefer not to take part in any AI-assisted step, just let us know and we'll be happy to accommodate.