Data Integration Engineer

Prophix • Etobicoke, ON

4h • CA$80,000 - CA$110,000

About The Position

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.

Requirements

• 3+ years SQL data programming experience using Microsoft Transact-SQL, MySQL, PL/SQL or similar.
• 3+ years experience working with databases such as Microsoft SQL, Oracle, MySQL, Snowflake etc.
• 2+ years experience with RESTFul web services, APIs, and JSON.
• Fluent in at least one scripting language such as JavaScript.
• Experience integrating data from a mix of cloud and on-prem applications.
• Familiarity with data integration development best practices.
• Knowledge of OLAP.
• Comfort using AI tools responsibly to support tasks such as research, drafting, or data review.
• 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.

Nice To Haves

• Successful completion of a Post-Secondary Degree in Computer Science or related field
• 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

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree