Data Architect

CaptivateIQ; Toronto; On-site; CAD 100,000 - 140,000; Full time

Job summary

A leading sales performance management company in Toronto is seeking a Data Architect to build and support integrations between their platform and external systems. The ideal candidate will have over 4 years of experience in integration, strong SQL skills, and the ability to clearly communicate technical concepts. This role emphasizes problem-solving and collaboration with clients and cross-functional teams to provide scalable solutions.

Benefits

Flexible vacation days

Annual stipends for professional development

Newest Apple products

Qualifications

• 4+ years of hands-on integration experience, including design and implementation.
• Strong SQL skills for writing efficient queries.
• Familiarity with REST APIs and semi-structured data formats.

Responsibilities

• Lead end-to-end implementation of integrations.
• Serve as a subject matter expert for integration escalations.
• Troubleshoot integrations directly with customers.

Skills

Integration experience

SQL

REST APIs

Scripting in Python or JavaScript

Clear communication

Problem-solving

Tools

ETL / ELT tools (e.g., Talend, Airbyte)

iPaaS platforms (e.g., Workato, Boomi)

Job description

Overview

Join CaptivateIQ as a Data Architect focused on building and supporting integrations between our platform and critical external systems. This is a customer-facing role centered on implementation, not core product or platform engineering. This position is ideal for someone who enjoys translating technical capabilities into practical solutions for real business problems.

You will work closely with clients and cross-functional teams to design, implement, and support scalable integration solutions. Ideal for someone who enjoys problem-solving, automation, and contributing to a growing, fast-paced services team.

Base pay range

100,000.00 / yr - $140,000.00 / yr

CaptivateIQ is the leading Sales Performance Management solution, recognized by Forrester and G2, and trusted by customers including Affirm, Gong, and Figma. With solutions for Sales Planning and Incentives, we help revenue teams automate processes, hit revenue targets, and adapt with business change, ultimately driving efficient growth. It\'s time to rethink ROI - your return on incentives - with CaptivateIQ. Backing from Sequoia, Accel, ICONIQ, Sapphire Ventures, and other leading investors supports our mission to enable every company to improve their return on incentives and sales planning.

Responsibilities

• Lead end-to-end implementation of advanced integrations, including scoping, buildout, and post-launch support
• Serve as a subject matter expert for integration escalations from Support, CS, and other CX teams
• Partner with Sales, Presales, Product, and Engineering on discovery, scoping, and continuous improvement
• Troubleshoot SSO, SCIM, and system-based integrations directly with customers
• Set up automations and native connectors as needed
• Contribute to documentation, knowledge-sharing, and scalable best practices
• Stay current with product changes, enhance internal tooling, and continuously improve delivery
• Script and automate manual workflows to drive repeatability and efficiency

Requirements

• 4+ years of hands-on integration experience, including design, implementation, support, or related technical work
• Strong SQL skills for writing efficient queries and managing table lifecycles
• Familiarity with REST APIs (auth, pagination, error handling, data integration)
• Experience with semi-structured data formats such as JSON and CSV
• Basic scripting ability in Python or JavaScript for automation and workflow support
• Clear, confident communicator able to explain technical concepts to diverse audiences
• Proactive, adaptable team player with a solution-oriented mindset and strong ownership

Nice to Have

• 1-2 years of experience in a customer-facing technical role (e.g., implementation, solutions engineering, professional services)
• Experience with ETL / ELT tools (e.g., Talend, Airbyte)
• Exposure to iPaaS platforms (e.g., Workato, Boomi)
• Familiarity with SSO, SCIM, and systems like Salesforce, NetSuite, Workday

Benefits

• US-ONLY) 100% of medical, dental, and vision covered including 75% for dependents
• Flexible vacation days and quarterly mental health days
• One-time expense on your 1-year work anniversary (for travel, home furnishings, etc.)
• Annual stipends for professional development and caretaking
• US-ONLY) 401k plan to participate in and save towards the future
• Newest Apple products to help you do your best work
• Employee Resource Groups (ERGs) to support and celebrate diverse communities

Notice for Prospective Candidates

• Only emails from @captivateiq.com should be trusted

The OTE range represents the minimum and maximum for this position across North America. The OTE offered for this position will depend on numerous factors, including individual proficiency, anticipated performance, and the location of the selected candidate. Our OTE is just one component of CaptivateIQ\'s competitive total rewards package.

J-18808-Ljbffr