[Hiring] Microsoft Power Platform & Automation Intern @Summary

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description This internship is based in Vail, Colorado. The selected candidate may work remotely, provided they reside in Colorado and are able to travel to Vail periodically throughout the internship. Ready to turn your school projects and side tinkering into real-world impact? We’re looking for a Microsoft Power Platform & Automation Intern to support our District’s Digital Intelligence and Automation Architect in building tools that make work easier and smarter for everyone at ERWSD—and support our mission of protecting water and the environment. If you’ve dabbled in Power Apps, Power Automate, Power Pages, Power BI, PowerShell, or T-SQL and want a place to grow those skills, this role is for you. This role is perfect for a team player with a process improvement mindset—someone who enjoys collaborating with others, solving problems, and turning ideas into practical automations and reports. You’ll help build real solutions—digitized forms, automated approvals, dashboards, and scripts—while learning how modern Microsoft 365 and Power Platform environments run in production. We don’t expect you to be an expert on day one; we’re looking for curiosity, problem-solving, and a willingness to learn. By the end of this internship, you’ll have hands-on experience creating automations, connecting data, and supporting end users in a live environment—plus the satisfaction of knowing your work supports critical services in our community.

Qualifications

• Current enrollment in, or recent completion of, coursework in Information Technology, Computer Science, Information Systems, Data Analytics, or a related field; or equivalent hands-on experience.
• Demonstrated experience (coursework, projects, labs, or work experience) with:
• Microsoft 365 and SharePoint Online (required)
• Power Apps and/or Power Automate (required – strong preference for both)
• Exposure to Power Pages (preferred, strongly desired)
• PowerShell scripting (preferred, strongly desired)
• T-SQL for querying and manipulating data (required)
• Power BI for data visualization and reporting (preferred)
• Python for scripting or data work (preferred)

Requirements

• Assist in creating and maintaining Power Pages sites that provide secure access to forms and data.
• Support the development of Power Automate flows to automate notifications, approvals, and other routine processes.
• Participate in testing and troubleshooting Power Platform solutions and documenting fixes and improvements.
• Assist with configuration and maintenance of SharePoint Online sites, lists, libraries, and permissions to support collaboration and document management.
• Help connect Power Platform solutions to M365 data sources, following governance and security standards.
• Work with senior staff to support Power BI datasets and reports used by departments across the District.
• Use T-SQL to query, filter, and shape data for reporting and analytics.
• Help verify data accuracy and assist with basic data quality checks and troubleshooting.
• Assist with creating and updating PowerShell scripts that support Microsoft 365 administration and reporting (e.g., user and group reports, configuration checks, bulk updates).
• Where appropriate, help develop or maintain Python scripts for data processing or integration tasks, under guidance from senior staff.

Benefits

• This role is a paid internship with the pay range of $23.72 - $33.22/hour.
• Wellness program
• 457 Retirement savings plans
• Paid Holidays and PTO
• $800 Annual Recreation Benefit

Company Description

All District employees must submit to a pre-employment drug screen and extensive background check. We are an Equal Opportunity Employer. We do not discriminate based on race, color, religion, national origin, sex, age, disability, sexual orientation, marital status, genetic information or any other status protected by law or regulation. It is our intention that all qualified applicants be given equal opportunity and that selection decisions are based on job-related factors. Apply tot his job Apply To this Job