System Analyst

PIB Group; Gandhinagar; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

PIB Group is seeking a seasoned System Analyst/Data Analyst to translate complex business rules into robust data and system requirements. You will author BRDs/FRDs, design ERDs, and guide cross-functional teams through full SDLC in an insurance/benefits context.

Responsibilities include requirements workshops, stakeholder communications, and SQL-driven validation. A strong emphasis on data quality, documentation, and agile delivery is required.

Qualifications

• Must have strong business analysis capability and ability to read scheme documentation.
• Solid understanding of SDLC and Agile/Scrum delivery practices.
• Hands-on experience with relational databases, data modelling (ERD), normalisation, and SQL (PostgreSQL preferred).
• Experience gathering requirements and documenting BRDs/FRDs and user stories.
• Strong problem-solving and incident analysis skills using logs and SQL.
• Excellent written and verbal communication with stakeholder management.
• Practical experience with Jira and Confluence.

Responsibilities

• Understand business processes, scheme rules, and workflows for employee benefits administration.
• Translate schemes and rules into clear system behavior and data requirements.
• Lead requirements gathering through workshops and interviews.
• Produce BRDs, FRDs, user stories, and acceptance criteria.
• Design ERDs and ensure data integrity across systems.
• Collaborate with developers and architects to align with architecture and SDLC.
• Write and run SQL queries for data validation and impact analysis.
• Perform root-cause analysis of incidents using logs and monitoring tools.
• Map current and target state processes to streamline workflows.
• Support Agile delivery with backlog refinement and sprint planning.
• Maintain documentation in Jira and Confluence with traceability.

Skills

Strong SQL

Business analysis

SDLC & Agile

Jira & Confluence

Stakeholder management

Documentation BRDs/FRDs

Workshop facilitation

Data modelling ERD

Education

BE/B.Tech IT/CS

Tools

Jira

Confluence

Azure DevOps

Job description

Key Responsibilities

• Work with business stakeholders to understand business processes, scheme rules, and operational workflows for employee benefits administration.
• Analyze and interpret scheme documentation and business rules, translating them into clear system behavior and data requirements.
• Lead and facilitate requirements-gathering activities (workshops, interviews, documentation review) to capture functional and non-functional requirements.
• Produce high-quality documentation including business requirements documents (BRDs), functional requirements documents (FRDs), user stories, and acceptance criteria.
• Design logical and physical data models (ERDs) to support new and existing features, ensuring data integrity, normalization, and consistency across systems.
• Collaborate with developers and architects to ensure solutions align with business needs, technical architecture, and SDLC standards.
• Write and execute SQL queries to analyze data, validate requirements, support impact analysis, and assist with defect investigation.
• Perform root-cause analysis of incidents and defects using logs, monitoring tools, and database analysis; define and document fixes and preventative improvements.
• Map and document current and target-state business processes, identifying opportunities to streamline workflows and improve data quality.
• Support Agile delivery (Scrum/Kanban) by contributing to backlog refinement, sprint planning, and demonstration of completed changes to stakeholders.
• Maintain configuration and requirements documentation in tools such as Jira and Confluence, ensuring traceability from requirements through to implementation and testing.
• Work closely with application support, testing, and development teams to ensure smooth deployment and transition of changes into BAU operations.

Must have

• Strong business analysis capability including business process understanding and the ability to read scheme documentation and translate it into system behaviour.
• Solid understanding of SDLC and Agile/Scrum delivery practices.
• Hands-on experience with relational databases, data modelling (ERD), normalisation, and SQL (preferably PostgreSQL).
• Demonstrable experience in requirements gathering and documentation (BRDs/FRDs, user stories, acceptance criteria).
• Strong problem-solving, root-cause analysis, and incident analysis skills using SQL, logs, and monitoring tools.
• Excellent written and verbal communication skills, with experience of stakeholder management and incident/update communication.
• Practical experience with Jira and Confluence or equivalent tools.

Nice to have

• Exposure to web applications and cloud-hosted solutions.
• Experience with monitoring/logging tools and application performance analysis.
• Experience with Azure DevOps or similar tools for task and workflow tracking.
• Prior experience in insurance, pensions, or employee benefits domains.
• Experience contributing to basic project planning, estimation, and time management within an Agile context.

Person specification

Qualifications

• BE/B.Tech in IT / Computer Science

Experience

• Overall Min. 7 years’ experience in Software Services Industry.
• Min. 5 years’ experience in a System Analyst, Data Analyst, or similar business/technical analyst role.
• Proven experience of working through the full SDLC on application or platform change initiatives.
• Practical experience of requirements gathering, writing BRDs/FRDs and user stories, and working with product owners and developers.
• Hands-on experience designing and working with relational data models and writing complex SQL queries.
• Demonstrable experience in incident and problem analysis, including root-cause identification using logs and monitoring tools.
• Experience within insurance, pensions, employee benefits, or wider financial services.
• Experience working with /web applications and cloud-based platforms.
• Experience working in multi-team, multi-vendor environments.

Knowledge

• Strong understanding of business analysis techniques, process mapping, and requirements engineering.
• Solid knowledge of relational database concepts, ER modelling,
  normalization, and data integrity controls.
• Understanding of application architecture concepts (e.g. APIs, services, integrations, web applications, monitoring).
• Good understanding of SDLC, Agile methods, and change control.
• Awareness of data integration patterns, messaging, and batch processing.
• Familiarity with monitoring and logging tools used to support production systems.
• Domain knowledge of employee benefits products, schemes, or similar financial products.

Skills

• Advanced analytical and problem-solving skills with strong attention to detail.
• Ability to translate complex business needs into clear and testable system and data requirements.
• Strong SQL skills for data interrogation, validation, and impact analysis.
• Proficiency in producing clear, structured documentation (BRDs, FRDs, user stories, process maps).
• Skilled in facilitating workshops, requirements sessions, and walkthroughs with business and technical audiences.
• Effective communication and stakeholder management skills, both written and verbal.
• Proficiency with Jira, Confluence, and standard collaboration tools (Teams, email, ticketing systems).
• Basic project/task planning, estimation, and tracking skills.
• Experience using Azure DevOps or equivalent Agile lifecycle tools.
• Ability to mentor junior analysts on analysis and documentation practices.

Attitude

• Proactive, self-motivated, and able to take ownership of analysis deliverables.
• Collaborative team player who works well with business, technical, and support colleagues.
• Quality-focused with a strong sense of accountability for data accuracy and system behaviour.
• Comfortable working in a changing environment and managing multiple priorities.
• Customer-focused mindset with a desire to improve processes and user experience.
• Willingness to share knowledge and support continuous improvement of analysis practices.
• Openness to providing occasional out-of-hours support during major releases or incident resolution, if required.