Engineering/Program Management Intern

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.

Why Choose Modine?

Health & Well-being:

• 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)

Financial Benefits:

• 401k Retirement plan and company paid match
• Life Insurance
• Health Savings Account (HSA) with employer contribution
• Flexible Spending Accounts (FSA)
• Short Term Disability (company paid)
• Long Term Disability

Work-Life Balance:

• Competitive time-off policies
• Tuition Reimbursement

To view full benefits information: MyModine Benefits