Engineering/Program Management Intern

Modine; Racine (WI); On-site; USD 33,000 - 36,000; Full time

Benefits offered by this job

Day One benefits

401k with company match

Life Insurance

Health Savings Account (HSA)

Job summary

Modine seeks an Intern/Project Coordinator – Tooling & Automation Specialist to develop and maintain automated workflows in the Microsoft 365 ecosystem. You’ll design data pipelines, dashboards, and tools to support project and portfolio management, with a focus on automation (90%) and lightweight coordination (10%).

The role emphasizes Power Automate, SharePoint/Lists, Excel (Power Query), and Power BI, with opportunities to implement a new PPM platform and collaborate with cross‑functional

Qualifications

• 2–5 years in project coordination, PMO operations, or tooling/automation roles.
• Ability to map processes into automated workflows.
• Strong analytical and problem‑solving skills with attention to detail.
• Effective written and verbal communication.

Responsibilities

• Design, build, and maintain automated workflows using SharePoint/Lists, Excel, and Microsoft 365 tools.
• Develop and manage data pipelines: extraction, transformation, validation, and refresh.
• Create and support dashboards and reports with accurate data presentation.
• Configure project/tools like SharePoint, Planner, Jira, or Smartsheet according to team usage.
• Build self‑service tools, templates, and forms for intake, approvals, reporting, and portfolio mgmt.
• Develop lightweight scripts (VBA or Python) to streamline data tasks.
• Collaborate with stakeholders to identify process gaps and implement tech solutions.
• Document tools and workflows, including user guides and troubleshooting.
• Opportunity to work on selecting and implementing a new PPM platform.
• Assist with maintaining project documentation: status updates, RAID logs, schedules.
• Support meetings, follow‑ups, and governance processes.

Tools

Power Automate

SharePoint/Lists

Excel (Power Query)

Power BI

Jira

Smartsheet

Planner

VBA

Python

DAX

Job description

For more than 100 years, Modine has solved the toughest thermal management challenges for mission-critical applications. Our purpose of Engineering a Cleaner, Healthier World™ means we are always evolving our portfolio of technologies to provide the latest heating, cooling, and ventilation solutions. Through the hard work of more than 11,000 employees worldwide, our Climate Solutions and Performance Technologies segments advance our purpose with systems that improve air quality, reduce energy and water consumption, lower harmful emissions, enable cleaner running vehicles, and use environmentally friendly refrigerants. Modine is a global company headquartered in Racine, Wisconsin (U.S.), with operations in North America, South America, Europe, and Asia. For more information about Modine, visit modine.com .

Position Description

The Intern/Project Coordinator – Tooling & Automation Specialist is responsible for developing, maintaining, and improving the technical tools and automated workflows that support project and portfolio management activities. Approximately 90% of this role focuses on automation, data pipelines, reporting solutions, and tool administration, with the remaining 10% dedicated to light project coordination support.

The ideal candidate is highly skilled in the Microsoft 365 ecosystem, especially Power Automate, SharePoint/Lists, Excel (Power Query), and Power BI. This role is well-suited for someone who enjoys optimizing processes, reducing manual work, and enabling teams through well‑designed digital solutions.

Key Responsibilities

Tooling, Automation & Reporting (Primary – 90%)

• Design, build, and maintain automated workflows using SharePoint/Lists, Excel, and other Microsoft 365 tools.
• Develop and manage data pipelines, including data extraction, transformation, validation, and refresh processes.
• Create and support dashboards and reports ensuring accuracy, reliability, and clear data presentation.
• Configure and administer project and work management tools such as SharePoint, Planner, Jira, or Smartsheet (depending on team usage).
• Build self‑service tools, templates, and forms for intake, approvals, reporting, and portfolio management.
• Develop lightweight scripts (VBA or Python, as applicable) to streamline data processing or reporting tasks.
• Partner with stakeholders to identify process gaps and implement technology-driven solutions.
• Document tools, workflows, and processes, including user guides and troubleshooting documentation.
• Opportunity to work on the selection and implementation of new PPM Platform

Project Coordination Support (Secondary – 10%)

• Assist with maintaining project documentation such as status updates, RAID logs, and schedules.
• Support coordination of project meetings, follow‑ups, and communication as needed.
• Help ensure consistent application of PMO templates, standards, and governance processes.
• Contribute to the organization and visibility of project and portfolio information.

Qualifications

Required

• 2–5 years of experience in project coordination, PMO operations, business analysis, or a tooling/automation-focused role.
• Demonstrated ability to map processes and translate them into automated workflows.
• Strong analytical and problem‑solving skills with high attention to detail.
• Effective written and verbal communication skills.

Preferred

• Experience with Jira, Smartsheet, Plainview, Monday or other PPM Platforms.
• Familiarity with Agile or hybrid project delivery frameworks.
• Experience with VBA, Python, or DAX.
• CAPM, PMP, or Agile certification.

Required Education & Qualifications

Tooling, Automation & Reporting (Primary – 90%)

• Design, build, and maintain automated workflows using SharePoint/Lists, Excel, and other Microsoft 365 tools.
• Develop and manage data pipelines, including data extraction, transformation, validation, and refresh processes.
• Create and support dashboards and reports ensuring accuracy, reliability, and clear data presentation.
• Configure and administer project and work management tools such as SharePoint, Planner, Jira, or Smartsheet (depending on team usage).
• Build self‑service tools, templates, and forms for intake, approvals, reporting, and portfolio management.
• Develop lightweight scripts (VBA or Python, as applicable) to streamline data processing or reporting tasks.
• Partner with stakeholders to identify process gaps and implement technology-driven solutions.
• Document tools, workflows, and processes, including user guides and troubleshooting documentation.
• Opportunity to work on the selection and implementation of new PPM Platform

Project Coordination Support (Secondary – 10%)

• Assist with maintaining project documentation such as status updates, RAID logs, and schedules.
• Support coordination of project meetings, follow‑ups, and communication as needed.
• Help ensure consistent application of PMO templates, standards, and governance processes.
• Contribute to the organization and visibility of project and portfolio information.

Qualifications

Required

• 2–5 years of experience in project coordination, PMO operations, business analysis, or a tooling/automation-focused role.
• Demonstrated ability to map processes and translate them into automated workflows.
• Strong analytical and problem‑solving skills with high attention to detail.
• Effective written and verbal communication skills.

Preferred

• Experience with Jira, Smartsheet, Plainview, Monday or other PPM Platforms.
• Familiarity with Agile or hybrid project delivery frameworks.
• Experience with VBA, Python, or DAX.
• CAPM, PMP, or Agile certification.

Why Choose Modine?

• Day One
  • Competitive health, dental & vision insurance coverage
  • Employee Assistance Program
• After 90 days of continuous employment
  • Maternity Leave (12 weeks at 100% pay)
    • 8 weeks of short term disability leave paid at 100%
    • 4 weeks of paid parental leave paid at 100%
  • Paternity Leave (4 weeks at 100% pay)
• 401k Retirement plan and company paid match
• Life Insurance
• Health Savings Account (HSA) with employer contribution

Modine is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law. Modine provides a competitive benefit package, which could include paid vacation, short term disability, 401(k), health, dental, vision, life insurance, flex spending benefits, tuition reimbursement, Health Savings Account and much more. Human Resources will provide more detail upon your hiring.

#LI-SC1

The wage range for this position is estimated in good faith to be $24-$26 per hour. The specific offer will depend on the candidate’s qualifications, experience, and other job-related considerations but will be within the stated range. Where required by applicable law, a general description of benefits and other compensation offered for this role is also provided or made available.

This position is not eligible for any form of sponsorship (e.g. OPT or H1B visa status) now or in the future. Only individuals authorized to work in the United States now and for the foreseeable future will be considered for this position.