Backed by more than a century of engineering excellence in thermal management technology, Modexus Solutions has sharpened its focus as a specialized leader in commercial HVAC and data center solutions into a new era. Throughout this evolution, our dynamic and collaborative culture, driven by our talented people, has propelled us to the forefront of the industry on a new frontier. At Modexus Solutions, we foster an environment of entrepreneurship and ingenuity, empowering our team to continually drive innovation. Joining Modexus Solutions means unlocking meaningful career growth, continuous development, and high-impact opportunities. The answer is clear: your next opportunity starts here. Transform the future with us. 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 Modexus Solutions?
Health & Well-being:
- Competitive Health, Dental & Vision Insurance Coverage on Day One!
- Additional Benefits After 90 days of Continuous Employment
- 8 weeks of short term disability leave paid at 100%
- 4 weeks of paid parental leave paid at 100%
- Maternity Leave (12 weeks at 100% pay)
- Paternity Leave (4 weeks at 100% pay)
Financial Benefits:
- 401k Retirement plan and company match
- Life Insurance
- Health Savings Account (HSA) with employer contribution
- Flexible Spending Accounts (FSA)
- Short Term Disability (company paid)
- Long Term Disability
To view full benefits information: MyModine Benefits
The salary 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.