ETL Team Lead

The Jacobson Group

United States

Hybrid

USD 120.000 - 135.000

Vollzeit

14 Tage+

Eine vollständige Bewerbung in einer Minute

Maßgeschneiderter Lebenslauf und Anschreiben – versandbereit.

Schaffe es an den ATS-Filtern vorbei

Benefits dieser Stelle

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

Zusammenfassung

The Jacobson Group is seeking an ETL Team Lead to provide technical leadership for data operations, production support and modernization in a hybrid role within the United States.

You will oversee the reliability of existing data pipelines, advance a modern Azure data ecosystem using Delta Lake, Medallion Architecture and Fabric Lakehouse technologies, and guide onshore/offshore developers while mentoring junior engineers.

Qualifikationen

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

Aufgaben

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

Kenntnisse

ETL team leadership
SQL Server & T-SQL
SSIS
PowerShell
Guidewire DataHub & InfoCenter
Oracle PL-SQL
SAP BODS
PostgreSQL
Azure data technologies
Delta Lake & Medallion Architecture
Real-time data pipelines
Data modeling & governance
Mentoring developers

Tools

SQL Server
SSIS
Azure Data Factory
Databricks
Synapse
KQL
PowerShell
Guidewire DataHub
InfoCenter
Oracle
SAP BODS
PostgreSQL

Jobbeschreibung

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.

Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

ETL Manager
ETL Manager

Godshall Recruiting • Greenville (SC)

Vor Ort
USD 120.000 - 140.000
Basic Life Insurance
Medical, Dental, & Vision
Annual Bonus
+5
ETL Team Lead - Real-Time Azure Data Pipelines
ETL Team Lead - Real-Time Azure Data Pipelines

The Jacobson Group • USA

Hybrid
USD 120.000 - 135.000
Medical insurance
Dental insurance
Vision insurance
+1
Data Engineer
Data Engineer

Randstad USA • Atlanta (GA)

Vor Ort
USD 76.000 - 85.000
Medical benefits
Dental benefits
Vision benefits
+3
ETL Tech Lead: DataOps & Azure Modernization
ETL Tech Lead: DataOps & Azure Modernization

Delan Associates, Inc. • Greenville (SC)

Vor Ort
USD 120.000 - 150.000
ETL Lead
ETL Lead

Delan Associates, Inc. • Greenville (SC)

Vor Ort
USD 120.000 - 150.000
Data Engineer
Data Engineer

TG Administration LLC • Scottsdale (AZ)

Vor Ort
USD 95.000 - 130.000
Healthcare Benefits
Retirement Benefits
Time Off
Senior ETL Developer / Senior Data Engineer (Azure & SQL)
Senior ETL Developer / Senior Data Engineer (Azure & SQL)

Ethereum Technologies LLC • Brecksville (OH)

Vor Ort
USD 89.000 - 126.000
Senior ETL Developer / Senior Data Engineer (Azure & SQL)
Senior ETL Developer / Senior Data Engineer (Azure & SQL)

Robotic Process Automation LLC • Brecksville (OH)

Vor Ort
USD 89.000 - 126.000
Data Integration Engineer
Data Integration Engineer

Red Arch Solutions, Inc. • Reston (VA)

Vor Ort
USD 160.000 - 185.000
Health insurance
401K with company match
Performance bonus
+3
Data Engineering Solutions Lead
Data Engineering Solutions Lead

The Friedkin Group • Houston (TX)

Vor Ort
USD 150.000 - 210.000