Jobs in the United States

25+ jobs

Group jobs by employerEmail me new jobs Save this search

Added 2 mins ago
Senior Program Manager Hypersonics
GE Aerospace
Bohemia, NY
…production of advanced jet engines, components, and integrated systems that power commercial and military aircraft. You will be part of a team that embraces your drive, your curiosity, and…
Added 2 mins ago
Advanced Product Development Systems Staff Engineer – Hardware Cost and Weight Focal
GE Aerospace
Evendale, OH · Lynn, MA
The Advanced Product Development (APD) Systems Staff Engineer will lead elements of the systems design and development for an Edison Works New Product Introduction (NPI) program NGP3 as an…
Added 2 mins ago
GA
Lynn Advanced Programs - Lead Mechanical Design Engineer
GE Aerospace
Lynn, MA
- $109,250 to $146,050 USD / year
…production of advanced jet engines, components, and integrated systems that power commercial and military aircraft. You’ll be part of a team that embraces your drive, curiosity, and unique…
Added 2 mins ago
Advanced Product Development (APD) Systems Staff Engineer - Turbomachinery Systems Eng
GE Aerospace
Evendale, OH · Lynn, MA
The Advanced Product Development (APD) Systems Staff Engineer will lead elements of the systems design and development for an Edison Works New Product Introduction (NPI) program NGP3 as an…
Added 2 mins ago
GA
Staff Software Certification Engineer
GE Aerospace
Grand Rapids, MI · Clearwater, FL · Dayton, OH
- $130,000 to $173,000 USD / year
The Staff Software Certification Engineer will lead the software certification efforts for aircraft certification planning as well as regulatory compliance oversight for assigned projects…
Added 2 mins ago
Senior Program Manager Hypersonics
GE Aerospace
Bohemia, NY · Rockledge, FL
…production of advanced jet engines, components, and integrated systems that power commercial and military aircraft. You will be part of a team that embraces your drive, your curiosity, and…
Added 3 mins ago
GA
Project Engineer
GE Aerospace
Norwich, NY
- $72,000 to $90,000 USD / year
As a Project Engineer in Norwich, NY, you will enhance and broaden your practical knowledge of product design and development by leading a New Product Development (NPD) project through…
Added 3 mins ago
Advanced Lead Design for Manufacturing Engineer
GE Aerospace
Evendale, OH
…production of advanced jet engines, components, and integrated systems that power commercial and military aircraft. You’ll be part of a team that embraces your drive, your curiosity, and…
Added 3 mins ago
Advanced Programs - Lead Engineer, Hot structures Mechanical Design
GE Aerospace
Lynn, MA
The lead engineer for hot structures mechanical design will be the hardware owner responsible for all aspects of design and development of assigned hot structures components as a part of…
Added 3 mins ago
Metallic Additive Materials Application Engineer
GE Aerospace
West Chester, OH
The Metallic Additive Materials Application Engineer provides materials expertise and technical leadership for multiple materials across a variety of additive components. As a part of GE…
Added 3 mins ago
Staff Model Based Systems Engineer
GE Aerospace
Evendale, OH · Lynn, MA
The Staff Model Based Systems Engineer will oversee a cross-functional engineering discipline centered on an approach, mindset, and process. This role will lead all digital aspects for an…
Added 3 mins ago
Lead Engineer - Mechanical Component
GE Aerospace
Evendale, OH
The Lead Engineer for Mechanical Components will manage activities contributing to the design and development of products, solutions and systems. Includes activities linked to technical…
Added 3 mins ago
GA
Project Engineer
GE Aerospace
Bohemia, NY · Rockledge, FL
- $134,000 to $178,000 USD / year
This is a project lead and individual contributor role at the center of hypersonic propulsion development. As Project Engineer, you will work with the Program Manager to lead the design and…
Added 3 mins ago
Power Plant Operator (3rd Class Engineer License Required)
GE Aerospace
Lynn, MA
Rotating Shift · Ability and Willingness to work rotating shifts
Added 3 mins ago
Advanced Staff Engineer - Power Electronics
GE Aerospace
Dayton, OH
The Advanced Staff Engineer – Power Electronics will lead the design, analysis, development, and technical maturation of high-performance power-electronics systems. This includes power…
Added 3 mins ago
XBAT AVEN Mechanical Design Advanced Lead Engineeer
GE Aerospace
Evendale, OH
In partnership with Shield AI on the XBAT program, GE Aerospace is advancing F110 propulsion system integration for next-generation autonomous aircraft, with emphasis on development of an…
Added 3 mins ago
GA
Advanced Lead Engineer - RF Microsystems - GE Aerospace Research
GE Aerospace
Niskayuna, NY
- $112,000 to $186,000 USD / year
The Microsystems team at GE Aerospace Research is looking for candidates who are interested in the research and development of RF Microsystems and their integration into aerospace products.…
Added 3 mins ago
XBAT Mechanical Systems Design Advanced Lead Engineer
GE Aerospace
Evendale, OH · Lynn, MA
As an XBAT Mechanical System Advanced Lead Engineer at GE Aerospace, you will lead the design, procurement, and development of lubrication system components for the F110 engine as a module…
Added 3 mins ago
Lead Engineer - Electronic Hardware
GE Aerospace
Jacksonville, FL
We are seeking an Electronics Engineer to support hardware with a focus on PCB-based RF and power electronics, including transformer and converter design, testing, and repair. The ideal…
Added 1 hour ago
Sr Associate Engineer/ Engineer, IT AI
American Airlines
Fort Worth, TX
…research, design, engineering, application, and governance of AI systems. Within the AI domain, professionals work on developing intelligent algorithms and data-driven solutions to solve…
Added 1 hour ago
Sr Associate Engineer/ Engineer, IT AI
American Airlines
Fort Worth, TX
…research, design, engineering, application, and governance of AI systems. Within the AI domain, professionals work on developing intelligent algorithms and data-driven solutions to solve…
Added 1 hour ago
Sr Associate Engineer/ Engineer, IT AI
American Airlines
Fort Worth, TX
…research, design, engineering, application, and governance of AI systems. Within the AI domain, professionals work on developing intelligent algorithms and data-driven solutions to solve…
Added 1 hour ago
EC
Chief Power Electronics Engineer
Eaton Corporation
Austin, TX
- $154,000 to $225,000 USD / year
Eaton’s Critical Power Solutions (CPS) team has an exciting and rewarding position of a Chief Power Electronics Systems Engineer available in Austin, TX! Relocation assistance is provided…
Added 1 hour ago
Senior Consultant, Transmission Advisory
Jacobs
Dallas, TX · Houston, TX · Austin, TX · San Antonio, TX
In this role, you will bridge the gap between traditional power systems engineering and advanced energy economics to provide holistic support to clients from a reliability and market…
Added 1 hour ago
Electrical/I&C Component Engineer
Duke Energy Carolinas, LLC
York, SC
However, hybrid employees must live within a reasonable commute to their designated Duke Energy facility, not greater than 50 miles one way · Hybrid work arrangement: after onboarding, employees must work onsite at Catawba Nuclear Station at least two days per week, with two remote days

Closed listing

Hub International Limited

BMS Conversion Lead, Specialty Lines

Chicago, IL, United States

This opening has closed.

The original listing is kept below for reference.

Find open jobs More jobs with this employer

About employer

Job details

Pay: The expected salary range for this position is $ 110,000 to $135,000 and will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level.
Experience: 5+ years of hands-on data engineering experience, with demonstrated ability to extract, transform, and load data from relational databases using Python and SQL
Posting language: English
Posted: Nov 4, 2026

Similar jobs hiring now

Search current openings

Original job description

Archived listing. The details below describe a past opening.

A path for every ambition.

At HUB, we believe the best work happens when people are given real space to grow and then given the autonomy to exercise it. We power progress and protect ambition: for the clients who count on us, and equally for the people who make that possible every day. We’re creative thinkers and determined doers, guided by values that show up in how we work together: with empathy, adaptability, accountability and a genuine commitment to one another’s success. We foster bold ideas, celebrate curiosity and share what we know. Because when people grow, the work they do grows with them.

Our purpose is deeply human: to help people navigate the world on their terms, at their speed, toward their future. We hold that same commitment to the people building careers here.

Whether you’re starting out or leveling up, you’ll find the resources to evolve, the support to take on more and a team ready to back you at every stage.

Your ambition has a home here.

ABOUT US

At HUB International, we are a team of entrepreneurs. We believe in protecting and supporting the aspirations of individuals, families, and businesses. We help our clients evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees to learn, grow, and make a difference. Our structure enables our teams to maintain their own unique, regional culture while leveraging support and resources from our corporate centers of excellence. HUB is a global insurance and employee benefits broker, providing a boundaryless array of business insurance, employee benefits, risk services, personal insurance, retirement, and private wealth management products and services. With over $5 billion in revenue and almost 20,000 employees in 600 offices throughout North America, HUB has grown substantially, in part due to our industry leading success in mergers and acquisitions

About the Role

Hub International’s M&A Integration (MAI) team is seeking a Lead Engineer to drive the technical execution of BMS migration projects for MGA acquisitions. This is not a conventional data engineering role. Success here requires equal parts technical fluency and investigative curiosity - the ability to reverse-engineer unfamiliar systems, surface ambiguity proactively, and drive decisions to closure without waiting to be told what to do.

As the technical lead, you will define the engineering approaches, tooling, and standards used across SPG’s AIM and Imageright migration program. You will mentor a team of engineers, own escalations, and serve as the primary technical bridge between migration analysis (business-to-technical translation) and delivery. You will be expected to operate confidently in under-specified environments where source data is murky, documentation is thin, and the fastest path forward requires asking the right questions of the right people.

This role also requires a genuine comfort with AI-augmented workflows. SPG’s migration practice leverages AI tools - including large language models - as a force multiplier at every stage: schema analysis, transformation logic, mapping specification review, SQL generation, and documentation. The right candidate sees this as an advantage and builds it into their process, not as a novelty to be evaluated later.

Occasional weekend availability is required to support go-live events.

What You’ll Do

Responsibility Area Approx. Time Migration Engineering & Technical Execution 40% Technical Leadership, Standards & Mentorship 30% Stakeholder Engagement & Ambiguity Resolution 20% Documentation, Methodology & Continuous Improvement 10%

Migration Engineering & Technical Execution (40%)

Design and build multi-stage Python extraction pipelines from source BMS databases (MySQL, PostgreSQL, MS SQL Server) to target defined SQL output, preserving raw pull integrity and applying transforms as a separate, auditable layer
Implement AIM and IR mapping specifications produced by the Migration Analyst, translating field-level business rules into production-grade SQL and Python with validation assertions
Build and maintain the SPG migration platform: source crawlers, schema extractors, transformation modules, consistency gates, and pre-Vertafore validation tooling
Write optimized SQL across multiple dialects to extract, join, and stage data from legacy insurance systems with incomplete or undocumented schemas
Diagnose and resolve data quality issues surfaced during QA cycles; identify root cause at the schema or transform level before proceeding
Ensure all engineering output is reproducible, version-controlled, and structured to support iterative QA loops with Vertafore

Technical Leadership, Standards & Mentorship (30%)

Define the engineering approaches, tooling choices, and quality standards that the SPG data engineering team uses across all BMS migration engagements
Serve as the technical escalation point for the team; when engineers are stuck or producing incorrect output, diagnose the problem and correct the approach
Mentor data engineers on SQL patterns, Python best practices, schema analysis methodology, and the investigative mindset required to succeed in ambiguous migration environments
Review engineering output before it reaches validation or external delivery; own the quality gate
Drive adoption of AI-augmented workflows across the team - modeling how to use tools like Claude to accelerate schema analysis, code generation, and documentation without sacrificing rigor

Stakeholder Engagement & Ambiguity Resolution (20%)

Proactively surface questions about source data, business rules, and migration scope - before they become blocking issues - through direct engagement with source system SMEs and operations stakeholders
Drive clarification conversations to a decision, not a parking lot; distinguish between questions that need a business answer and questions that can be resolved through schema investigation
Translate technical findings into clear, actionable language for non-technical stakeholders; communicate what the data shows, what it implies operationally, and what decision is needed
Partner with the Migration Analyst to validate that mapping specifications are technically feasible before engineering begins; flag risks early
Engage directly with Vertafore and other third-party vendors on data format requirements, load specifications, and QA feedback resolution

Documentation, Methodology & Continuous Improvement (10%)

Maintain and improve SPG’s migration engineering playbooks, runbooks, and reusable tooling so each project builds on the last
Extract generalizable patterns from project work and codify them as reusable standards rather than one-off solutions
Contribute to post-migration retrospectives with the goal of reducing average timeline and improving first-pass QA quality

Ongoing Responsibilities

Manage concurrent BMS migration engagements at different project stages; maintain momentum across multiple active workstreams
Participate in team and stakeholder meetings with a bias toward resolution - come prepared, identify what is blocking progress, and leave with clear next steps
Support go-live events with weekend availability as needed; monitor post-load data quality and resolve post-migration data issues quickly
Stay current with Vertafore AIM platform capabilities and ingestion requirements as the platform evolves

What You Bring

Required Qualifications

5+ years of hands-on data engineering experience, with demonstrated ability to extract, transform, and load data from relational databases using Python and SQL
Strong SQL proficiency across multiple dialects (MySQL, PostgreSQL, MS SQL Server); comfortable writing complex joins, subqueries, and schema investigation queries against undocumented databases
Fluency in Python for data pipeline development, including ETL scripting, automation, and data quality assertion logic
Experience working with insurance BMS platforms, with direct familiarity with Vertafore AIM data structures strongly preferred
Demonstrated ability to reverse-engineer unfamiliar systems by reading schemas, querying live databases, and cross-referencing against business context - without relying on complete documentation
Proven track record of driving ambiguous projects to clarity through proactive communication, targeted questioning, and independent investigation
Practical experience using AI tools (LLMs such as Claude, ChatGPT, or similar) as a productivity tool in technical work - for code generation, documentation, schema analysis, or data review
Experience in a technical lead, senior, or principal engineering role with responsibility for mentoring others and setting technical direction

Preferred Qualifications

Direct experience with BMS conversion projects in an MGA or wholesale insurance environment, including familiarity with MGA-specific data structures (surplus lines, bordereau, binding authority, policy fee accounting)
Familiarity with HUB’s SPG integration model and M&A acquisition workflows
Knowledge of ImageRight document migration workflows and file-system-based document ingestion patterns
Experience building validation tooling that allows business stakeholders to review transformed data before external system loads - reducing costly rework cycles
Background in data governance, source-of-truth discipline, and single-source build systems for migration specifications
Familiarity with carrier download processing or other insurance data interchange standards

JOIN OUR TEAM

Do you believe in the power of innovation, collaboration, and transformation? Do you thrive in a supportive and client focused work environment? Are you looking for an opportunity to help build and drive change in a rapidly growing and evolving organization? When you join HUB International, you will be part of a community of learners and doers focused on our Core Values: entrepreneurship, teamwork, integrity, accountability, and service.

The expected salary range for this position is $ 110,000 to $135,000 and will be impacted by factors such as the successful candidate’s skills, experience and working location, as well as the specific position’s business line, scope and level. HUB International is proud to offer comprehensive benefit and total compensation packages which could include health/dental/vision/life/disability insurance, FSA, HAS and 401(k) accounts, paid-time-off benefits such as vacation, sick, personal, floating holidays and company holidays. In addition, eligible annual bonuses, equity and commissions may be available for some positions.

What we offer you We invest in your growth. HUB offers structured training, licensing support, and ongoing development opportunities designed to accelerate your career. Benefits and programs vary based on employment status, role, location, and applicable eligibility requirements.

Competitive pay with comprehensive health benefits, retirement savings matching, and company-paid life and disability plans
Generous paid time off, paid parental leave and a wellbeing program designed to support real work/life balance
A collaborative, high-performing culture with meaningful engagement, community impact through HUB Gives and genuine room to grow your career

The HUB difference HUB International is one of North America’s largest insurance brokers, delivering risk management, insurance, employee benefits, retirement and wealth management solutions to businesses and individuals across the United States and Canada - through locally led teams backed by national expertise, giving you the agility of a local partner and the reach of a global organization.

Equal Employment Opportunity: HUB International Limited is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.

Reasonable Accommodations: HUB International Limited is committed to providing reasonable accommodations to qualified individuals with disabilities throughout the application and hiring process. If you need a reasonable accommodation to access our career site, complete an application, or participate in any part of the hiring process, please contact the Recruiting Team at HUBRecruiting@HUBInternational.com. This contact information is for accommodation requests only and should not be used to inquire about the status of an application.

E-Verify: HUB International Limited participates in E-Verify. Please refer to Our Recruiting Process | Applicant Notices: E-Verify Program for additional information.

About employer

Report this job

Work requirements

Jobs in the United States