Lead Data Integration & Engineering Tech

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 Tech Lead will serve as a hands-on expert responsible for overseeing the design, development, and deployment of ETL pipelines, SOL-based data solutions, and integration services.

In addition to deep technical involvement, this position will provide technical leadership and mentorship to a team of onshore and offshore developers, guiding them on best practices, architecture standards, and effective problem-solving strategies.
Reporting to the Data Services Manager, the Tech Lead will play a key role in fostering collaboration, ensuring code quality, removing delivery obstacles, and enhancing the team's capacity to deliver critical solutions in a timely and efficient manner.

This is an opportunity to shape data engineering efforts and influence the technological direction of our data ecosystem.

Key Responsibilities

1.

Act as a liaison between technical staff and stakeholders, translating business requirements into efficient, scalable solutions.
2.

Build and maintain robust, scalable SSIS packages incorporating third-party plugins, transformations, slowly changing dimensions, and advanced logic.
3.

Collaborate with project sponsors, OBA, testing, DevOps, business analysts, and senior leadership to ensure robust testing, Cl/CD automation, and smooth production deployments using Git and Azure pipelines.
4.

Define and enforce best practices in data engineering, ETL design, and code versioning.
5.

Design and implement complex workflows, expressions, queries, and data validations, ensuring appropriate error handling and system alerting.
6.

Design and optimize relational database objects (tables, stored procedures, views, indexes, functions) using T-SQL.
7.

Develop and manage end-to-end integrations using SSIS, Azure Data Factory, REST APls, SFTP, JSON, and flat file exchanges.
8.

Drive process improvements, automation opportunities, and system performance optimizations.
9.

Ensure data accuracy, integrity, and security across all stages of the integration lifecycle.
10.

Integrate with internal and external APls for data exchange, including authentication, error handling, and transformation logic.
11.

Lead a team of onshore and offshore developers, p...