Technical Business Analyst

Pune

Posted:15 hours ago

Apply

Job Description

Technical


Key responsibilities

  • Gather, document, and validate business requirements for reinsurance systems (treaty & facultative).
  • Write and execute complex SQL queries for data extraction, transformation, reconciliation, and gap analysis.
  • Prepare BRD, FRD, user stories, use cases, and process flow diagrams for development and QA teams.
  • Perform detailed analysis of premium bordereaux, claims bordereau, and cession statements.
  • Collaborate with actuarial, finance, and IT teams to support pricing, reserving, and regulatory reporting.
  • Conduct UAT, develop test scripts, track defects, and ensure business sign-off.
  • Build and maintain dashboards/reports in Excel, Tableau, or Power BI for management reporting.
  • Support data migration, system integration, and digital transformation initiatives.
  • Facilitate workshops, sprint planning, and stakeholder review meetings (Agile/Scrum environment).


Required skills & qualifications

  • 6 years

    of experience as a Business Analyst in reinsurance, insurance, or financial services.
  • Strong proficiency in

    SQL

    – joins, subqueries, window functions, stored procedures.
  • Good understanding of reinsurance concepts: treaty types, retrocession, IBNR, loss ratios, combined ratio.
  • Experience writing BRD/FRD documents and managing requirements traceability.
  • Familiarity with Agile/Scrum methodology and tools like JIRA or Confluence.
  • Proficiency in MS Excel (pivot tables, VLOOKUP, advanced formulas) and PowerPoint.
  • Strong analytical thinking, problem-solving, and communication skills.
  • Bachelor's or master's degree in engineering, IT, Finance, or related field.


Good to have

  • Exposure to reinsurance platforms such as Majesco, SAP FS-RI, SAPIENS, or Guidewire.
  • Knowledge of IFRS 17 / Solvency II reporting requirements.
  • Experience with Python or R for data analysis.
  • Tableau, Power BI, or Qlik Sense dashboard development.
  • Insurance certifications: ACII, LOMA, III, or equivalent.


Skills Required

Insurance Domain SQL Data Validation Root Cause Analysis Data Quality Claims Accounting SQL Queries Data Extraction Reconciliation GAP Analysis User Stories

Learn the skills this job asks for

See your skill gap for Business Analyst →

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Capgemini logo
Capgemini

IT Services and IT Consulting

Paris France

RecommendedJobs for You

Hyderabad, Chennai, Bengaluru

J
J

Technical Business Analyst

Jainco Consulting India Private Limited

Mumbai

Hyderabad, Chennai, Bengaluru