Lead Consultant -Excel Expert with VBA

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.

Key Responsibilities and Skills:
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: Bachelor s 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.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. Get to know us at www.genpact.com and on X, Facebook, LinkedIn, and YouTube.

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a starter kit, paying to apply, or purchasing equipment or training.