Software Developer in test (Data Platform)

Having recognized the advantages of remote work, including employee morale, productivity, reduced commuting on employee wellbeing and the environment, we are proud to be a digital-first company. The technologies and programs in which we invested have provided a fantastic foundation to this end. Our digital-first work environment, together with our conveniently located offices and collaborative workspaces, provide our team with the freedom and flexibility to work in the way that makes our employees most productive.

Tecsys is a fast-growing innovator offering supply chain solutions to industry leading healthcare systems, hospitals, and pharmacy businesses to distributors, retailers, and 3PLs. We work with industry leaders to transform their supply chains through technology. If you thrive on tackling interesting challenges with continuous learning opportunities, then Tescys could be a good fit for you!

We are looking for a Software Developer in Test (Data Platform) to join our TecsysIQ Data & AI team. This role is focused on ensuring the quality, reliability, and integrity of our cloud-based data platform built on AWS and Databricks.

Unlike traditional QA roles, this position is centered on data pipelines, transformations, and business rule validation across Bronze, Silver, and Gold layers.

A key expectation of this role is to embed automated testing as part of the development lifecycle. For every feature or transformation developed, you will help define and build the automated tests upfront—ensuring they can be reused continuously during development and later as part of regression testing.

The goal is to establish a test-first, automation-driven culture, where automated validation provides fast feedback on data quality and stability, while manual testing complements this with edge case validation and exploratory testing.

You will work closely with Data Engineers, Product Owners, and Business Stakeholders to ensure that all delivered data products meet business expectations with high quality and consistency.

• Actively participate as a member of an agile data platform team
• Collaborate with Data Engineers and Product Owners to define test strategies alongside feature development
• Design and implement automated test cases upfront for new pipelines and transformations
• Build and maintain automated regression testing frameworks for data pipelines
• Ensure automated tests are reusable across development cycles and integrated into regression suites
• Validate end-to-end data pipelines from Bronze to Silver and Gold
• Integrate automated tests into CI/CD pipelines to enable continuous validation
• Design and implement data observability checks, including:
• Data freshness
• Schema drift detection
• Volume validation
• Metric anomaly detection
• Ensure downstream semantic layers, metrics, and BI dashboards remain consistent after changes
• Perform impact analysis when transformation logic evolves
• Write SQL and Python-based validation scripts
• Identify data quality issues, root causes, and gaps in transformation logic
• Contribute to best practices for test automation, data quality, and observability
• Complement automated testing with manual testing for edge cases, exploratory scenarios, and creative validation.
• Support release validation and production verification

• 5+ years of experience as a Software Developer in Test or QA Engineer

• Strong experience with automated testing frameworks and regression testing
• Experience testing data pipelines, transformations, or analytics platforms
• Advanced SQL skills and strong understanding of data modeling
• Experience with Databricks (DLT, streaming, batch processing)
• Experience translating business requirements into automated test scenarios
• Experience with Python or similar scripting languages
• Familiarity with CI/CD pipelines and automated test execution
• Strong analytical and problem-solving skills
• Excellent collaboration and communication skills.
• Strong English communication skills, both written and spoken, are essential for effective correspondence with customers, business partners and colleagues beyond the province of Quebec. 

Nice to Have

• Experience with CDC and streaming validation
• Experience with data quality or observability frameworks
• Experience validating BI dashboards (Cognos, Power BI, etc.)
• Knowledge of supply chain or healthcare data domains
• Experience working in cloud environments (AWS preferred)

What Gives You an Edge

• Experience building test-first or automation-first development practices
• Experience integrating automated testing into large-scale data platforms
• Exposure to modern data engineering ecosystems and SaaS environments

We understand that experience comes in many forms and that careers are not always linear. If you don't meet every requirement in this posting, we still encourage you to apply.

At Tecsys, we are committed to fostering a diverse and inclusive workplace where all employees feel valued, respected, and empowered. We believe that diversity drives innovation and strengthens our ability to deliver exceptional solutions. We welcome and encourage applicants from all backgrounds, experiences, and perspectives to join our team.

Tecsys is an equal opportunity employer. Accommodation is available for applicants selected for an interview.

NB: if you are applying to this position, you must be a Canadian Citizen or a Permanent Resident of Canada, OR, have a valid Canadian work permit.

***

A Note on Our Hiring Process: We do not use AI to automatically screen or reject candidates. However, we do use specific screening questions to prioritize the most relevant applications for human review.
At Tecsys, we welcome the thoughtful use of AI tools to help you prepare your application, for example, to improve clarity, organize your resume, or practice interview responses. However, we ask that all information you provide reflects your real experience, and that any assessments or written submissions represent your own work and thinking.

During interviews, we expect candidates to engage without the use of AI tools, scripts, or real-time assistance. Authentic, direct conversation helps us get to know how you think, collaborate, and communicate. AI can support your preparation, but it shouldn’t speak or act on your behalf. We genuinely want to meet you.