Software Developer in test (Data Platform)
About The Position
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.
Requirements
- 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 Haves
- 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)
- 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
Responsibilities
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
