Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
Job Location : Jersey City, NJ (Onsite/Hybrid from Day 1)
Job Description
We are seeking an experienced Business Analyst with a strong background in Data Engineering and Data Warehousing projects and proven expertise within the Property & Casualty (P&C) Insurance domain. The ideal candidate will act as a bridge between business stakeholders, data engineering teams, architects, and IT organizations to ensure data-driven solutions align with business objectives and deliver measurable value.
This role requires a highly hands-on Data Business Analyst who is comfortable working with complex datasets, performing data profiling, analyzing source systems, creating pseudo code, defining transformation logic, and supporting end-to-end data initiatives. The candidate must possess a strong understanding of insurance data, data warehousing concepts, ETL/ELT processes, and modern cloud-based data platforms.
Key Responsibilities:
- Collaborate with business stakeholders to gather, analyze, and document business and data requirements.
- Translate business requirements into functional and technical specifications for data engineering teams.
- Define business rules, KPIs, success criteria, and data use cases.
- Perform hands-on data profiling, data analysis, and data discovery to identify data quality issues, patterns, relationships, and business rules.
- Create and document pseudo code, transformation logic, source-to-target mappings, and data processing rules.
- Analyze and document data flows, data lineage, transformation logic, and integration requirements.
- Work closely with Data Engineers, Architects, and Developers on data integration, ETL/ELT, data pipeline, and data warehousing initiatives.
- Facilitate requirements workshops, stakeholder meetings, and solution review sessions.
- Act as the primary liaison between business users, data teams, and IT stakeholders.
- Define and validate test scenarios,