Automation Engineer

Overview

The Tyndale Company is seeking a skilled Automation Engineer to join the team. This Engineer is responsible for developing, maintaining, and optimizing ETL workflows, automation scripts, and scheduled jobs to support the seamless flow of data across business systems, including a custom ERP platform. This role requires strong skills in SQL Server, SSIS, PowerShell scripting, and enterprise job scheduling, with a focus on performance, reliability, and operational visibility. The Automation Engineer works closely with Business Data Engineers, DBAs, SREs , and other IT teams to ensure backend processes run efficiently and securely.

HYBRID / REMOTE :  Tyndale supports a strong work-life balance. This opportunity requires onsite work a minimum of 1 day per week, and 4 days per week remotely. To be considered, candidates must reside within a commutable distance from our corporate headquarters in Pipersville, PA (Bucks County).

About Tyndale

The Tyndale Company is a private, 9x Top Workplace winner in PA and 4x winner in TX, and an industry leading national supplier of arc-rated flame-resistant clothing (FRC) to the energy sector – including utilities, oil and gas, transportation, chemical manufacturing, and NFPA 70E markets. We’re a family-owned business providing a retail-style apparel experience to hundreds of thousands of energy workers across the US and Canada. We’re the leading distributor of innovative FRC solutions, and the largest industrial supplier of Carhartt FR, Ariat FR, and Wrangler FR clothing.

Responsibilities

• Create and maintain PowerShell scripts to automate routine tasks, system integrations, data movement, and alerting workflows.
• Setup and migration of new ETL pipeline to replace legacy system
• Manage and monitor job scheduling through JAMS, including designing job chains, setting dependencies, and configuring schedules for high reliability.
• Build and optimize ETL workflows using SSIS and T-SQL for data extraction, transformation, and loading across internal systems.
• Proactively monitor jobs, handle errors and escalations, and tune performance for automation and ETL pipelines.
• Maintain clear documentation for automation scripts, job schedules, error handling routines, and system integration points.
• Identify opportunities to reduce manual effort through scripting, job chaining, and workflow orchestration enhancements.
• Ensure job execution and data movement are logged and traceable, supporting internal controls and audit readiness.

Qualifications

Benefits

#LI-SP1 #LI-Hybrid