Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose - the relentless pursuit of a world that works better for people - we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI. We are inviting applications for the role of Lead Consultant -Lead Excel Resource with Advanced Skills and VBA Expertise ! Professional Summary: Highly skilled Excel Specialist with expertise in advanced Excel functionalities, VBA programming, and data analysis. Experienced in creating and automating insurance-specific data processing tasks, including bordereaux management, underwriting support, claims analytics, and premium calculations. Adept at streamlining workflows, improving operational efficiency, and delivering actionable insights through data-driven solutions. Responsibilities: Advanced Excel & VBA Automation: Excel Expertise: o Proficient in advanced Excel functionalities, including Power Query, pivot tables, data modeling, conditional formatting, and advanced formulas. VBA Programming: o Develops and optimizes VBA macros for process automation, error handling, and report generation. o Designs custom Excel-based tools for data extraction, transformation, and analysis. Insurance Domain Knowledge: Bordereaux Processing: o Automates bordereaux data processing for underwriting, claims, and premium analytics. o Implements validation checks to ensure accuracy and compliance with insurance standards. Data Insights: o Prepares and visualizes reports for key insurance metrics, enabling data-driven decision-making. Data Management & Analysis: Data Integration: o Merges, cleanses, and transforms complex datasets from multiple sources to deliver reliable reports. Governance & Quality: o Implements robust data quality checks and governance processes to ensure consistency and accuracy. Collaboration & Support: Partners with data architects and business stakeholders to design and deliver scalable, automated solutions. Provides end-user support and training for tools and reports, ensuring seamless adoption. Strengths: Analytical mindset with a passion for solving complex data challenges. Strong attention to detail and a proactive approach to optimizing processes. Collaborative team player, capable of working with cross-functional teams. Commitment to delivering high-quality solutions tailored to business goals. Qualifications we seek in you! Minimum Qualifications Education: Bachelors Degree in Mathematics, Computer Science, or related fields. Certifications (Preferred): Microsoft Excel Expert, VBA Programming, or Power BI certifications. Technical Proficiency: Tools: Advanced Excel (Power Query, Power Pivot, Solver), VBA, Power BI. Programming: VBA, SQL. Methods & Frameworks: Agile, Scrum. JobLead Consultant Primary LocationIndia-Bangalore ScheduleFull-time Education LevelBachelor's / Graduation / Equivalent Job PostingMar 4, 2025, 4:33:40 AM Unposting DateAug 31, 2025, 12:03:40 AM Master Skills ListDigital Job CategoryFull Time,
Employement Category:
Employement Type: Full time Industry: IT Services & Consulting Role Category: Not Specified Functional Area: Not Specified Role/Responsibilies: Lead Consultant -Excel Expert with VBA Job in
Contact Details:
Company: Genpact Location(s): Other Karnataka Email: hi*********l@