Jr. Data Analyst Jobs

DEPARTMENT: Underwriting & Rating
POSITION: Junior Data Analyst
REPORTING TO: Director of Underwriting & Rating
Classification: Non-Exempt
We are looking for an entry-level Data Analyst to join our Underwriting team. This individual will work extensively in excel by creating complex spreadsheets, reports, and automated processes. The successful candidate will turn data into information, information into insight, and insight to facilitate business decisions. This role will collaborate with the Underwriting and Rating and other internal and external teams to help troubleshoot, build, and solve processes.
Job Duties

• Drive product launches and follow-up measures such as cost analysis and comparisons
• Routinely conduct analysis of data for assigned clients, assisting team members as necessary
• Perform underwriting research, assessments, and rate risks for our products
• Develop and maintain data validation tools to ensure data accuracy
• Create and maintain complex Excel spreadsheets to manage data and automate processes
• Collaborate with team members to troubleshoot and resolve any data-related issues
• Become an expert on the current processes and tools and offer feedback to achieve more optimal outcomes
• Implement data integrity and normalization initiatives while overseeing ad hoc management reports.
• Partner with internal and external team members to provide expertise for data related to our platform and products

Job Qualifications

• Knowledge of the automotive industry and auto warranty space a plus
• Advanced Microsoft Excel Experience: Visualizations, Pivot Tables, Macros, Vlookup, & Index/Match VBA experience a plus
• Excellent written and verbal communication skills
• Great time management skills
• Associate or bachelors degree preferred in business administration or related field
• Team oriented
• Strong attention to detail and time management skills
• Familiarity with MS SQL Server Management Studio