Test Engineer II (Finance)
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 experience in data testing, ETL testing, or data quality assurance.
2. Experience leading UAT efforts, coordinating with business users, and ensuring smooth execution.
3. Experience with Azure Data Factory (ADF) and SSIS for ETL workflows.
4. Experience with Python, PowerShell, or Bash for automated testing preferred.
5. Experience with cloud data platforms (Azure, AWS, GCP) and cloud-based testing methodologies.
6. Experience with manual data validation and automating test scenarios.
7. Familiarity with Azure Synapse, Power Bl, and big data technologies preferred.
8. Ownership of data quality tooling and experience configuring, managing, and optimizing these tools.
9. Proficiency in SOL with experience writing complex queries for data validation.
10. Strong analytical and problem-solving skills with keen attention to detail.
11. Strong expertise in Databricks with hands-on experience in data validation and transformation testing.
12. Strong understanding of data governance, data lineage, and metadata management.
13. Understanding of Agile and DevOps methodologies in a data engineering environment preferred.
Note: Job Description is subject to change at any time and may include other duties as assigned.
Physical Requirements
1. May stoop, kneel, or bend, on an occasional basis
2. Must be able to comply with all safety standards and procedures
3. Required to use hands to grasp, lift, handle, carry or feel objects on a frequent basis
4. Will interact with people and technology frequently during a shift/work day
5. Will lift, push or pull objects up to 50Ibs on an occasional basis.
6. Will sit, stand or walk short distances for up to the entire duration of a shift/work day.
7. Will use telephone, computer system, email, and other electronic devices on a frequent basis to communicate with internal and external customers or vendors
Safety Level
Non-Safety Sensitive
Note: Jobs with the Safety-Sensitive designation are those that include tasks or duties that the employer reasonably believes could affect the safety and health of the employee performing the task or others such as operating a vehicle, operating equipment, operating machinery or power tools, repairing/maintaining the operation of any vehicle/equipment, the handling/disposal/transport of hazardous materials, or the handling/treatment/disposal of potentially flammable/combustible materials.
Equal Opportunity Employer Statement: Sundt is committed to the equal treatment of all employees, and/or applicants for employment, and prohibits discrimination based on race, religion, sex (including pregnancy), sexual orientation, gender identity, color, age, disability, national origin, covered veteran status, genetic information; or any other classification protected by applicable Federal, state, or local laws.
Benefit list:
Market Competitive Salary (paid weekly)
Bonus Eligibility based on company, group, and individual performance
Employee Stock Ownership Plan & 401K
Industry Leading Health Coverage Starting Your First Day
Flexible Time Off (FTO)
Medical, Health Savings, and Wellness credits
Flexible Spending Accounts
Employee Assistance Program
Workplace Wellness Programs
Mental Health Program
Life and Disability Insurance
Employee-Owner Perks
Educational Assistance
Sundt Foundation - Charitable Employee-Owner's program
