Reporting & Analytics Intern (Year-Round)

Charter Automotive; Mequon (WI); On-site; USD 28,000 - 36,000; Part time

Job summary

Charter Manufacturing invites applicants for a Reporting & Analytics Internship based in Mequon, WI. The role focuses on building automated financial dashboards, preparing management reporting, and performing ad hoc analyses to guide leadership decisions.

Ideal candidates are enrolled in Accounting or Finance and have strong Excel skills, with experience in Tableau/Power BI and SQL preferred. This paid internship offers mentorship and hands-on exposure to forecasting, budgeting, and KPI tracking.

Qualifications

• Enrollment in a four-year degree program in Accounting, Finance, or a related field with Sophomore status or higher.
• Cumulative GPA of 2.75 or higher.
• Proficient in Microsoft Office: Excel, Word, PowerPoint.
• Strong verbal and written communication and interpersonal skills.

Responsibilities

• Create and maintain automated financial reporting dashboards and datasets.
• Prepare management reporting packages that provide clear, actionable financial insights.
• Conduct ad hoc financial analyses to support leadership decision-making.
• Research industry trends and market insights to inform planning.
• Build scenario analyses to evaluate potential outcomes and support planning.
• Document data sources, reporting processes, and underlying logic.

Skills

Excel

Word

PowerPoint

Communication

Teamwork

Organizational skills

Attention to detail

Data analysis

Education

Accounting or Finance degree program

Tools

Snowflake

Tableau

Power BI

SQL

Excel (Advanced)

Job description

Charter Manufacturing is a fourth-generation family-owned business where our will to grow drives us to do it better. Join the team and become part of our family!Charter Manufacturing Company, Inc. is a family-owned group of differentiated metals manufacturing businesses founded in 1936. Our will to grow is our success. It is the result of Charter’s respected team of employees, each person’s dedication to continuous improvement and an entrepreneurial spirit that thrives within the Charter family. Our businesses include Charter Steel, Charter Casting, Charter Wire, and Niles Iron & Metal.About the Reporting & Analytics Internship:Build hands-on experience in financial planning and analysis, including budgeting, forecasting, variance analysis, management reporting, and KPI tracking. Strengthen your technical and analytical skills through advanced Excel, financial systems, data tools such as Snowflake, Tableau, and Power BI, and exposure to SQL, while developing business communication, problem-solving, and data-driven decision-making skills.Program Structure:Schedule: Part-time (15-20 hours/week) during the academic year and full-time (40 hours/week) during the summer.Location: Mequon, WIStart Date: May 2027Duration: Year-round internshipWhat we're looking for:Enrollment in a four-year degree program in Accounting, Finance, or a related field with current status of at least a Sophomore level.Cumulative GPA of 2.75 or higher.Proficient in Microsoft Office software: Excel, Word, and PowerPoint.Strong verbal and written communication skills.Strong interpersonal and relationship building skills.Ability to succeed in a team environment.Strong organizational skills with the ability to manage multiple priorities.Preferred experience:Accounting or Finance major with multiple related courses completed toward major.Strong attention to details, accuracy, and reliability.Advanced Excel skills.Oracle experience.What you'll focus on:Create and maintain automated financial reporting dashboards and datasets.Prepare management reporting packages that provide clear, actionable financial insights.Conduct ad hoc financial analyses to support leadership decision-making.Research industry trends and relevant market insights.Build scenario analyses to evaluate potential business outcomes and support planning.Improve the accuracy and consistency of financial reporting.Document data sources, reporting processes, and underlying logic.Identify opportunities to streamline and automate manual finance processes.What Sets Our Internship Program Apart: Work on meaningful projects while receiving mentorship, professional development, and networking opportunities that help launch your career. Our paid internship program also includes signature experiences like Charter's Intern Kickoff Day, volunteer opportunities, professional development workshops, and the Intern Summer Showcase.What you'll focus on:#LI-AF1#CharterManufacturing#LI-HybridInternship positions are not benefits-eligible.