Smart AutoCare
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
- Perform underwriting research, assessments, and rate risks for our products
- Create and maintain complex Excel spreadsheets to manage data and automate processes
- Collaborate with team members to troubleshoot and resolve any data-related issues
- Develop and maintain data validation tools to ensure data accuracy
- Partner with internal and external team members to provide expertise for data related to our platform and products
- Routinely conduct analysis of data for assigned clients, assisting team members as necessary
- Implement data integrity and normalization initiatives while overseeing ad hoc management reports.
- Drive product launches and follow-up measures such as cost analysis and comparisons
- Become an expert on the current processes and tools and offer feedback to achieve more optimal outcomes
Job Qualifications
- Associate or bachelor’s degree preferred in business administration or related field
- 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
- Familiarity with MS SQL Server Management Studio
- Strong attention to detail and time management skills
- Excellent written and verbal communication skills
- Great time management skills
- Team oriented
Source ⇲
