Master Data Management Engineer

About Us

HUB International is a global insurance and employee benefits broker. We provide a broad range of products and services including business insurance, employee benefits, risk services, personal insurance, retirement, and private wealth management. With over $5 billion in revenue and nearly 20,000 employees in 600 offices across North America, HUB has experienced significant growth, partly due to its success in mergers and acquisitions.

About the Position

HUB International is seeking a Master Data Management Engineer for our Enterprise Data & Analytics team. This role involves designing and maintaining master data models, building and implementing integration pipelines, and integrating with cloud platforms. Key responsibilities also include developing cross-validation rules, defining technical approach documents, and documenting metadata in Azure Purview and GCP Dataplex.

Responsibilities

• Design and maintain master data models across multiple data domains
• Build and maintain relationship models between entities (e.g., Account, Contact, Product)
• Design and implement inbound and outbound integration pipelines between Profisee 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
• 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 performance engineering with Azure and GCP toolsets
• Expertise in Data Governance & Data Quality Services (including profiling, metadata management, data lineage) on Azure and GCP

Requirements

• 5-10 years of experience in progressive data analyst and engineering roles
• Strong knowledge of structured and unstructured datasets
• 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 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
• 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 XMLAKnowledge 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

Qualifications

• 5-7 years of relevant experience
• No travel required
• Bachelor's degree (4-year degree)

Benefits

The expected salary range for this position is $120,000 to $150,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 offers 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.

Department Information

Required Experience: 5-7 years of relevant experience
Required Travel: No Travel
Required Education: Bachelor's degree (4-year degree)

Equal Opportunity Employer

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 veteran's status, or any other characteristic protected by local, state or federal laws, rules or regulations.