**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. **Necessary Skills:** + Proficiency using SQL to query data, strong knowledge of SQL Joins. + Proficiency using either SQL or Python to write data transformation/cleansing scripts. + Ability to communicate with agencies/business partners to get necessary data, while being mindful and respectful of their time. + Data mapping skills: the ability to make accurate data assumptions and get confirmations even when working with unfamiliar data. + Willing to learn and understand business data, so data is mapped and converted in a meaningful way. **Data Analyst Responsibilities:** + Manage all data related tasks for Conversions, including: + Data Collection + Work with agency and region pull initial data reports (extract SQL data when available) + Conduct initial Data Gap analysis and note any potential missing data or concerns about data quality. + Recollect data as many times and needed & work on transforming data & combine files as needed. + Data Mapping + Complete data mapping, possibly working with data entry team or third part vendor. + Answer any of the data entry team or third-party vendor’s initial questions and forward any remaining items to review and sign-off by business partners and/or acquired agency. + Confirm all mappings and keep track of any lingering and outstanding mapping questions before Go-Live. + Data Validation + Prepare and conduct at least two data validation sessions and make updates to mapping and data entry plans/instructions as needed. + Ensure all data mappings are 100% complete before Data Migration. + Data Migration + Work with data entry team and or third-party vender to ensure accurate data migration + Post Go-Live: + Manage any post Go-Live Date Entry & questions, including, but not limited too: + Communication with data entry team + Resolving any errors not caught during validation. + Policy Details + Attachments + Certificates **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 $100,000 to $110,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 M&A Required Experience: 2-5 years of relevant experience Required Travel: Negligible Required Education: High school or equivalent 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 http://www.dol.gov/ofccp/regs/compliance/posters/ofccpost.htm . EEOAA Policy (https://hubinternational.jobs/eeo/) 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) 300-9193 or USRecruiting@hubinternational.com . This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.