At HUB International , we are a team of entrepreneurs. We believe in empowering our clients, and we do so by protecting businesses and individuals in our local communities. We help businesses evaluate their risks and develop solutions tailored to their needs. We believe in empowering our employees. As a global firm, we offer employees resources in both technology and industry expertise, but we still maintain the local flavor of our offices. 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 the 5th largest global insurance and employee benefits broker, providing a boundaryless array of property, casualty, risk management, life and health, employee benefits, investment and wealth management products and services. With over 17,000 employees in more than 550 offices throughout North America, HUB has grown substantially, in part due to our industry leading success in mergers and acquisitions.
ABOUT THE JOB
HUB International is seeking a Data Architect . This new role will primarily be responsible for the discovery, design, build and execution of complex data integration efforts to support next generation digital transformation at HUB.
This role will be responsible for delivering a strategic solution on the Azure platform and will provide advanced advisory and technical requirement consultation as an internal SME, representing both Enterprise Architecture strategy and technical design requirements of Enterprise Data & Analytics.
RESPONSIBILITIES
Responsible for design, development, and implementation of the engineering and architecture of a new platform, including database applications and solutions for managing and integrating data between operational systems, data repositories, and reporting and analytical applications. This includes but is not limited to ETL, stored procedures, views, and functions.
Analyze, design, develop, implement, and maintain technical solutions in Azure using data warehouse technologies, including Azure Data Factory, Azure Data Warehouse, Azure Synapse Analytics, Azure SQL DB, Azure Logic Apps, PowerBI and Azure Analysis Services.
Recommends and provide guidance regarding Data Integration and database development, best practices, and standards to the development team members as needed.
Create and propose technical design documentation which includes current and future functionality, database objects affected, specifications, and flows/diagrams to detail the proposed database and/or Data Integration implementation.
Develops and maintains an understanding of the business processes and the technology platforms that are required for integration.
Understand and translate stakeholder s requirements into common language that can be adopted for the use with Behavior Driven Development (BDD) or Test Driven Development (TDD).
Participates in industry and other professional networks to ensure awareness of industry standards, trends and best practices in order to strengthen organizational and technical knowledge.
Works continually on improving performance of source code using industry standard methodologies.
Strong analytical and problem-solving skills and impeccable attention to detail
Proven ability to work independently in a deadline-driven environment.
Exceptional self-direction and project management skills.
Mentor junior team members in data architectures and best practices
Define technical approach documents (define calculated logic, process flow, etc.)
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, Test, 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
Prepare and present content to team members, stakeholders and executives as needed during project lifecycle
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
5+ years of experience with Microsoft and related data technologies at the expert level
Expert knowledge of SQL, PowerShell, DAX, M, and Data Analysis
Experience in building Power BI datasets and tabular models
Bachelor's degree in computer science or related field preferred 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 and Microsoft Certified Azure Solutions Architect Expert 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, Azure Synapse Analytics, Azure SQL DB, Azure Logic Apps, and Azure Analysis Services, Azure Databricks
Knowledge of Google Cloud and BigQuery environments as a data source for integration into ETL processes
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 JSON
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, SharePoint, PowerApps, Profisee and the O365 platform
Ability to meet 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
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.
Disclosure required under applicable municipal regulations in NY and NJ, as well as the law in Colorado: The expected salary range for this position is $125K to $145K 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 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, and eligible bonuses, equity and commissions for some positions.
Department Information Technology
Required Experience: 5-7 years of relevant experience
Required Travel: Negligible
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 at
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) ###-#### ...@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.