Job Title: Business Analyst (Insurance Domain) with PL/SQL and Java Framework Knowledge

Location: Remote position

Below is a detailed for a Business Analyst (Insurance Domain) with PL/SQL and Java Framework Knowledge (6+ Years Experience)

Business Analyst - Insurance Domain

Experience: 6+ Years The candidate should possess a solid understanding of insurance operations, policy administration, claims processing, underwriting workflows, and regulatory requirements, along with the ability to analyze data, perform SQL-based validations, and collaborate effectively with development and QA teams.

Key Responsibilities

· Business Analysis & Requirement Management

· Gather, analyze, document, and validate business requirements from stakeholders.

· Conduct workshops, interviews, and requirement elicitation sessions.

· Create detailed Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), user stories, and process flows.

· Translate business needs into explicit functional and technical specifications.

· Perform impact analysis for proposed changes and enhancements.

· Ensure traceability of requirements throughout the project lifecycle.

· Insurance Domain Expertise

· Analyze and support business processes related to:

o Policy Administration o Claims Management o Underwriting o Billing and Payments o Renewals and Endorsements o Insurance Product Configuration

· Work closely with business users to improve operational efficiency.

· Support regulatory and compliance initiatives affecting insurance products and processes.

· Understand P&C;, Life, Health, or Commercial Insurance business processes.

· Data Analysis & PL/SQL

· Write complex SQL queries for data analysis, validation, reconciliation, and reporting.

· Analyze large datasets to identify trends, anomalies, and business insights.

· Work with database teams to review stored procedures, packages, triggers, and functions.

· Validate data migration and transformation activities.





· Support UAT and production issue investigations using Oracle database and PL/SQL.

· Application & Technical Collaboration

· Collaborate with development teams working on Java-based applications.

· Understand application architecture and integration points.

· Participate in solution design discussions and provide functional inputs.

· Review technical designs to ensure alignment with business requirements.

· Coordinate with developers, architects, QA teams, and project managers.

· Testing & Quality Assurance

· Create and review test scenarios and test cases.

· Support SIT, UAT, and regression testing.

· Perform requirement validation and defect triage.

· Ensure delivered solutions meet business expectations.

· Stakeholder Management

· Act as liaison between business users and technical teams.

· Conduct project status meetings and requirement walkthroughs.

· Present findings, recommendations, and business cases to senior stakeholders.

· Manage stakeholder expectations and address business concerns proactively.

Required Qualifications

· Experience

· 6+ years of experience as a Business Analyst.

· Minimum 3-5 years of experience in the Insurance industry.

· Proven experience working on large-scale application development or enhancement projects.

· Experience working in Agile and Waterfall environments.

· Insurance Domain Knowledge

Strong understanding of

· Policy Administration Systems

· Claims Processing

· Underwriting Operations

· Insurance Product Lifecycle

· Premium Calculation

· Billing & Collections

· Regulatory Compliance Requirements

· Technical Skills

· Strong SQL and PL/SQL expertise.





· Experience querying databases

· Knowledge of stored procedures, packages, triggers, and views.

· Understanding of Java/J2EE-based applications.

· Familiarity with frameworks such as:

o Spring Boot o Spring MVC o Hibernate/JPA o EJB

· Knowledge of REST APIs and system integrations.

· Experience with data mapping and data analysis.

· Tools & Technologies

· SQL Server Database

· SQL Developer / TOAD

· JIRA

· Confluence

· Microsoft Visio

· Azure DevOps

· Postman

· Swagger

· MS Excel

· Preferred Qualifications

· Experience with Guidewire, Duck Creek, Policy Center, Claim Center, or similar insurance platforms.

· Knowledge of cloud platforms (Azure/AWS).

· Experience with API integrations and microservices architecture.

· CBAP, CCBA, PMP, or Agile certifications.

· Prior experience working with distributed or offshore teams.

· Key Competencies

· Requirement Gathering & Analysis

· Business Process Modeling

· Stakeholder Management

· Insurance Domain Expertise

· Data Analysis & Validation

· Problem Solving

· Communication & Presentation Skills

· Agile Methodology

· Risk Analysis

· Documentation & Reporting

· Education

· Bachelor's degree in Business Administration, Computer Science, Information Technology, Engineering, or related field.

· Relevant Business Analysis or Insurance certifications are highly preferred.

· Nice-to-Have Skills

· Knowledge of ETL processes.

· Experience with reporting tools such as Power BI or Tableau.

· Exposure to DevOps and CI/CD pipelines.

· Experience working with microservices and event-driven architectures.

· Basic understanding of XML, JSON, and XSD schemas

Thanks & Regards

Mohd Rahbar (Technical Recruiter)

Raas Infotek Corporation.

262 Chapman Road, Suite 105A,

Newark, DE -19702

E-Mail: [email protected]| Website: www.raasinfotek.com

LinkedIn https://www.linkedin.com/in/mohd-rahbar-180a4725a

📌 Senior Business Analyst (Insurance Domain) (Canada)
🏢 Raas Infotek
📍 Canada