Property & Casualty Insurance - Senior Data Engineer | SQL Server / SSIS

ValueMomentum provides solutions for the global property and casualty insurance industry. The company is seeking a Senior Data Engineer to develop and support ETL pipelines, maintain enterprise data warehouses, optimize SQL Server performance, and transform insurance data into analytics-ready structures.

Responsibilities:

• Developing and supporting ETL pipelines
• Maintaining enterprise data warehouses
• Optimizing SQL performance
• Transforming insurance data into analytics-ready structures

Requirements:

• 8–12 years of overall IT experience in Data Engineering / Data Warehousing
• Mandatory: Hands-on P&C Insurance experience working with policy, coverage, premium, claims, or transaction data
• Mandatory: Strong hands-on SQL Server/T-SQL experience, including complex queries, stored procedures, indexing, query optimization, and performance tuning
• Mandatory: Hands-on SSIS development and support experience, including batch ETL pipelines
• Understanding of the P&C policy lifecycle, including New Business, Endorsement, Renewal, Cancellation, and Reinstatement
• Strong understanding of Data Warehousing concepts, including fact/dimension models, star/snowflake schemas, EDW/ODS, and historical data
• Experience with source-to-target mapping, data validation, reconciliation, and data quality
• Experience troubleshooting production data issues, investigating ETL failures, and performing root-cause analysis
• Strong problem-solving skills and ability to work with business, application, and data teams
• Guidewire PolicyCenter or other insurance policy administration system experience is a plus, but not mandatory
• Exposure to Power BI, Tableau, Databricks, or Azure Data Factory is a plus