Microsoft Power Platform & Automation Intern

Summary•Vail, CO

1d•Hybrid

About The Position

We are looking for an energetic and curious IT professional to join our team as a Microsoft Power Platform & Automation Intern. This role supports the District’s Digital Intelligence and Automation Architect in designing, building, and supporting Microsoft 365 and Power Platform solutions that streamline processes and improve access to data. The ideal candidate has a strong foundation in Microsoft 365, Power Platform (Power Apps, Power Automate, Power Pages, Power BI), PowerShell, and T-SQL, and is excited to learn how to apply these tools in a real-world environment. This role is perfect for a team player who enjoys collaborating with others, solving problems, and turning ideas into practical automations and reports. This is a fully remote position; however, the selected candidate must live locally in Colorado and have the ability to travel to Vail during their internship a handful of times. If you are a Microsoft 365 and Power Platform enthusiast looking for a progressive but stable organization that has a direct environmental impact, then we could be the employer for you. You’ll work side-by-side with our Digital Intelligence and Automation Architect, gaining hands-on experience with modern tools and real production environments. We hear from our employees consistently that the people at ERWSD are the best part of working here. So, if you want to grow your skills, work with great people, and contribute to meaningful work that supports our community and environment, you should definitely apply for this internship!

Requirements

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)
Demonstrated experience (coursework, projects, labs, or work experience) with: Power Apps and/or Power Automate (required – strong preference for both)
Demonstrated experience (coursework, projects, labs, or work experience) with: T-SQL for querying and manipulating data (required)

Nice To Haves

Exposure to Power Pages (preferred, strongly desired)
PowerShell scripting (preferred, strongly desired)
Power BI for data visualization and reporting (preferred)
Python for scripting or data work (preferred)
Microsoft certifications such as: PL-900: Power Platform Fundamentals
Microsoft certifications such as: PL-100: Power Platform App Maker
Microsoft certifications such as: PL-200: Power Platform Functional Consultant
Microsoft certifications such as: MS-900: Microsoft 365 Fundamentals

Responsibilities

Help design, build, and maintain Power Apps (primarily canvas apps) to digitize forms and workflows.
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.
Help create and maintain technical documentation, runbooks, and “how-to” guides for Power Platform solutions and recurring tasks.
Assist with preparing materials or simple demos to help end users understand new tools and automations.
Help the IT team deliver modern, automated solutions that support departments across the District.
Contribute to projects that improve how staff access information, complete tasks, and use data to make decisions.
Stay informed about new features and capabilities in Microsoft 365, Power Platform, PowerShell, and data tools.
Take advantage of training opportunities, coaching from the Digital Intelligence and Automation Architect, and hands-on project work to grow your skills.
Align with District values in all aspects of work.
Be a motivated, driven self-starter who takes ownership of assigned tasks, asks good questions, and is eager to learn from feedback.