Tech Lead, Insurance & SQL - Tech Lead _ P&C

Staffing Agency Recruitment
  • Chicago, IL
    Today

    Job Description

    Job Description

    Job Description
    Industry: Financial Services - Commercial Banking
    Job Category: Information Technology - Other IT

    With a startup spirit and 110,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. Now, we’re calling all you rule-breakers and risk-takers who see the world differently and are bold enough to reinvent it. Come, transform with us.


    Role: Tech Lead, Insurance & SQL


    Location: Chicago IL (Hybrid)

    Duration: Fulltime


    In this role, we are seeking a highly motivated individual who possesses strong technical and analytical skills, with an understanding of the wholesale brokerage insurance industry preferred. The individual will be technical lead and is expected to work with business to understand requirements and support application, work with Developers, Business Analyst and QE team to ensure quality solution delivery. Effective collaboration with the business users and various stakeholders is required. Serves as mentor, advisor and guide to the team of developers.


    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 & support teams. Mentor team members. Technical/ functional guidance on the application.
    • Work on configuration changes.


    Requirements

    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 in 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.
    Candidate Details
    10+ to 15 years experience
    Seniority Level - Mid-Senior
    Management Experience Required - No
    Minimum Education - Bachelor's Degree
    Willingness to Travel - Occasionally




    Numbers & Facts

    LocationChicago, IL

    Skills

    • Accountingunmatched
    • Accounting Policiesunmatched
    • Agile Programming Methodologiesunmatched
    • Analysis Skillsunmatched
    • Application Programming Interface (API)unmatched
    • Atlassian JIRAunmatched
    • Automationunmatched
    • Billingunmatched
    • Brokerageunmatched
    • Business Analysisunmatched
    • Cloud Applicationsunmatched
    • Cloud Computingunmatched
    • Credit and Collectionsunmatched
    • Cross-Functionalunmatched
    • Data Qualityunmatched
    • Data Structuresunmatched
    • Database Administrationunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Financial Reportingunmatched
    • GCP (Good Clinical Practices)unmatched
    • Gitunmatched
    • ITIL (IT Infrastructure Library)unmatched
    • Industry/Trade Analysisunmatched
    • Insuranceunmatched
    • Internet Applicationunmatched
    • Kanbanunmatched
    • Mentoringunmatched
    • Microservicesunmatched
    • Microsoft Windows Azureunmatched
    • People Managementunmatched
    • Problem Solving Skillsunmatched
    • Production Supportunmatched
    • Reconciliationunmatched
    • Riskunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Databasesunmatched
    • SQL Server Integration Services (SSIS)unmatched
    • Scrum Project Management and Software Developmentunmatched
    • Service-Oriented Architecture (fka Distributed Object Architecture)unmatched
    • ServiceNowunmatched
    • Software Administrationunmatched
    • Startupunmatched
    • Sybase Powerbuilderunmatched
    • Systems Administration/Managementunmatched
    • Technical Analysisunmatched
    • Technical Leadershipunmatched
    • Technical Writingunmatched
    • Technical/Engineering Designunmatched
    • Test Plan/Scheduleunmatched
    • User Documentationunmatched
    • Wholesale Industryunmatched
    • Willing to Travelunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder