guidewire Lead SQL Data Analyst (P&C Insurance)

About the role

Lead SQL Data Analyst position focused on Property & Casualty insurance policy administration. This is a 12‑month+ contract based in Woodbridge, NJ, requiring onsite presence four days per week with a final in‑person interview in New Jersey. The role centers on implementing a brand‑new policy administration system: cleansing and validating incoming data, tracking defects to resolution in a defect‑tracking tool, performing testing, and supporting users with SQL queries. Strong leadership, ownership, and communication skills are essential.

Responsibilities

• Implement and support a new policy administration system
• Analyze and fix data quality issues; reconcile daily balances and route defects for resolution
• Log, track, and manage defects in a defect‑tracking tool through to completion
• Conduct testing of system changes and data migrations
• Write and optimize SQL queries for analysis, testing, and developer assistance
• Leverage Snowflake for data warehousing and analytics
• Provide technical leadership and mentorship; take ownership of deliverables
• Communicate effectively with stakeholders, developers, and business users

Requirements

• Bachelor’s degree in Computer Science or equivalent experience
• 5–8 years of software development experience
• Extensive experience querying relational databases
• Proficiency in data mapping and transformation
• Knowledge of structured analysis techniques
• Experience with SDLC methodologies, including project planning and estimating
• Advanced SQL skills: ability to create complex queries for analysis, testing, and developer support
• Excellent oral and written communication skills
• Property & Casualty insurance domain experience
• Policy administration system knowledge

Preferred qualifications

• Prior experience with statutory and compliance‑related reporting
• Proficiency with Microsoft Office suite
• Supervisory or lead experience
• Exposure to DB2 and SQL Server databases
• Familiarity with cloud technologies
• Strong problem‑solving mindset with a desire to improve existing processes