ETL lead developer Position Available In Fulton, Georgia
Tallo's Job Summary: Seeking an ETL Development Lead for long-term contract roles in various locations. Responsibilities include data architecture, ETL development, data modeling, and business intelligence. Qualifications include 10+ years of experience, insurance domain knowledge, and proficiency in SQL Server, DB2, Guidewire, and SAP. VDart Group is recruiting for this role.
Job Description
ETL lead developer
Job Title:
ETL Development Lead
Location:
Alpharetta, GA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS
Duration/Term:
Long Term Contract
Job Description:
We are seeking an experienced ETL Development Lead to design and develop enterprise data solutions for insurance and reinsurance systems. The ideal candidate will have extensive experience in data architecture, data warehousing, ETL processes, and business intelligence frameworks
, working with development teams to integrate data from various insurance applications into a unified data warehouse.
Key Responsibilities:
Data Architecture & Design:
Architect and design comprehensive data warehouse solutions
, sourcing data from multiple insurance and reinsurance policy, treaty, claim, and financial systems
.
Data Integration & ETL Development:
Design and implement source-to-target mappings optimized for high-volume data integration
, ensuring data accuracy and integrity.
Data Modeling:
Create logical and physical data models and implement them on SQL Server platforms to support enterprise-wide reporting.
Business Intelligence:
Develop and tune semantic layer reporting views
, facilitating effective data discovery sessions with business subject matter experts
.
SQL Development & Optimization:
Write SQL-based solutions for data validation, dashboard development
, and performance optimization of ETL mappings and stored procedures.
Collaboration & Implementation:
Work closely with the development team to ensure accurate translation of mappings into production-ready code.
System Enhancement & Troubleshooting:
Troubleshoot and optimize SQL Server and Informatica mappings
, ensuring high-performance data processing
.
Stakeholder Engagement:
Participate in release planning
, support reporting teams, and ensure seamless integration with existing insurance and financial applications
.
Qualifications:
Must Have:
10+ years of data architecture and design experience
3+ years of experience within the Insurance and Reinsurance domain
Advanced experience with extracting data from insurance applications
Expertise in Data Warehousing, ETL, and BI architectures
Strong knowledge of RDBMS platforms (SQL Server, DB2) and DDL generation
Proficiency with Guidewire Policy Center, Guidewire Claims Center, SAP
FS-CD, SAP FI-GL
Nice to
Have:
Experience in facilitating data discovery sessions involving business experts
Ability to create semantic reporting views for optimized business intelligence
Strong understanding of release management and deployment validation
Hands-on experience in data governance and compliance for insurance systems
Key Skills:
Data Architecture, Data Warehousing, ETL, BI, SQL Server, DB2, Guidewire, SAP
FS-CD, SAP
FI-GL, Source-to-Target Mapping, Data Modeling, Semantic Reporting Views, SQL Optimization, Release Planning
VDart Group
, a global leader in technology, product, and talent management, empowers businesses with comprehensive solutions through our four distinct, industry-leading business units With a diverse team of over 4,000 professionals across 13 countries, we deliver strong results across various industries, including Fortune 500 companies
Committed to “People, Purpose, Planet,” we prioritize social responsibility and sustainability, as evidenced by our EcoVadis Bronze Medal Certification and participation in the UN Global Compact
Our dedication to delivering strong results has earned us recognition as a trusted advisor for businesses seeking to drive innovation and growth, including many Fortune 500 companies Join our network! Partner with VDart Group to leverage our global network, industry expertise, and proven track record with a diverse clientele Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job
Dice Id:
10330808A
Position Id:
8642365
