Senior ETL Dev Lead - Enterprise Data Warehouse - Insurance

TechDigital Group; Charlotte (NC); On-site; USD 120,000 - 180,000; Full time

Job summary

TechDigital Group seeks a veteran Data Architect to lead enterprise data warehouse design, data modeling and integration. You will collaborate with development teams to extract data from source applications and load it into a centralized warehouse, ensuring accuracy and performance.

The role requires deep Insurance/reinsurance domain experience, expertise with Guidewire applications, and strong SQL Server/DB2 skills to support analytics and reporting across teams.

Qualifications

• 10+ years in data architecture and design for enterprise data warehouses.
• 3+ years in Insurance and reinsurance domain.
• Advanced data extraction from Insurance applications.
• Experience with SQL Server, DB2 and other RDBMS.
• Knowledge of Guidewire applications (Policy Center and Claims Center).

Responsibilities

• Architect and design comprehensive enterprise data warehouse solutions sourcing data from multiple insurance systems.
• Design and implement source-to-target mappings for high-volume data integration.
• Create logical and physical data models and implement on SQL Server platforms.
• Develop SQL Server views for reporting and dashboard development.
• Tune SQL and Informatica mappings and stored procedures for performance.
• Lead data discovery sessions with business SMEs and support reporting teams.

Skills

Data architecture

ETL/BI architectures

Advanced data extraction

Insurance domain knowledge

Guidewire experience

SQL Server

DB2

Informatica

Data modeling

Semantic layer reporting

Tools

SQL Server

DB2

Informatica

Guidewire Policy Center

Guidewire Claims Center

SAP FS-CDSAP FI-GL

Job description

TechDigital Group seeks a veteran Data Architect to lead enterprise data warehouse design, data modeling and integration. You will collaborate with development teams to extract data from source applications and load it into a centralized warehouse, ensuring accuracy and performance.

The role requires deep Insurance/reinsurance domain experience, expertise with Guidewire applications, and strong SQL Server/DB2 skills to support analytics and reporting across teams.