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.