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

Expert Data Engineer with Datatonic

DatatonicOttawa, ON, CA
Full-time

Elevate your career as a Senior Data Engineer at Datatonic, focusing on scalable data solutions within a remote work environment.Utilize your knowledge of cloud technologies to drive significant cl... Show more

 • Promoted

Data Engineer Role in Alberta’s Digital Division

PathlionOttawa, ON, CA
Full-time

Be part of Alberta's digital transformation as a Data Engineer.Contribute to innovative projects by creating data pipelines and deriving insights that meet the needs of citizens.As a core member of... 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

Lead Data Engineer Innovating Healthcare Data Architecture

Synthesis HealthOttawa, ON, CA
Full-time

Drive data engineering excellence as a Staff Data Engineer and help transform healthcare data practices.Spearhead architecture optimizations and educate teams in a fully remote role.As a leader in ... 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

Data Engineer

BorrowellOttawa, ON, CA
Full-time

At Borrowell, we're on a mission to help Canadians feel confident about their money.We empower individuals to take control of their financial futures by providing the tools and insights needed to u... Show more

 • Promoted

Senior Data Engineer — Remote Canada (Snowflake DW)

Infostrux Solutions Inc.Ottawa, ON, CA
Remote
Full-time

A leading data consultancy in Canada seeks a Senior Data Engineer to guide customers in building cloud-based data warehouses using Snowflake.The role involves data ingestion, transformation, and op... Show more

 • Promoted

Full Stack Engineer - Data Quality

Right Balance ®Ottawa, ON, CA
Full-time

Full Stack Engineer - Data Quality.Headquartered in Los Angeles, California, Right Balance provides top-tier technology talent for innovative companies in the US.We’re in the top 50 companies to wa... 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

Senior Databricks Platform Engineer, Data + AI (18-month Term)

KinaxisOttawa, ON, CA
Full-time

Are you looking to join an innovative, market-leading company where you can truly elevate your career? At Kinaxis we are serious about culture, we are serious about technology, we are serious about... Show more

 • Promoted

Goodway Group Data Engineer Position

Goodway GroupOttawa, ON, CA
Full-time

Become a Senior Data Engineer at Goodway Group and shape the future of data solutions.Collaborate in a remote-first environment while empowering analytics and driving business outcomes.Goodway Grou... Show more

 • Promoted

Senior AI Data Engineer

Scribd, Inc.Ottawa, ON, CA
Full-time

Our four products — Scribd®, Slideshare®, Everand™, and Fable — help billions of people across the globe move beyond access and into insight, application, and expertise.The Data Platform team sits ... 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

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 (Remote)

LumenaltaOttawa, ON, CA
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

Full-Stack Data Quality Engineer - Remote Canada

Right Balance ®Ottawa, ON, CA
Remote
Full-time

A leading tech talent provider is seeking a Full Stack Engineer - Data Quality to join a client focused on AI-driven competitive intelligence.The role involves ensuring data accuracy and collaborat... Show more

 • Promoted

Senior Data Engineer – Spark, Airflow, AWS (Remote Quebec)

GoToOttawa, ON, CA
Remote
Full-time

A leading remote work technology company seeks a Senior Software Developer to work on complex data processing and software releases.The ideal candidate will have hands-on expertise in Spark, Airflo... Show more