Ready to put your data skills to work on real problems? Eagle River Water and Sanitation District is looking for a Data Engineering Intern to support our Analytics Intelligence Supervisor in turning raw operational data into reports, dashboards, and data products that help ERWSD make better decisions while supporting our mission of protecting water and the environment.
The Day to Day
Reporting & Analytics (Power BI + SQL)
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.
Semantic Modeling & Data Knowledge Capture
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.
Data Engineering & Pipelines
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.
Scripting & Automation
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.
Documentation & Collaboration
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.
Compensation: $27.72 - $33.22/hr
Application Deadline: May 18, 2026
Application Website: www.jobs.erwsd.org
