Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowPosted 67 days ago

ETL Lead

Delan Associates, Inc451 open roles

Where
Greenville, South Carolina, United States
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowETL LeadDelan Associates, Inc · Greenville, South Carolina, United States

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Delan Associates, Inc's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

8.5% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 1.8%1 day
  2. 4.0%3 days
  3. 8.5%7 days
  4. 15.4%14 days
  5. 34.1%30 days
This job: posted 67 days ago

The posting

Job Tittle: ETL Lead | Insurance Domain

Job Location: Green Ville , SC (Onsite)

Duration : 6+ Months contract

Visa: USC and GC

Years of Exp: 12+

Key Responsibilities

Production Support, Operations & Reliability

The ETL Team Lead owns end-to-end operational support for Canal’s existing data stack:

Ensure success of day-to-day production Operations.

Monitor daily ETL loads across SQL jobs, DHIC (GW Data Hub and Info Center) and legacy SSIS packages.

Work with AMS team where necessary to troubleshoot pipeline failures, performance issues, schema mismatches, permissions issues, and cloud resource failures.

Work with AMS team where necessary to perform root-cause analysis and to implement permanent fixes.

Ensure SLA adherence and on-time delivery of critical reporting datasets for scheduled ETL jobs .

Provide direction for both AMS and ETL Developers for Legacy & Current ETL maintenance.

Refactor or retire outdated or redundant ETL processes.

Maintain and improve existing pipelines that utilize the following technologies:

Microsoft SQL Server Database programming

T-SQL Scripting

SQL Server Integration Services

Microsoft PowerShell

Guidewire Data Hub and Info Center

Oracle Database programming

Oracle PL-SQL Scripting

SAP BODS (SAP BusinessObjects Data Services)

PostgreSQL Scripting

Operational Excellence

Work with AMS team to assist with the creation and/or enhancement of operational runbooks, SOPs, monitoring dashboards, and incident response workflows.

Partner with other IT operational segments, business SMEs, and AMS team to minimize downtime and to ensure that business SLAs are met.

Improve upon existing, as well as implement new proactive for daily processing.

Business Continuity

Work with AMS team to ensure development support coverage for critical data pipelines (rotation-based).

Support month-end and quarter-end financial reporting cycles.

Coordinate production releases and validate deployments.

The ETL Tech Lead will become the steady-state technical owner of the entire data operations layer during the Canal modernization journey.

Technical Leadership & Collaboration

Serve as technical lead guiding onshore/offshore developers.

Review code, enforce best practices, and mentor junior engineers.

Partner with Scrum Masters, Project Mangers, Enterprise Architecture, QA Automation, Change Management, and AMS support teams.

Data Ingestion, ETL/ELT Development & Optimization

Develop reusable ingestion patterns for Guidewire DataHub and InfoCenter, HubSpot, Telematics, and other facets of the business.

Work with Canal Architects to modernize existing ETL workloads using Delta Lake, Medallion Architecture, and Fabric Lakehouse.

Build scalable data ingestion pipelines using potential upcoming technology (Azure Data Factory, MS Fabric , Databricks, Synapse Pipelines, etc.).

Work to bring in Internal and External integrations data into the platform.

Real-Time, Streaming & Event-Driven Engineering

Proven experience designing and implementing real-time data pipelines using Event Hub, Fabric Real-Time Analytics, Databricks Structured Streaming, and KQL-based event processing.

Develop and enable real-time operational insights and automation capabilities—including Telematics alerting, FNOL automation, and fraud/VNOS/VNOP detection—through event-driven architectures and streaming analytics.

Modern Azure Data Stack Leadership

Lead the strategy, design, and engineering of Canal’s modern Azure data ecosystem using next-generation tools and Medallion Architecture, including:

Implementing Medallion Architecture (Bronze/Silver/Gold) across Fabric Lakehouse, Warehouse, Eventhouse, and KQL Database.

Leveraging Delta tables with schema enforcement, ACID compliance, and versioning.

Building ingestion and transformation pipelines using Dataflows Gen2, Fabric Pipelines, and Notebook-based ETL.

Enabling real-time analytics using RTA, EventStreams, and Event Hub.

Driving notebook-based transformations and advanced engineering using Databricks and Synapse runtimes.

Data Modeling, Curation & Governance

Develop curated, analytics-ready datasets to support Power BI, operational reporting, and advanced analytics use cases.

Assist Canal architect with implementation of Data Governance tools.

Establish robust data quality, validation, alerting, and observability frameworks to maintain accuracy, consistency, and trust in enterprise data.

AI/ML Data Enablement (Optional)

Prepare ML-ready datasets for pricing, risk, fraud detection, underwriting, claims leakage, and predictive insights

From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Delan Associates, Inc's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Delan Associates, Inc's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Delan Associates, Inc's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.