SQL Developer

Role : SQL Developer Industry : Property & Casualty (P&C) Insurance Location : Remote Duration : Contract on W2 Experience : 10+ Years Interview Type : Virtual / In-Person Job Description : We are seeking an experienced SQL Developer with a strong background in SQL Server 2014, SSIS, and SSRS to join our client team at CNA Insurance. The ideal candidate will have hands-on experience in designing, developing, and maintaining SQL-based solutions, along with an understanding of Property and Casualty (P&C) Insurance data and business processes. Key Responsibilities : Design, develop, and maintain SQL Server databases, stored procedures, views, and functions. Develop and optimize complex T-SQL queries for data extraction, transformation, and reporting. Build, deploy, and maintain SSIS packages for ETL processes and data integration between multiple systems. Create and manage SSRS reports and dashboards to meet business and operational needs. Analyze, troubleshoot, and resolve data and performance issues in SQL Server environments. Collaborate with business analysts and data architects to translate business requirements into technical solutions. Support data quality, consistency, and security standards across multiple systems. Participate in system design discussions and provide recommendations for database improvements. Work closely with insurance business users to ensure data accuracy and reporting reliability for P&C operations. Required Skills and Experience : 6+ years of professional experience as a SQL Developer. Strong proficiency with Microsoft SQL Server 2014 (and later versions Hands-on experience with SSIS (SQL Server Integration Services) and SSRS (SQL Server Reporting Services Advanced T-SQL scripting and query optimization skills. Experience in data analysis, data modeling, and ETL workflows. Knowledge of P&C Insurance data, including policies, claims, underwriting, and billing systems. Strong analytical and troubleshooting skills. Excellent communication and collaboration abilities. Preferred Qualifications : Experience working with insurance domain clients (CNA Insurance experience is a plus Familiarity with Agile / Scrum methodologies. Exposure to data warehousing concepts and Power BI reporting. Knowledge of Azure SQL, Stored Procedures automation, or Control-M scheduling tools. Education : Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience Additional Information : Role involves close interaction with business users in the Property & Casualty Insurance domain. Must have strong data understanding and ability to deliver accurate, high-quality reports and ETL processes. Immediate availability preferred.