Job Description

JSI Telecom is looking for a full-time Data Platform Tester. A Data Platform Tester is responsible for the quality, reliability and performance of data storage, transformation and retrieval in JSI's product suite.



You will be testing complex, cutting-edge software that uses a wide variety of technologies, which offers you the opportunity to develop your technical and testing skills on the job. You will collaborate with other testers, developers, product owners, and managers to deliver an excellent product that meets and exceeds customer expectations. JSI is looking for enthusiastic individuals who actively seek opportunities to grow and develop.

Responsibilities:

At JSI, your responsibilities may include: Define test cases for data ingestion, transformation, storage, and retrieval Ensure data integrity, accuracy, and consistency across systems. Validate ETL/ELT processes and data pipelines. Write and execute complex SQL queries to verify business logic and data correctness. Test stored procedures, triggers, views, and functions. Assess query performance and system scalability under various loads. Identify bottlenecks in data processing and retrieval. Verify data access controls, encryption, and compliance Performing exploratory testing and executing defined test cases on pre- and post-release software to prove that: + Features satisfy or exceed explicit and implicit requirements
+ The product delivers an excellent user experience
+ The features integrate with the product suite
Designing and writing test cases and test plans as part of feature and regression test suites Working with the automation team to determine which tests can and should be automated Independently troubleshooting and investigating issues that arise Executing long-running tests on pre- and post-release software to prove:

+ The absence of edge condition failures and memory leaks
+ The supportability of the product
Identifying defects and managing those defects through a bug tracking system (Azure) Partnering with development teams to reproduce defect scenarios and identify root causes Working with other members of the test team to: + Participate in regression testing
+ Prioritize areas for soak testing
+ Give feedback on feature testing shortfalls
+ Provide peer review for other testers
Running and analyzing automated tests
Participating in feature development and planning meetings as a representative from the test team
Advocating for quality

The ideal candidate:

Advanced knowledge of SQL (joins, subqueries, window functions, CTEs). Experience with different RDBMS (e.g., SQL Server, PostgreSQL, Oracle). Familiarity with platforms like Databricks, Snowflake, Delta Lake, or Apache Iceberg. Understanding of how lakehouses combine data lakes and warehouses. Experience with tools like Apache NiFi, Informatica, Talend, or Azure Data Factory. Knowledge of star/snowflake schemas, normalization, and dimensional modeling. Strong problem-solving skills to identify data anomalies and root causes. Experience with a variety of test techniques and practices Knowledge of non-functional requirements, including performance, stability, supportability, extensibility etc. Able to understand how a given defect or feature connects to and affects the overall product Ideally, has working knowledge of at least some of the following: + VMWare
+ Kubernetes
+ Helm
+ Checkmk
+ Agile
+ Test Driven Development (TDD)
Has some experience writing automated tests (beyond record/playback)
Loves testing and is really good at it - testing is your Plan A career, not Plan B
Has a strong understanding of software development life cycle, testing and testing tools Has a technical mindset, for example: + Uses AI for efficiency and productivity in daily tasks
+ Experienced with scripting or programming
+ Experienced with API's
+ Experienced with system configuration and networking
+ Experienced with data collection and management
Thinks like a tester + Technical
+ Creative
+ Critical
+ Practical
Advocates for quality + Speaks up to ask questions and raise concerns
+ Knows when to escalate concerns to management
Is thorough, meticulous and detail-oriented
Has good time management and is able to prioritize tasks

Is satisfied by solving problems, not just the symptoms
Has a tremendous desire and capacity to learn and actively seeks opportunities for growth Is adaptable to new environments, tools and processes Can independently troubleshoot and investigate issues that arise

Requirements

Live in the Ottawa area and be available to work in office at least 2 days per week
Strong verbal and written communication skills in English

Eligible for top secret security clearance:
+ No criminal activity
+ No criminal record
+ Ten years of verifiable history
University or College graduate or equivalent experience Experience in Software Quality Assurance or related field

How We Work

You will be expected to work in a remote/hybrid environment reporting to our Kanata, Ontario location 2 or more times per week.

About JSI

JSI is built on purpose, that of making a difference in the world.



Founded in 1979, this privately-owned technology company is the North American leader in designing and developing acquisition, collection and analysis solutions for law enforcement and intelligence communities.



With 4Sight - JSI's single, unified, product suite - customers can combine any number of disparate data sources into a highly intuitive, visually-focused platform. The result? JSI's customers spend less time working with data and more time seeing patterns, understanding trends, and gaining perspective (and making the world a safer place).



With over 400 employees and a strong, growing global presence in Canada, the U.S., Australia and Germany, JSI is not only the dominant player in its industry, it is also known for its fun, high-performing, purpose-driven corporate culture.



In accordance with the Accessibility for Ontarians with Disabilities Act (AODA), JSI will provide accommodation accessible formats and communication supports for the interview process upon request.