Data Engineer Tester

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 retest.
• 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:

Candidates must clearly demonstrate the following skills and experience:

• 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 workday.
• 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.

How to Apply

Qualified candidates are invited to submit a current resume, along with a brief summary of relevant Azure Databricks and ETL/data testing experience, to Datawind Consulting Inc.

Please reference "Data Engineer Tester – Ottawa" in the subject line of your application.