Data Integration Engineer
Prophix is hiring a Data Integration Engineer to design, build, and maintain integrations connecting client data sources to its Prophix One financial performance platform, including supporting client migrations from on-premise to AWS cloud. Core stack: RESTful APIs with JSON, SQL/Python/JavaScript, Windows/SQL Server, and AWS.
- Compensation
- CA$80K–CA$95K / yr
- Location
- Canada
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Software engineering
- Posted
Skills
Must have
- Degree or diploma in Computer Science, Software Engineering, or a related technical field
- 3-5 years hands-on experience designing, developing, and deploying data integrations across cloud and on-premise systems
- 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/programming languages such as JavaScript, Python, SQL, or SOQL
- Familiarity with Windows and/or SQL Server environments
- Experience working with AWS or comparable cloud infrastructure for data connectivity or migration
- Legal entitlement to work in Canada, ability to travel internationally, and a valid passport
Nice to have
- Hands-on experience with SnapLogic or Java web services for application integration
- Knowledge of financial concepts such as planning, budgeting, forecasting, or consolidation
- Experience managing concurrent client-facing project engagements, including estimating effort
- Familiarity with data security practices, networking concepts, or large-scale data storage design in cloud environments
- Comfortable using AI tools responsibly for research, drafting, and data review
Full 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
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.
Integration Strategy and Architecture
- Contribute to integration strategy, architecture, and framework decisions, proposing automation options that increase efficiency and simplify connectivity across multiple platforms.
- Create and apply programming standards and techniques to ensure integrations are reusable, consistent, and maintainable.