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 20000 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 Position

• HUB International is seeking an Information Management Engineer on our Enterprise Data & Analytics team. The Information Management Engineer will primarily be responsible for the metadata management and engineering of the MDM platform of our Enterprise Data & Analytics environment.

• This role will work closely with our Business Data Enablement and Data Governance teams to support our master data management efforts.

RESPONSIBILITIES

• Design and maintain master data models across multiple data domains

• Build and maintain relationship models between entities (e.g. Account Contact Product etc)

• Design and implement inbound and outbound integration pipelines between Profisee (MDM tool or any other MDM solution) and source/target systems (ERP CRM data warehouses)

• Integrate Profisee with cloud platforms including Azure Data Factory Azure SQL and BigQuery

• Build and maintain YAML-based object configuration files for source system mappings and field transformations

• Establish and maintain data stewardship workflows aligned to business ownership

• Plan coordinate develop and support master data management efforts including establishing new best practices in Azure Purview and GCP Dataplex environments

• Experience in performance engineering with Azure and GCP toolsets

• Develop cross validation rules to ensure information accuracy

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

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

• Experience in handling structured & unstructured data

• Expertise in Data Governance & Data Quality Services (including profiling metadata management data lineage) on Azure and GCP will be of critical advantage.

• 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 metadata in Azure Purview and GCP Dataplex 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 (REQUIRED AND PREFERRED)

• 5-10 years of experience in progressive data analyst and engineering roles

• Strong knowledge of structured and unstructured datasets

• Ability to set up and automate Azure Purview and GCP Dataplex platform-related activities using established connection methods

• Bachelors 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 Azure and GCP platforms in the past five years to present

• Microsoft Certified Professional in the Azure Data Engineering track is strongly preferred; GCP Professional Data Engineer certification is a plus

• Knowledge of best practices in enterprise wide information management implementation availability and security configuration

• Advanced experience with Azure data warehouse technologies including Azure Data Factory Azure Synapse Analytics Azure SQL DB Azure Logic Apps Azure Analysis Services and Azure Databricks; experience with GCP equivalents including BigQuery Dataflow Cloud Composer and Dataplex is strongly preferred

• Advanced understanding and comprehension of XML and XMLA

• Knowledge and direct experience working with Azure Purview Azure DevOps (formerly MTFS) SharePoint PowerApps and the M365 platform; experience with GCP tools including Vertex AI BigQuery and Cloud Composer is a plus

• 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 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 joinHUB International you will be part of a community of learners and doers focused on our Core Values: entrepreneurship teamwork integrity accountability and service.

Disclosure required under applicable law in California Colorado Illinois Maryland Minnesota New York New Jersey and Washington states: The expected salary range for this position is $ 10000 to $130000 and will be impacted by factors such as the successful candidates skills experience and working location as well as the specific positions business line scope and level. If you believe that your qualifications and experience surpass the minimum requirements for this role we encourage you to submit your application. By doing so we will be able to keep your application on file for consideration for potential future positions within our organization. HUB International is proud to offer comprehensive benefit and total compensation packages which could include health/dental/vision/life/disability insurance FSA HSA and 401(k) accounts paid-time-off benefits such as vacation sick and personal days and eligible bonuses equity and commissions for some positions.

HUB International Limited is an equal opportunity employer that does not discriminate on the basis of race/ethnicity national origin religion age color sex sexual orientation gender identity disability or veterans status or any other characteristic protected by local state or federal laws rules or regulations.

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 recruiting team. This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.