ETL Team Lead

Seeking an ETL Team Lead to provide technical leadership for data operations, production support, ETL development and modernization. This hybrid role will oversee the reliability of existing data pipelines while helping advance a modern Azure data ecosystem using scalable ingestion, streaming analytics, Medallion Architecture and Fabric Lakehouse technologies., * Monitor daily ETL loads across SQL jobs, Guidewire DataHub and InfoCenter environments and legacy SSIS packages.

• Troubleshoot pipeline failures, performance issues, schema mismatches, permissions issues and cloud resource failures with the AMS team.
• Perform root-cause analysis and implement permanent fixes while ensuring SLA adherence and on-time delivery of critical reporting datasets.
• Maintain and improve pipelines using Microsoft SQL Server, T-SQL, SQL Server Integration Services, Microsoft PowerShell, Oracle, SAP BODS and PostgreSQL.
• Create or enhance operational runbooks, standard operating procedures, monitoring dashboards and incident response workflows.
• Coordinate production releases, validate deployments and support month-end and quarter-end financial reporting cycles.
• Guide onshore and offshore developers, review code, enforce best practices and mentor junior engineers.
• Develop reusable ingestion patterns and scalable pipelines for Guidewire DataHub and InfoCenter, HubSpot, Telematics and other business data.
• Modernize ETL workloads using Delta Lake, Medallion Architecture, Fabric Lakehouse, Azure Data Factory, Microsoft Fabric, Databricks and Synapse Pipelines.
• Design and implement real-time data pipelines using Event Hub, Fabric Real-Time Analytics, Databricks Structured Streaming and KQL-based event processing.
• Develop curated datasets for Power BI, operational reporting and advanced analytics while establishing data quality, validation, alerting and observability frameworks.

• ETL team leadership experience
• Microsoft SQL Server database programming
• T-SQL scripting
• SQL Server Integration Services
• Microsoft PowerShell
• Guidewire DataHub and InfoCenter
• Oracle database programming and PL-SQL scripting
• SAP BODS and PostgreSQL scripting
• Azure data technologies and modern data architecture
• Real-time data pipelines and streaming analytics
• Data modeling, curation and governance
• Experience guiding developers and collaborating with cross-functional teams

Pay Range:

The anticipated pay range for this position is per $120,000 to $135,000 with an 8% bonus. We understand salary is an important factor in a job search, and we encourage you to apply even if you feel that your desired compensation may fall outside of the listed range. The final pay for this position is determined based on several factors including but not limited to, relevant experience, skills and certifications, education and training, geographic location, market conditions, and internal equity. We are committed to finding the right candidate for this role and are open to discussing how your unique qualifications align with our needs.

• Medical insurance
• Dental insurance
• Vision insurance
• 401(k) retirement savings plan