Digital Intelligence Intern

Summary•Vail, CO

4d•Hybrid

About The Position

Eagle River Water and Sanitation District is seeking a Data Engineering Intern to support our Analytics Intelligence Supervisor. This role involves transforming raw operational data into reports, dashboards, and data products to aid decision-making and support the district's mission of protecting water and the environment. The ideal candidate will have experience with SQL, Power BI, Python, and Excel, and a strong curiosity about data flow within an organization. Responsibilities include writing queries, building and maintaining Power BI reports, data wrangling with Python and Power Query, and capturing data "lore" (business rules and institutional knowledge) into semantic models and documentation. The internship offers hands-on experience with production SQL, business-critical reports, version control, modern Python tooling, and data engineering in a live environment, contributing to critical community services.

Requirements

Any combination of coursework, projects, labs, or work experience that demonstrates analytical ability and a foundation in data is qualifying.
T-SQL and relational databases for querying and shaping data
Python or R for data processing or analysis
Power BI for reporting and data modeling
Excel, including Power Query and pivot tables
Git or another version control system
At least one modern code or query editor (VS Code, SSMS, Jupyter, etc.)

Nice To Haves

DAX measures and semantic modeling concepts
Data pipeline tools such as SSIS or Azure Data Factory
Azure data services or data lake concepts
CI/CD concepts and pipelines
Introductory statistics or basic machine learning
Documentation systems such as wikis, Markdown, or SharePoint
Microsoft and other vendor certifications such as: PL-300: Microsoft Power BI Data Analyst, DP-900: Microsoft Azure Data Fundamentals, DP-203: Microsoft Azure Data Engineer Associate, DA-100 / PL-300 study or coursework, or equivalent analytics credentials, DP-600: Fabric Analytics Engineer Associate, DP-700: Fabric Data Engineer Associate

Responsibilities

Help build, maintain, and refine Power BI datasets, reports, and dashboards used by departments across the District.
Write T-SQL queries (joins, filters, aggregates, window functions) to pull, shape, and validate data from SQL Server source systems.
Help build and maintain semantic layers in Power BI (and adjacent tools such as SSAS Tabular or Microsoft Fabric semantic models) that translate raw source data into business-meaningful entities, measures, and dimensions.
Work with senior staff and subject matter experts to capture the “lore” behind the data, the institutional knowledge, business rules, edge cases, and historical context that explain what the data actually means, and convert it into reusable, documented models.
Help expose semantic models for natural-language and self-service exploration (e.g., Power BI Q&A, paginated reports, Excel-connected models) to broaden access to trustworthy data.
Assist senior staff with data quality checks, profiling, and reconciliation between source systems and reporting layers.
Help maintain and document data pipelines that move and transform data for analytics and reporting.
Apply version control (Git) to SQL, Python, and report assets; follow team branching and review conventions.
Write scripts to clean, transform, and analyze data sets.
Use virtual environments and standard scripting tooling to keep work reproducible.
Where appropriate, help integrate scripting work into recurring data processing or reporting workflows.
Help create and maintain documentation for datasets, reports, queries, and pipelines, including data definitions and known caveats.
Participate in team meetings, demos, and reviews; share progress and learn from other team members.
Maintain a positive attitude and work cooperatively with the IT/Analytics team, District employees, vendors, and contractors.