IT Solutions Analyst - Guidewire, Data, and IntegrationHub

Prosum; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Prosum is seeking an IT Solutions Analyst IV to bridge business and technology teams by translating business needs into clear technical requirements and solutions. You will analyze complex Guidewire environments, integrations, data flows, and system dependencies across the enterprise.

The ideal candidate has strong technical analysis and documentation skills, experience with Guidewire, data mapping, APIs, integrations, SQL/data analysis, and the ability to quickly understand complex systems and

Qualifications

• Strong experience in technical business analysis or systems analysis.
• Experience with Guidewire, preferably PolicyCenter, ClaimCenter, or BillingCenter.
• Strong data mapping and data-flow analysis experience, including source-to-target mappings and transformation requirements.
• Experience with APIs, enterprise integrations, and system interfaces.
• Strong technical requirements and documentation skills.
• Experience performing system impact analysis across multiple applications.
• Familiarity with SQL, relational databases, data structures, and data analysis.
• Experience working in Agile environments.
• Strong analytical, problem-solving, communication, and collaboration skills.

Responsibilities

• Translate business requirements into detailed technical requirements, user stories, specifications, and acceptance criteria.
• Analyze Guidewire applications, enterprise platforms, integrations, and downstream system impacts.
• Develop and maintain source-to-target data mappings, transformation rules, data-flow documentation, and interface specifications.
• Analyze application dependencies, APIs, integrations, data structures, and system-to-system interfaces.
• Perform system and data impact analysis for enhancements, migrations, integrations, and modernization initiatives.
• Create system maps, integration diagrams, data-flow diagrams, technical specifications, and SOPs.
• Collaborate with architects, developers, QA, data/integration teams, project managers, and business stakeholders.
• Support UAT, data validation, reconciliation, defect resolution, and implementation activities.
• Use SQL and data analysis techniques to investigate data issues, dependencies, and discrepancies.
• Identify risks, issues, dependencies, and downstream impacts and communicate findings to stakeholders.
• Support Agile project delivery, planning, timelines, milestones, and cross-team dependencies.

Skills

Technical business analysis

Guidewire

Data mapping

APIs

Data analysis

SQL

Agile

Job description

We are seeking an IT Solutions Analyst IV to bridge business and technology teams by translating business needs into clear technical requirements and solutions. This role will analyze complex applications, Guidewire environments, integrations, data flows, and system dependencies across the enterprise.

The ideal candidate has strong technical analysis and documentation skills, experience with Guidewire, data mapping, APIs, integrations, SQL/data analysis, and the ability to quickly understand complex systems and communicate effectively with technical and business stakeholders.

What You'll Do

• Translate business requirements into detailed technical requirements, user stories, specifications, and acceptance criteria.
• Analyze Guidewire applications, enterprise platforms, integrations, and downstream system impacts.
• Develop and maintain source-to-target data mappings, transformation rules, data-flow documentation, and interface specifications.
• Analyze application dependencies, APIs, integrations, data structures, and system-to-system interfaces.
• Perform system and data impact analysis for enhancements, migrations, integrations, and modernization initiatives.
• Create system maps, integration diagrams, data-flow diagrams, technical specifications, and SOPs.
• Collaborate with architects, developers, QA, data/integration teams, project managers, and business stakeholders.
• Support UAT, data validation, reconciliation, defect resolution, and implementation activities.
• Use SQL and data analysis techniques to investigate data issues, dependencies, and discrepancies.
• Identify risks, issues, dependencies, and downstream impacts and communicate findings to stakeholders.
• Support Agile project delivery, planning, timelines, milestones, and cross-team dependencies.

Key Skills & Experience

• Strong experience in technical business analysis or systems analysis.
• Experience with Guidewire, preferably PolicyCenter, ClaimCenter, or BillingCenter.
• Strong data mapping and data-flow analysis experience, including source-to-target mappings and transformation requirements.
• Experience with APIs, enterprise integrations, and system interfaces.
• Strong technical requirements and documentation skills.
• Experience performing system impact analysis across multiple applications.
• Familiarity with SQL, relational databases, data structures, and data analysis.
• Experience working in Agile environments.
• Strong analytical, problem-solving, communication, and collaboration skills.

Preferred Experience

• Guidewire implementation, integration, migration, or modernization experience.
• Insurance/P&C industry experience.
• Experience with enterprise policy administration platforms.
• Experience creating integration specifications, data-flow diagrams, and technical documentation.

What You'll Bring

You are a technically strong analyst who can understand complex applications and data flows, identify cross-system impacts, develop clear requirements and data mappings, and communicate effectively with both technical and non-technical stakeholders.

The role is ideal for someone who enjoys solving complex system and data problems and supporting enterprise technology, Guidewire, integration, and modernization initiatives.