Master Data Management Engineer

Hub International Insurance • Chicago, GA

1d • Hybrid

About The Position

HUB International is seeking a Master Data Management Engineer, on our Enterprise Data & Analytics team. They 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.

Requirements

• 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
• 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
• 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
• 5-7 years of relevant experience

Nice To Haves

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

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

Benefits

• 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
• eligible annual bonuses, equity and commissions may be available for some positions

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level