Senior AI Test Automation Engineer

Senior Test Automation Engineer

Pure Facts Financial Solutions Toronto, Ontario, Canada

Pure Facts is the leader in the Revenue Performance Management category for wealth and asset management firms. The Pure Revenue™ Platform helps organizations maximize revenue potential by connecting pricing, billing, compensation, advisor behavior, and AI-powered intelligence within a single Revenue Book of Record. By transforming fragmented revenue processes into a coordinated growth system, firms gain greater visibility, stronger pricing discipline, improved revenue capture, and more effective advisor alignment.

The result is faster organic growth, improved profitability, and increased enterprise value. For more than 25 years, Pure Facts has helped leading financial institutions turn revenue from an operational process into a strategic advantage.

At Pure Facts, we are building an AI-native platform and company. We embed AI, intelligent automation, and agentic workflows across our products and operations to detect anomalies, surface insights, streamline repetitive work, and support faster, better decision-making. In a highly regulated industry, we believe AI must be practical, governed, and auditable—amplifying human expertise while helping our teams and clients focus on higher-value, strategic work.

We are seeking a highly skilled and self-motivated Senior Test Automation Engineer to join our Quality Engineering team. The ideal candidate will have extensive experience in test automation, database validation, AI-assisted testing, and modern quality engineering practices. This role requires expertise in building scalable automation frameworks, validating complex data migrations, and leveraging AI-enabled tools to improve productivity, accelerate testing cycles, enhance test coverage, and continuously improve software quality.

The successful candidate will play a key role in driving AI-powered quality engineering practices, championing innovation, and ensuring the effective use of AI technologies while maintaining high standards of quality, security, compliance, and reliability.

• Design, develop, and maintain scalable automation frameworks using Java, Python, and Playwright.
• Develop and execute automated functional, regression, integration, API, and end-to-end test suites.
• Perform comprehensive database testing, including data validation, data integrity, data consistency, and backend verification.
• Write and optimize complex SQL queries involving joins, subqueries, Common Table Expressions (CTEs), window functions, aggregates, and stored procedures to validate business rules and application data.
• Validate database transactions, triggers, stored procedures, views, functions, indexes, and constraints.
• Perform end-to-end validation of data across multiple databases and systems to ensure consistency and integrity.
• Validate ETL processes and data migration activities, ensuring accurate transformation, reconciliation, and completeness of migrated data.
• Perform source-to-target data validation for large-scale migration and integration projects.
• Create reusable SQL validation scripts to support automation and regression testing.
• Analyze database performance and identify data-related issues impacting application functionality.
• Validate data generated through APIs, batch jobs, scheduled processes, and background services.
• Perform backend testing by validating application data against business requirements.
• Execute performance, load, stress, security, and accessibility testing.
• Work with Snowflake to validate data, execute queries, verify data pipelines, and support reporting validation.
• Develop reusable automation utilities and testing libraries.
• Integrate automated tests into CI/CD pipelines to support continuous integration and continuous delivery.
• Utilize AI-assisted tools such as Microsoft Copilot, ChatGPT, Claude, Cursor, Git Hub Copilot, and similar technologies to accelerate test design, automation development, defect analysis, SQL generation, troubleshooting, documentation, and productivity improvements.
• Leverage Generative AI solutions to create,…