Data Engineer Tester

Datawind Consulting Inc.; Ottawa; On-site; CAD 80,000 - 100,000; Full time

Job summary

Datawind Consulting Inc. seeks a Data Engineer Tester in Ottawa to support data analytics initiatives. This full-time contract requires deep expertise in SQL and hands-on experience with Azure Databricks. Responsibilities include leading ETL testing activities, coordinating test strategies, and ensuring quality assurance standards. The ideal candidate should have at least 5 years of experience in software testing and familiarity with Azure environments. Hybrid work options are available.

Qualifications

• Minimum 5 years of experience writing test cases and test scripts.
• 5 years of experience in software testing for data transformation.
• At least 2 years of hands-on experience with Microsoft Azure data platform.
• Experience designing and implementing testing processes for software systems.

Responsibilities

• Lead, manage, and coordinate ETL/Data testing activities.
• Write and execute complex SQL‑based test scripts.
• Record test execution results in Azure DevOps.
• Collaborate with business stakeholders during User Acceptance Testing.

Skills

SQL

Azure Databricks

Data Warehouse Testing

Agile Methodology

Test Strategies

Business Intelligence

Tools

Azure DevOps

Microsoft Power BI

Azure Functions

Job description

About Datawind Consulting Inc.

Datawind Consulting Inc. is a Canadian consulting firm that places skilled data and technology professionals into high-impact contract engagements with leading enterprise clients across the country. We support our consultants throughout the engagement lifecycle, from contracting and onboarding through ongoing payroll, expense, and timesheet administration.

The Opportunity

Datawind Consulting Inc. is seeking an experienced Data Engineer Tester to support a strategic enterprise data analytics initiative for our client, a major Canadian organization headquartered in Ottawa. The successful candidate will lead ETL and data testing activities for an Employee Shift Scheduling Replacement program built on the Microsoft Azure data platform.

This is a long‑term, full‑time contract role suited to a senior tester with deep SQL skills, hands‑on Azure Databricks experience, and a strong background in data warehouse testing within an Agile environment.

Reporting Line

The contractor will report to the client's Manager, Business Intelligence and Data Management, and will work as a member of the data analytics project team.

Key Responsibilities

• Lead, manage, plan, and coordinate ETL/Data testing activities, including Test Strategies, Test Plans, Test Cases, and Test Scripts.
• Write and execute complex SQL‑based test scripts on the Azure Databricks platform for data warehouse and data engineering processes, based on documented data mapping and data transformation rules.
• Record test execution results and evidence of testing in Azure DevOps.
• Ensure test activities are planned and performed in accordance with the requirements and standards of the Test Center of Excellence.
• Coordinate and support business stakeholders through User Acceptance Testing.
• Lead defect triage meetings; document defects, partner with developers on resolution, and re‑test.
• Develop technical system specifications and standard operating procedure documents.
• Collaborate with, share knowledge, and mentor other members of the project team.
• Participate in team meetings to provide status reports on work in progress, accomplishments, and issues encountered.
• Participate in technical meetings with client staff and advise on technical option analyses based on leading practices.

Primary Deliverables

• ETL/data test deliverables: Test Strategies, Test Plans, Test Cases, and Test Scripts.
• SQL query‑based data transformation test scripts.
• Documented test results, defects, and execution result evidence.
• Weekly status reports covering work in progress, accomplishments, and issues encountered.

Mandatory Qualifications

• Minimum 5 years of experience writing test cases and test scripts based on documented data mapping and business data transformation rules.
• Minimum 5 years of experience with various types of software testing (functional, integration, system integration, performance, etc.) for data transformation processes.
• Minimum 2 years of hands‑on experience with the Microsoft Azure data platform: Azure Databricks, SQL Databases, and Azure Data Lake. Experience with additional programming languages (Scala, Python, R, SQL, Azure Functions) is considered an asset.
• Minimum 5 years of experience covering all of the following:
• Systems development experience across analysis, design, development, testing, and deployment of software systems.
• Implementation of batch and stream data processing pipelines.
• Writing complex SQL queries, performance tuning, and data optimization.
• Designing, developing, implementing, and testing data solutions for reporting applications such as Power BI.

Preferred Qualifications

• Experience working on large‑scale data analytics projects.
• Experience developing Microsoft Power BI reports and dashboards.
• Excellent verbal and written communication skills, with the ability to present clearly to both technical and non‑technical audiences and to provide updates at all levels of management.
• Experience with Agile sprint development using Azure DevOps.
• Experience working with spatial data (nice to have).

Work Arrangements

• Work will be performed at the client's head office located at Ottawa, ON, with a hybrid work arrangement available at the discretion of the project authority.
• Full‑time hours are required for this engagement, based on an 8.0‑hour work day.
• The contractor shall submit weekly timesheets identifying hours worked per day, to be approved by the Project Authority.

Security Requirements

Prior to the commencement of work, the successful contractor must be security screened in accordance with the end client's security policy. Candidates must be eligible to obtain and maintain the required clearance.

Travel and Expenses

Travel and any travel‑related expenses require prior authorization. Authorized travel will be reimbursed at actual cost, without mark‑up, in accordance with the end client's travel directive.