Summary
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.
Responsibilities
- 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
Skills
- 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
- 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.)
Qualifications
Must Haves
- 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
Nice to Haves
- 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