Senior Data Engineer – Data Governance, Claims & Insurance

Job Title: Senior Data Engineer – Data Governance, Claims & Insurance Location: Onsite – Warren, NJ Experience Required: 14+ Years Duration: Long Term Contract Kindly Share your resumes to dkannoji@wscs.ai Job Summary: We are seeking a highly experienced Senior Data Engineer with strong expertise in Data Governance, Insurance Claims Data, and Enterprise Data Platforms. The ideal candidate will have 14+ years of experience designing, developing, and optimizing scalable data solutions within the P&C or Commercial Insurance domain. This is a fully onsite role in Warren, NJ, requiring hands-on expertise in modern data engineering tools, data quality frameworks, governance standards, and claims data modeling. Key Responsibilities: • Design, build, and maintain scalable data pipelines supporting Claims, Policy, Billing, and Underwriting domains. • Develop and optimize ETL/ELT processes using Azure Data Factory, Databricks, Spark, or similar platforms. • Implement enterprise Data Governance frameworks, including data lineage, metadata management, data cataloging, and data quality monitoring. • Define and enforce data standards, naming conventions, stewardship models, and regulatory compliance controls (NAIC, SOX, etc.). • Collaborate with Claims business stakeholders to model claims transactions, exposures, reserves, payments, and loss development data. • Lead data architecture design for enterprise data warehouse, lakehouse, and cloud modernization initiatives. • Ensure high data quality through profiling, validation rules, reconciliation processes, and automated monitoring dashboards. • Optimize SQL queries, stored procedures, indexing strategies, and performance tuning for large datasets. • Work closely with Data Analysts, BI teams, and Actuarial teams to enable reporting, analytics, and predictive modeling. • Provide technical leadership, mentor junior engineers, and drive best practices across data engineering teams. Required Qualifications • 14+ years of hands-on experience in Data Engineering. • Strong domain expertise in Insurance (P&C preferred) with deep understanding of Claims lifecycle and data structures. • Extensive experience with: • SQL (advanced query optimization, indexing, partitioning) • Azure Data Factory / Databricks / Spark • Data Warehousing (Snowflake, SQL Server, or similar) • Data Lake / Lakehouse architecture • Python or Scala for data engineering • Proven experience implementing Data Governance tools (e.g., Collibra, Informatica EDC, Microsoft Purview). • Experience with Claims data models (FNOL, Loss Reserves, Payments, Subrogation, Recoveries, Exposures). • Strong knowledge of data security, PII handling, and compliance frameworks. • Experience working in Agile/Scrum environments. Preferred Qualifications • Experience with Guidewire ClaimCenter data integration. • Knowledge of regulatory reporting and actuarial data requirements. • Cloud certifications (Azure Data Engineer Associate or equivalent). • Experience with CI/CD pipelines and DevOps for data platforms.