General Description: The Technical Analyst will be responsible for creating data files, auditing the data in COMET as needed to ensure the policy level detail is accurate, by carrier, by coverage and by commission type. The Technical Analyst will spend 10% processing commission statements or resolving inquiries tied to carrier updates and 90% of their time working on data changes.

Responsibilities:

Work with management across the company to create data files and reports as neededComplete and deliver accurate reports using the Formsite as requested by the Ops Teams and Account ExecutivesRefresh monthly queries to provide data files to specific agents and agencies, reports are time sensitiveCreate bulk uploads to assist the Commissions Department as well as the Operations Teams, the uploads track changes, block transfers, policy # changes, commission type changes, these changes are all created throughout the month to facilitate commission processingIdentify data clean-ups as neededPoint person for specific reporting needsResolve data discrepancies, audit uploads as they are being createdResolve commission inquiries that are assigned thru SharePoint or created as a result of a change in Commission or Agent change

 Knowledge, Skills and Abilities:

Expert Level Excel Skills (VLOOKUP, PIVOT TABLES, MACROS)Strong attention to detailTime Management SkillsAbility to stay organized and focused in a busy environmentGood oral and written communication skillsProfessional and dependableDemonstrates cooperation and collaboration in a team settingExperience with Microsoft Excel Queries (large data files, formatting, formulas)3+ years working in a similar environmentBachelor's degree required