Lead Data Integration & Engineering Tech

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, providing technical guidance, peer reviews, and mentoring to ensure quality and performance standards are met.
12.    Lead the documentation of processes, configurations, and technical workflows to support knowledge sharing and team scaling.
13.    Monitor and resolve integration failures with root cause analysis and timely remediation.
14.    Participate in solution architecture planning and lead implementation strategies for complex integrations.
15.    Provide timely escalation and resolution of development and production issues.

Minimum Job Requirements

1.    7+ years of progressive experience in SQL development and ETL, with at least 2 years in a lead or senior role.
2.    Bachelor's degree in a related field or 10+ years of equivalent professional experience.
3.    Background in Agile/Scrum methodology and DevOps principles preferred.
4.    Excellent communication and stakeholder engagement skills.
5.    Experience with Azure Synapse, Azure SOL, or related cloud-based data platforms preferred.
6.    Familiarity with version control systems such as Git and branching strategies for team collaboration preferred.
7.    Highly self-motivated with exceptional attention to detail and problem-solving capabilities.
8.    Proficiency with Microsoft Office Suite and modern collaboration tools.
9.    Proven experience leading cross-functional, geographically distributed teams.
10.    Solid understanding of data integration best practices, SDLC methodologies, and Cl/CD workflows.
11.    Strong expertise in T-SQL, SSIS, SSRS, Azure Data Factory, REST APls, and JSON.

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 501bs 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

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