Role Description Frankenmuth Insurance is seeking a motivated individual to join our Finance Modernization & Automation team for a year-round internship opportunity. This position can be in office or remote. As an intern at Frankenmuth Insurance, you will have a chance to gain hands-on experience assisting the Finance Modernization & Automation team on a variety of projects. Primarily you will have the opportunity to assist with modernizing and automating financial data processes. The ideal candidate is curious, detail-oriented, and eager to apply analytical and technical skills to solve real-world business problems. This role will involve: - Collaborating with cross-functional teams - Addressing and supporting the company’s commitment to maintaining accurate, transparent, and compliant business practices Qualifications - Students should be currently enrolled and entering their sophomore-senior year in college - Preferred major is Data Analytics, Accounting, Auditing - Ability to organize data, manage multiple tasks and make decisions independently - Able to communicate effectively - Attention to detail Requirements - A minimum requirement for this position is the ability to work legally in the United States - No visa sponsorship/support is available for this position, including for any type of U.S. permanent residency (green card) process

• Become a trusted data and AI advisor to our clients • Work independently as part of a small team to solve complex data engineering use-cases • Design and implement AI-optimized data platforms • Build and evolve semantic and analytical layers that power various tools • Use modern platforms and tooling to deliver scalable solutions • Engineer modern ELT/ETL pipelines • Design modern data models • Write production-ready code in SQL, Python, and Spark • Apply AI-assisted data engineering techniques • Contribute to the evolution of our AI-forward data engineering and infrastructure practice • Collaborate with analytics, data science, and ML project teams

• Build, expand, and optimize data infrastructure in order to create the most accurate dataset of identities and their relationships • Develop and operate secure, scalable, and reliable data ingestion and ETL/ELT pipelines that meet product requirements • Design and maintain a data observability framework to ensure our data meets strict quality and freshness standards • Optimize data storage layer and build/maintain interfaces to enable scalable and fast data access to our data stores • Collaborate with product teams (squads) supporting their data platform needs for smooth delivery of existing and new products • Participate in call rotation for production issues, along with the rest of engineering • Mentor junior engineers and contribute to our evolving engineering best practices • Drive innovation by actively participating in our hackathons and doing proof of concepts • Develop functional subject matter expertise within various areas of identity fraud domain

• Build and maintain data pipelines for marketing and analytics use cases • Develop the data warehouse and analytics platform • Work on data quality: monitoring, consistency, and completeness checks • Integrate new data sources: APIs, internal databases, files, and event data • Contribute to the semantic layer and prepare data for BI • Work closely with analysts and business teams on reporting and analytical tasks