Tech Lead P&C Insurance Domain with SQL

Genpact; Chicago (IL); Hybrid; USD 80,000 - 100,000; Full time

Job summary

Genpact is seeking a Tech Lead for Insurance with strong SQL skills to oversee the development and implementation of software solutions in Chicago. The ideal candidate will serve as the primary contact for application development and support while ensuring optimal functionality of the software.

Responsibilities include managing a SQL database environment and driving the migration to modern platforms. Candidates ideally possess a deep understanding of insurance operations and premium accounting processes, with a preference for experience in a hybrid work setting.

Qualifications

• Strong domain knowledge of insurance operations, specifically within MGA and premium accounting.
• Experience working extensively on premium accounting workflows.
• Proven problem-solving abilities and analytical skills.

Responsibilities

• Serve as a technical lead to design and implement solutions.
• Support migration from legacy systems to modern platforms.
• Create and maintain technical documentation for users and training.

Skills

Hands on SQL – 8+ years

Strong understanding of MGA operations and premium accounting processes

Familiarity with a variety of both legacy and modern Policy Admin platforms

Solid understanding of Web applications and cloud managed services

Agile experience, both Scrum and Kanban

Tools

Jira

Confluence

Service Now

ITIL tools

ETL and SSIS packages

Job description

Position

Tech Lead, Insurance & SQL

Location

Chicago, IL (Hybrid)

Responsibilities

• Serve as a technical lead to design, develop, and implement solution.
• Single point of contact for development for existing stack of applications and supporting production incidents.
• Maintain and improve the functionality of existing software applications.
• Manage and support SQL database environment, including production, testing, and development.
• Analyse complex technical information to determine risk, impact, and mitigation strategies.
• Support migration and transformation initiatives from legacy systems to modern platforms, ensuring data integrity and process continuity.
• Create and maintain technical documentation to guide system users and assist with training.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Provide guidance and mentorship to the team members.
• Stay updated with the latest industry trends and technology advancements.
• Work closely with business leads and product owners to understand requirements.
• Guide development and support teams. Mentor team members. Provide technical/functional guidance on the application.
• Work on configuration changes.

Minimum Qualifications

• Familiarity with a variety of both legacy and modern Policy Admin platforms.
• Strong understanding of MGA operations and premium accounting processes.
• Strong domain knowledge of insurance operations, specifically within MGA and premium accounting.
• Work extensively on premium accounting workflows, including invoicing, collections, bordereaux processing, reconciliation, and reporting.
• P&C experience (preferably in Specialty Insurance).
• Hands on SQL – 8+ years.
• Understanding of insurance data structures, financial reconciliation, and reporting processes.
• Experience in ETL and SSIS packages and workflow/automation creation.
• Experience with Documaker, Rackley, Infomaker, PowerBuilder, Retool, GoAnywhere, Redgate Tools, Git.
• Solid experience working in Agile environment. Both Scrum and Kanban.
• Hands on experience with Jira, Confluence, Service Now, ITIL tools and process framework.
• Solid understanding of Web applications, cloud managed services, service-oriented architecture (SOA) solutions, microservices, containers, API development and managed databases.
• Superior analytical and problem-solving abilities.
• Proven ability to work both independently and as part of a team.

Preferred Qualifications / Skills

• Nice to have Cloud experience, Azure Cloud, GCP.
• Knowledge of ConceptOne, AIM and ImageRight will be preferred.
• Lead AI-first transformation – Build and scale AI solutions that redefine industries
• Make an impact – Drive change for global enterprises and solve business challenges that matter
• Accelerate your career — Gain hands-on experience, world-class training, mentorship, and AI certifications to advance your skills
• Grow with the best – Learn from top engineers, data scientists, and AI experts in a dynamic, fast-moving workplace
• Committed to ethical AI – Work in an environment where governance, transparency, and security are at the core of everything we build
• Thrive in a values-driven culture – Our courage, curiosity, and incisiveness, built on integrity and inclusion, allow your ideas to fuel progress

Compensation

The approximate annual base compensation range for this position is $80,000 to $100,000. The actual offer, reflecting the total compensation package plus benefits, will be determined by a number of factors which include but are not limited to the applicant’s experience, knowledge, skills, and abilities; geographic location; and internal equity.

Additional information

Location-based Roles: Chicago area candidates are preferred for this role.

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 respect and integrity, customer focus, and innovation.

Furthermore, 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.