American Modern Insurance Group is a leader in the specialty insurance market, recognized for protecting various types of vehicles and properties. They are seeking a Summer Intern for Sales and Market Analytics to help improve digital assets, analyze data, and enhance reporting tools.
Review and make recommendations about existing dashboards and discuss best practices for creating interactive visual reports using Power BI with the team
Work with team members to identify key performance indicators (KPIs) with clear objectives and create/adjust dashboards to consistently monitor those
Analyze data and present data through reports that aid decision-making
Design, develop, test, and deploy Power BI scripts and perform detailed analytics
Perform DAX queries and functions in Power BI
Redefine and make technical/strategic changes to enhance existing Sales and Market Analytics team tools
Qualification
Required
Currently pursuing a bachelor's degree or graduate's degree
Graduation date between December 2024 and May 2026
Ability to work effectively with clients, interpreting their issues and translating them into workable solutions
Authorized to work in the United States of America
Candidates must be local (Cincinnati, OH) and will work in the office at least 2 days a week
Preferred
Information Systems, Computer Science, or related fields are preferred
Basic SQL knowledge strongly preferred
Exposure to coursework related to data management: data quality, metadata, data lineage would be ideal
Experience or coursework in use of the data visualization tools (PowerBI, Tableau, etc.)
Benefits
Gain hands on experience over 12 week summer program
Network with CEO, senior leaders, experienced teammates, and other interns to develop lasting professional connections
Flexibility in a hybrid world
Opportunity to gain professional and personal development
Participate in community outreach
Potential Full-Time career opportunities after graduation
American Modern companies provide insurance solutions for customers.