ETL Dev Lead Position Available In Fulton, Georgia
Tallo's Job Summary: ETL Dev Lead position available for a contract role in various locations such as Alpharetta, GA; Charlotte, NC; Chicago, IL; and more. Requires 10+ years of data architecture experience, 3+ years in Insurance and reinsurance domain, and advanced knowledge of Data Warehousing and ETL. Responsibilities include designing solutions, creating data models, and optimizing SQL Server platforms. Key skills include ETL, Insurance domain, and various applications.
Job Description
ETL Dev Lead
Role:
ETL Dev Lead Contract
Location:
[On-site]
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
Job Description:
10+ years of data architecture and design experience working with development team to extract data directly from source applications and loading to an enterprise data warehouse.
3+ years of experience within the Insurance and reinsurance domain.
Advanced experience with extracting data from Insurance applications.
Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworks.
Capable of creating and tuning Semantic layer Reporting Views.
Capable of facilitating data discovery sessions involving business subject matter experts.
Knowledge of RDBMS platforms (SQL Server, DB2, etc.) with experience in generating DDL.
Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP
FS-CDSAP FI-GL
applications.
Architect and design comprehensive solutions for the enterprise data warehouse. Sourcing data from multiple Insurance and Reinsurance Policy, Treaty, Claim and financial systems.
Design and implement Source to Target mappings optimized for high-volume data integration.
Create logical and physical data models and implement them on SQL Server platforms.
Work closely with the development team to ensure accurate translation of mappings into code.
Develop strategies for data collection and ingestion and write SQL based solutions to validate data accuracy and integrity in the data warehouse.
Analyze and design enterprise data models for optimal reporting. Support reporting teams in understanding and utilizing the data warehouse model effectively.
Participate in release planning and validate changes post-deployment.
Develop SQL Server views for reporting and dashboard development. Troubleshoot and optimize SQL and Informatica mappings and stored procedures.
Key Skills:
ETL, Insurance and reinsurance domain, Data Warehousing, ETL and BI Architectures, Guidewire Policy Center, Guidewire Claims Center, SAP
FS-CDSAP FI-GL
applications.
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:
2025-87385
