Test Engineer II

JOB DESCRIPTION

As a 100% employee-owned contractor, when you work at Sundt, you're not just hiring on at a company, you're joining a culture.

Because everyone at Sundt is part owner, you'll join a team of people who are deeply invested in their work.

From apprentices to managers, we're passionate about the details and deliberate in everything we do.

At Sundt we focus on building long-term prosperity for our clients, communities, and employee-owners.

We offer competitive pay, industry-leading benefits including a 401k and employee stock ownership plan, incentive programs for craft and administrative employees as well as training that focuses on your personal and professional growth.

We're driven by skill, grit and purpose.

Join us as we strive to be the most skilled builder in America.

Job Summary

The Test Engineer will be responsible for both manual testing and automated validation solutions to ensure the integrity of data pipelines and transformations.

This role requires extensive experience in Databricks, Azure Data Factory, and SSIS and a deep understanding of data quality frameworks and tooling.

The successful candidate will be accountable for implementing and maintaining data quality tools, troubleshooting data discrepancies, and enhancing data governance practices.

In addition to technical testing responsibilities, this role will work closely with business users leading User Acceptance Testing (UAT) efforts.

The Test Engineer will be responsible for coordinating and leading UAT meetings, ensuring that stakeholders understand data validation processes, and guiding them through testing activities.

Key Responsibilities

1.

Collaborate with business users to support UAT testing activities, gather feedback, and document findings.
2.

Conduct SOL-based testing to compare source and target datasets, identify discrepancies, and resolve issues.
3.

Conduct performance and load testing on ETL pipelines to ensure scalability and efficiency.
4.

Design, execute, and automate data testing strategies for ETL and data pipeline validation.
5.

Document defects, data anomalies, and test results, providing clear reports to development teams.
6.

Ensure compliance with data governance policies and best practices.
7.

Lead UAT meetings, coordinating test plans, issue tracking, and resolution efforts.
8.

Monitor and test data ingestion, transformation, and storage across cloud and on-prem environments.
9.

Perform both manual data validation and build automated testing solutions for structured and semi- structured data.
10.

Take ownership of data quality tooling, including configuration, monitoring, and enhancements.
11.

Utilize Python, PowerShell, or Bash to develop automated test scripts where applicable.
12.

Validate and troubleshoot data flows in Databricks, ADF, and SSIS, ensuring accuracy, completeness, and consistency.
13.

Work with data engineers to enhance testing automation frameworks and Cl/CD integration.

Minimum Job Requirements

1.

5+ years of...