Data Integration SQL Engineer (Toronto)

Data Integration SQL Engineer (Toronto)

08 Nov
|
Prophix
|
Toronto

08 Nov

Prophix

Toronto

Prophix helps finance teams work with greater flexibility and confidence through Prophix OneTM, 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.

Prophix helps finance teams work with greater flexibility and confidence through Prophix OneTM, 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.

Data Integration

Design and Development Design, develop, test, deploy, and maintain data integrations that connect client data sources to the Prophix platform,



applying integration best practices throughout. Build real-time interfaces between cloud and on-premise systems, including RESTful APIs using JSON, to support secure and scalable data flows.

Connect

Prophix's cloud environment (including AWS infrastructure) to the variety of source systems and data stores that customers bring, covering both cloud and on-premise applications. Create and apply programming standards and techniques to ensure integrations are reusable, consistent, and maintainable.

Client Project

Delivery and Stakeholder Support Manage individual project priorities, deadlines, and deliverables across concurrent client engagements. Provide day-to-day technical guidance to fellow engineers, project owners, and business stakeholders, representing the integration team in technical discussions. Support customers transitioning from on-premise environments to cloud-based systems, ensuring data flows remain reliable and secure throughout the migration.

Work closely with Professional Services Consultants and technical stakeholders to deliver effective integration solutions that meet client needs. Mentor other team members and contribute ideas in areas such as information retrieval, large-scale data design, data storage, networking, and security. Degree or diploma in Computer Science, Software Engineering, or a related technical field. ~3 to 5 years of hands-on experience designing, developing, and deploying data integrations across disparate platforms and applications, spanning both cloud and on-premise systems. ~ Demonstrated experience building RESTful APIs using JSON for real-time system integration. ~ Experience interfacing data between cloud and on-premise applications and data stores. ~ Working knowledge of scripting or programming languages such as Javascript, Python, SQL, or SOQL. ~ Familiarity with Windows and/or SQL Server environments as a foundation for data system work. ~ Experience working with AWS or comparable cloud infrastructure in the context of data connectivity or migration.



~ Legal entitlement to work in Canada, with the ability to travel internationally and a valid passport.

Hands-on experience with SnapLogic or Java web services for application integration. Practical or academic knowledge of financial concepts such as planning, budgeting, forecasting, or consolidation, relevant to working alongside finance-focused Professional Services teams.

Experience managing concurrent client-facing project engagements, including estimating effort and delivering within agreed timelines. Familiarity with data security practices, networking concepts, or large-scale data storage design in cloud environments. Comfortable using AI tools responsibly to support tasks such as research, drafting, and data review.

Prophix builds technology that helps organizations plan, forecast, and make better decisions through Prophix OneTM, 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-centered work. You'll also have opportunities to grow your skills, learn contemporary tools, and collaborate with leaders who value continuous improvement.

Comprehensive health, dental, vision, and mental-health coverage Retirement savings with employer contributions Parental leave top-up 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 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 If you need accommodation at any stage, we'll work with you.

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.

📌 Data Integration SQL Engineer (Toronto)
🏢 Prophix
📍 Toronto

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data integration sql engineer (toronto) / toronto

Subscribe to this job alert:

Get the latest job offers by email for: data integration sql engineer (toronto) / toronto