Dynamics 365 Data Analyst & Migration Specialist

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 the 5th largest 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 20,000 employees in 600 offices throughout North America, HUB has grown substantially, in part due to our industry leading success in mergers and acquisitions.

CRM Data Analyst & Migration Specialist

We have an opportunity for a skilled data migration professional to join a dynamic team that is building out HUB’s next generation wealth and retirement platform. We seek an experienced professional who can quickly establish relationships with, and elicit requirements from, busy stakeholders; and who also has the hands-on technical skills to build and execute data migration solutions. This person will execute multiple migrations from various platforms into Microsoft Dynamics 365. The successful candidate will take the lead in evaluating the current state of data in the source systems and drive a successful end-to-end migration. This involves understanding the data structure in both source and target systems, extracting the necessary information, transferring the data accurately, mapping it appropriately and ensuring all elements are included. The Migration Specialist should have experience with data migration tools and be proficient in Dynamics 365. In our fast-paced, entrepreneurial environment, creative problem-solving skills and superb communication are a must. Attention to detail is crucial. The right candidate will be a natural collaborator and demonstrate the ability to work and think independently.

The Migration Specialist will work closely with the project team to understand business requirements and translate them into technical solutions when it comes to data migration.

Responsibilities:

• Work closely with business subject matter experts to derive data extraction and mapping requirements from overall business requirements;
• Provide technical expertise and guidance for the data migration process to Dynamics CRM 365;
• Ensure that extracts are thorough and accurate; develop process to clean up data inconsistencies in preparation for load into target system;
• Assist with testing, deployment and support activities;
• Develop playbook that standardizes the data migration approach for 70+ source systems;
• Become subject matter expert of custom data mapper tool currently built in Microsoft Dynamics CRM DEV environment for documenting the field mappings and tracking the status of the data migration / integration effort. 
• Build SQL Scripts, views and stored procedures. Use SQL scripts to combine the source data into views to merge tables together then using stored procedures to move the data into the staging tables; and
• Collaborate with various teams at HUB to ensure successful project delivery.

Qualifications:

• Bachelor’s degree;
• 8+ years of experience; including at least 2 years in client or stakeholder direct-facing role
• Experience with Microsoft Dynamics 365;
• Experience with data mapper tools;
• Ability to build SQL scripts;
• Knowledge of SSMS;
• Experience with Azure SQL;
• Advanced Microsoft Excel knowledge;
• Excellent analytical and problem-solving skills;
• Strong communication and interpersonal skills; and
• Ability to work independently and as part of a team.

Preferred Qualifications, Not Required:

• Consulting experience with client relationship management responsibilities
• Large enterprise transformational project experience
• Experience with wealth management CRM platforms i.e. Red Tail, Salesforce, etc.;
• Experience with Microsoft Power Platform (including Power Automate);
• Experience with Kingswaysoft; and/or
• Experience with Visual Studio.

Travel

• Will require travel to various offices at HUB International located throughout the U.S. as needed during the project term to work with the local teams and their data.

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 join HUB 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 $70,000 to $90,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. 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.

Department Sales

Required Experience: 7-10 years of relevant experience

Required Travel: Up to 25%

Required Education: Bachelor's degree (4-year degree)

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.

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