Talent.com
Datawind Consulting Inc.
Data Engineer TesterDatawind Consulting Inc. • Ottawa, Ontario, Canada
Data Engineer Tester

Data Engineer Tester

Datawind Consulting Inc. • Ottawa, Ontario, Canada
30+ days ago
Job type
  • Full-time
  • Quick Apply
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 OpportunityDatawind 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 LineThe 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 RequirementsPrior 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 ExpensesTravel 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 ApplyQualified 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.
Create a job alert for this search

Data Engineer Tester • Ottawa, Ontario, Canada

Similar jobs

Senior Data & Analytics Engineer

WagepointOttawa, ON, CA
Full-time

Senior Data & Analytics Engineer.This range is provided by Wagepoint.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.At Wagepoint, we’re good pe... Show more

 • Promoted

Data Team Lead / Data Architect (MongoDB, Redshift, Glue) B2B SaaS

Confidential CompanyOttawa, ON, CA
Full-time +1

Get AI-powered advice on this job and more exclusive features.This range is provided by Confidential Company.Your actual pay will be based on your skills and experience — talk with your recruiter t... Show more

 • Promoted

Full-stack Data Engineer (Remote)

Chord StrategyOttawa, ON, CA
Remote
Full-time

The Battle of Giants exists to answer a simple but important question:.Will a company’s strategy lead to growth?.We do this to help investors and corporate execs assess a company’s growth potential... Show more

 • Promoted

Senior Data Engineer: Build Scalable Data Platform for ML

MyprosperaOttawa, ON, CA
Full-time

A wealth management technology firm is seeking a Senior Data Engineer to architect and build data infrastructure from scratch.The role requires 5+ years of experience in cloud data warehouses, espe... Show more

 • Promoted

Remote AI Data Quality & Evaluation Engineer

Veeva SystemsOttawa, ON, CA
Remote
Full-time

A leading cloud technology company in Toronto is seeking an experienced professional to validate and ensure the reliability of Veeva AI Agents.The ideal candidate should have expertise in data qual... Show more

 • Promoted

Senior Staff Software Engineer, Data Delivery

StackAdaptottawa, on, Canada
Full-time

StackAdapt is the leading technology company that empowers marketers to reach, engage, and convert audiences with precision.With 465 billion automated optimizations per second, the AI‑powered Stack... Show more

 • Promoted

Remote Backend Data Engineer – Lakeflow & Lakehouse

Buchanan TechnologiesOttawa, ON, CA
Remote
Permanent +1

A Canadian tech company is seeking an experienced Backend Data Engineer for a 6-month contract, focusing on designing and maintaining data pipelines using Lakeflow architectures.The role is remote ... Show more

 • Promoted

Staff Software Engineer: AI-Powered Data Platform Architect

AlphaSenseOttawa, ON, CA
Full-time

A leading market intelligence firm in Canada is seeking an experienced individual to own the architecture of a large-scale data extraction platform.The role involves designing high-reliability syst... Show more

 • Promoted

Platform Engineer

RealmOttawa, Ontario, Canada
Full-time

This range is provided by Realm.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from Realm.Our client is a well-fu... Show more

 • Promoted

Senior Data Engineer (Remote)

Lumenaltaottawa, on, Canada
Remote
Full-time

We help global enterprises launch digital products that reach millions of users.Our projects involve massive datasets, complex pipelines, and real-world impact across industries.We continuously mee... Show more

 • Promoted

Backend Data Engineer – Lakeflow & Job Development

Buchanan TechnologiesOttawa, ON, CA
Full-time

Backend Data Engineer – Lakeflow & Job Development.Contract – 6 months and for possible extensions.Canadian Citizen/Permanent Resident only.The Backend Data Engineer is responsible for designing, b... Show more

 • Promoted

Remote Data Engineer Role at HIVERY

HiveryOttawa, ON, CA
Remote
Full-time

Enhance your career as a Data Engineer with HIVERY, focusing on advanced AI tools in a remote setting.Your expertise in Python or Go will drive improvements in our retail solutions.HIVERY, a startu... Show more

 • Promoted

Remote Data Engineer for Cyber Security & AI Pipelines

Coalition, Inc.Ottawa, ON, CA
Remote
Full-time

A leading cybersecurity company in Canada is seeking a Data Engineer to develop and manage a data platform for Cyber Security operations.This role involves designing robust data models, building sc... Show more

 • Promoted

Test Data Engineer (TDM)

YochanaOttawa, ON, CA
Full-time

Test Data Management (TDM) plays a key role in sourcing the right data with every changing need to ensure software testing is done effectively.Test data administration is the process of creating no... Show more

 • Promoted

Data Engineer: Snowflake Pipelines & Power BI (Hybrid)

SynechronOttawa, ON, CA
Full-time

Une entreprise de conseil numérique recherche un spécialiste pour migrer des données vers Snowflake, impliquerait la conception de pipelines de données et l'écriture de scripts Python.Les candidats... Show more

 • Promoted

Data Engineer

DS Technologies IncOttawa, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.About US: We are a company that provides innovative, transformative IT services and solutions.We are passionate about helping our clien... Show more

 • Promoted

Senior Data Engineer in Microsoft Fabric

BDO CanadaOttawa, ON, CA
Full-time

Shape the future of our data architecture as a Senior Data Engineer specializing in Microsoft Fabric.This vital role focuses on data ingestion, modeling, and reporting for our new platform.You will... Show more

 • Promoted

Lead Full-Stack Data Engineer — ETL & Insights

Chord StrategyOttawa, ON, CA
Full-time

A dynamic growth strategy consultancy in Metro Vancouver is seeking a Data Engineer to improve and maintain ETL processes.The ideal candidate is a leader comfortable with ambiguity and able to work... Show more

 • Promoted

Data Engineer Tester

Datawind Consulting Inc.Ottawa, ON, CA
Full-time

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 th... Show more

 • Promoted

Senior Engineer for Data Solutions at Confluent

ConfluentOttawa, ON, CA
Full-time

Contribute to revolutionary data management solutions at Confluent as a Senior Engineer.In this role, you will enhance Kora, the next-gen cloud-native event streaming platform focused on real-time ... Show more