ETL Team Lead

Job Description:

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.

Responsibilities:

• 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.

Requirements:

• 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.

Benefits:

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

Equal Opportunity Employer:

The Jacobson Group is committed to fostering an inclusive and equitable workplace that reflects the diverse communities we serve. We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other protected characteristic as defined by applicable law. We believe that diversity of thought, background and experience strengthens our team and drives innovation. All employment decisions are based on qualifications, merit and business needs. If you require a reasonable accommodation to complete the application process or participate in an interview, please contact us at HR@jacobsonsgroup.com or +1 (800) 466-1578 to make a request.

Contact:

Troy Andrew tandrew@jacobsongroup.com

Refer a Colleague:

Do you know someone who would be interested in this project? Submit your referral directly by emailing the Jacobson contact listed above or submitting them through this form. If your referral is hired for a contract assignment and meets all other eligibility criteria, you will receive a referral bonus!