Ignite your potential. Impact what matters.

Hi, we're HUB.

We advise businesses and individuals on how to reach their goals.

When you partner with us, you’re at the center of a vast network of risk, insurance, employee benefits, retirement and wealth management specialists that bring clarity to a changing world with tailored solutions and unrelenting advocacy.

So you’re ready for tomorrow.

Company Profile

HUB International was born in 1998 with the merger of 11 privately held insurance brokerages. Today, HUB is one of the largest insurance brokers in the world and represents a broad, deep, one-of-a-kind aggregation of insurance entrepreneurs.

13,000+

employees across North America.

5th

ranked among the world's largest insurance brokers.

450+

offices across North America.

HUB Mission

To protect and support the aspirations of individuals, families and businesses. To empower our employees to learn, grow and make a difference in their communities.

HUB Vision

To be everywhere risk exists—today and tomorrow. Helping Protect what matters most.

Our Core Values

  • Entrepreneurship - We encourage innovation and educated risk-taking.
  • Integrity - We do the right thing every time.
  • Teamwork - We work together to maximize results.
  • Accountability - We measure and take responsibility for outcomes.
  • Service - We serve our customers, communities and colleagues.

Why Choose HUB?

Throughout our network of more than 450 HUB offices in North America, we offer a competitive, exciting and friendly work environment that strategically positions our employees for longevity and success. At HUB, we believe in investing in the future of our employees, and provide continuous opportunities for growth and development. Our entrepreneurial culture fosters an environment that empowers our people to make the best decisions for our customers and organization, focusing on expanding the industry knowledge of our insurance professionals to better serve our valued clients. We are committed to providing you with competitive and flexible benefits options that are rooted in your current needs, yet evolves as your needs change over time. Join us in taking the first step toward creating a future that combines a diverse, challenging work environment with financial security and career satisfaction.

We are the perfect fit if you:

  • are seeking a progressive work environment at a rapidly growing organization
  • have a desire to help others protect their future
  • have an entrepreneurial spirit and are challenged by the opportunity to grow the business
  • are focused on learning and development to enhance your industry knowledge and expertise
  • are a self-starter willing to invest time and energy to learn the technical aspects of our business
  • believe in integrity and building success by developing relationships with others

Benefits

We offer a dynamic benefits program that is rooted in your current needs yet evolves as those needs change over time. We are committed to providing you with the tools and resources you need to maximize your benefits portfolio.

We believe in the value of a wellness strategy to build morale and support the personal health goals of our employees. We’re proud to offer our employees medical plans that not only provide coverage for illness and injury, but also enable you and your family to focus on staying well. Outside of offering a portfolio of medical plans to support our employees’ well-being, we’ve worked hard to build a comprehensive program reflecting our values and vision to boost engagement and motivation.

HUB Healthy Habits was created to educate, activate, and support employee engagement in total health and wellbeing, encouraging employees to put healthy ideas into action in and out of the office. On-site health committees lead in-office health initiatives, including monthly educational health and fitness activities.

  • Technology: Portal on the HUB intranet and mobile app delivers health campaigns and contests.
  • Tools: Break rooms designed by our employees outfitted with balls, bands, and light weights.
  • Healthy challenges: Challenges and campaigns with prizes for meeting fitness and nutrition goals.
  • Health screening & coaching: Track your health and performance. Health coaches are available to all employees.

Retirement savings plans: You choose how much to deposit each pay period and how your money is invested.

Travel accident insurance: HUB’s Travel Accident benefit covers injuries and death sustained during business travel. We also provide 24/7 access to personal and emergency assistance when you are traveling for business or personal reasons, including dependents traveling with you.

Flexible spending & parking and transit programs: Flexible spending accounts allow you to pay for eligible health and/or dependent care expenses on a pre-tax basis. You can also use pre-tax dollars to pay for parking and transit expenses and can enroll in the program at any point during the year.

MyHUB Discounts: All HUB employees have access to discounts on automotive, electronic, consumer, educational assistance, home security, travel, home, and work-life products and services.

Employee Assistance Program (EAP): We understand it can be difficult to manage family, work-related and personal issues. That’s why we offer an EAP at no cost to you. To help guide you through difficult situations or simply assist you with day-to-day tasks like finding a last-minute dog sitter, trained professionals work with you as you search for solutions. The program is completely confidential and can help you work through issues related to: emotional well-being, family life, healthy living, and legal or financial matters.

Group auto & home insurance: You have the option of purchasing personal lines of auto and home insurance at discounted rates.

Group legal plan: You have the option of enrolling in the group legal plan. This plan provides access to legal assistance for matters concerning estate planning, real estate, family law, consumer protection and more.

Other voluntary extras include: critical illness insurance, accident insurance, group indemnity insurance, long-term care coverage, and more.

Job Map

{{ pagination.total }} {{seoJobDescription}}

Current Search Criteria:

Commute Options

Senior Data Engineer, Enterprise Analytics | HUB Jobs

available here at <a href="http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm" target="_blank"> http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm </a> .</p><p style="text-align:inherit"></p><p style="text-align:left"><a href="https://hubinternational.jobs/eeo/" target="_blank">EEOAA Policy</a></p><p style="text-align:inherit"></p><p style="text-align:left"><a href="https://hubinternational.jobs/e-verify/" target="_blank">E-Verify Program</a></p><p style="text-align:left">We endeavor to mak
(844) 300-9193 or <a href="mailto:USRecruiting@hubinternational.com" target="_blank"> USRecruiting@hubinternational.com </a>. This contact infor

Job Information

Hub International Senior Data Engineer, Enterprise Analytics in Chicago, Illinois

Position Summary:

HUB International is seeking a Senior Data Engineer, Analytic Infrastructure on our DnA Infrastructure team. The Senior Data Engineer, Analytic Infrastructure will primarily be responsible for the data, architecture, and model of our Enterprise Data & Analytics environment.

This role will maintain the current data warehouse solution and be an active participant in the decommissioning of legacy solutions.

Responsibilities:

  • Expert knowledge in SQL, ETL architecture, data modeling, data architecture and BI architecture

  • Plan, coordinate, develop and support data model development including architecting table structure, building ETL process, documentation, and long-term preparedness

  • Analyze, design, develop, implement, and maintain technical solutions in Azure using data warehouse technologies, including Azure Data Factory, Azure Synapse (aka Azure Data Warehouse), Azure Synapse Analytics, Azure SQL DB, Azure Logic Apps, and Azure Analysis Services

  • Assist in machine learning projects that have a dependency on Azure Databricks

  • Develop cross validation rules to ensure data accuracy

  • Define technical approach documents (define calculated logic, process flow)

  • Meet business requirements of the projects as new data sources are added

  • Provide production support for existing data pipelines and models

  • Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production

  • Provide regular project updates to shared team resources and management as needed

  • Communicate issues, risks, and concerns proactively to management and engage colleagues while working in a hybrid Agile/Scrum process

  • Document pipelines thoroughly to allow peers to assist with support as needed

  • Provide technical assistance and task delegation to a flexible team of staff engineers, consultants, and interns in close coordination with team Managers and Directors

Qualifications:

  • 10-15 years of experience in progressive data engineering roles

  • Strong knowledge of SQL, PowerShell, DAX, M, and Data Analysis

  • Experience in building Power BI datasets and tabular models

  • Ability to set up and automate Power BI platform-related activities using scheduled refresh, subscriptions and power automate

  • Bachelor's degree in computer science or related field and five plus years’ experience in information technology or equivalent progressive experience with data engineering and data warehouse technologies with a focus on the Azure platform in the past five years to present

  • Microsoft Certified Professional in the Azure fundamentals track is strongly preferred

  • Knowledge of best practices in enterprise wide database implementation, availability and security configuration

  • Advanced experience with Azure using data warehouse technologies, including Azure Data Factory, Azure Synapse (aka Azure Data Warehouse), Azure Synapse Analytics, Azure SQL DB, Azure Logic Apps, and Azure Analysis Services, Azure Databricks

  • Knowledge of T-SQL, DAX, the Dataverse, relational database technologies and related information technology

  • Experience in the Kimball method of database design and OLAP technology

  • Advanced understanding and comprehension of XML and XMLA

  • Experience in relational and multi-dimensional databases as well as 2-tier and 3-tier architecture. Versed in designing and overall strategy with business intelligence systems in the Microsoft Azure ecosphere

  • Knowledge and direct experience working with Azure Purview, Azure DevOps (formerly MTFS), SharePoint, PowerApps, and the M365 platform

  • Ability to function under close deadlines with minimal supervision and under potentially stressful situations

  • Superior oral and written communication skills; capacity to explain complex solutions to non-technical business, process, and solution owner-partners internally, along with corporate executives, directors, managers, staff, and contractors

  • Both educate and inform to a wide range of audiences; advanced documentation skills to track feedback and action items through the entire project lifecycle

  • Nights, weekends, and non-regular hours may be required to deploy and make ready solutions that require support and collaboration from resources globally

Join a Winning Team at HUB International

When you join the team at HUB International, you become part of the 5th largest global insurance broker, providing a broad array of property, casualty, risk management, life and health, employee benefits, investment and wealth management products and services. Becoming a part of HUB means that you thrive in an entrepreneurial and fast paced team environment supported by over 12,000 professionals in 450 offices across North America. You will be able to actively contribute to our track record of year over year growth fueled by innovative new products and services, mergers and acquisitions, and a great team of people. As part of our talent engine, you will exemplify our strong core values which drive our unique corporate culture. HUB’s entrepreneurial spirit is evident in our people, products and philanthropic initiatives and we are passionate about our talent!

#LI-MH1

Department Information Technology

Required Experience: 7-10 years of relevant experience

Required Travel: No Travel Required

Required Education: Bachelor's degree (4-year degree)

HUB International Limited is an equal opportunity and affirmative action employer that does not discriminate on the basis of race/ethnicity, national origin, religion, age, color, sex, sexual orientation, gender identity, disability or veteran's status, or any other characteristic protected by local, state or federal laws, rules or regulations. The EEO is the Law poster and its supplement is available here athttp://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm.

EEOAA Policy

E-Verify Program

We endeavor to make this website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the US Recruiting Team toll-free at (844) 300-9193 orUSRecruiting@hubinternational.com. This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.

Hi, we’re HUB.

In a rapidly changing world, we advise businesses and individuals on how to prepare for the unexpected.

When you partner with us, you're at the center of a vast network of experts who will help you reach your goals through risk services, claims management, and compliance support.

And this gives you the peace of mind that what matters most to you will be protected — through unrelenting advocacy and tailored insurance solutions that put you in control.

About HUB International

Headquartered in Chicago, Illinois, HUB International Limited (HUB) is a leading full-service global insurance broker providing property and casualty, life and health, employee benefits, investment and risk management products and services. From offices located throughout North America, HUB’s vast network of specialists provides peace of mind on what matters most by protecting clients through unrelenting advocacy and tailored insurance solutions. For more information, please visit hubinternational.com.