Information Management Engineer

Hub International Insurance•Chicago, IL

6h•$10,000 - $130,000•Hybrid

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.

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
Bachelor's degree (4-year degree)

Nice To Haves

Microsoft Certified Professional in the Azure Data Engineering track is strongly preferred
GCP Professional Data Engineer certification is a plus
experience with GCP equivalents including BigQuery, Dataflow, Cloud Composer, and Dataplex is strongly preferred
experience with GCP tools including Vertex AI, BigQuery, and Cloud Composer 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