Hybrid SDOT Data Analytics Intern chez City of Seattle, WA

About the Department

Join us in shaping Seattle’s streets!
At the Seattle Department of Transportation (SDOT), we don’t just move people, we connect communities, build safer streets, and create a more sustainable city.
With a bold vision for the future, we’re tackling big challenges: making travel safer, cutting carbon emissions, and ensuring reliable, affordable transportation for everyone—no matter who they are or where they live.

Seattle is growing fast, and we’re growing with it. Thanks to a historic voter-approved $1.55 billion investment in transportation in 2024, we’re building sidewalks, fixing bridges, and improving transit connections to keep our city moving.

We’re a team of problem solvers, planners, engineers, communicators, and field crews bringing purpose-driven work to life. Now, we need passionate, innovative talent like you. Let’s build a Seattle that works for everyone together!

Position Overview:
The Data Analytics Intern supports our reporting and data collection work with ongoing projects such as Revive I-5 detour monitoring, implementing a Federal SMART Grant, and other work as assigned. They support collecting usage data on our roadways, double-checking our metrics, crafting new data pipelines, and building out custom reports as needed. This is an opportunity to apply data management and reporting skills to the field of transportation operations. 

Professional Benefits: 
•Contribute to your community while building a rewarding and impactful career by working with the Seattle Department of Transportation (SDOT).
•Engage in meaningful and educational opportunities that align seamlessly with your academic program, enhancing both your knowledge and skills.
•Develop valuable networking connections with experienced professional staff, fostering relationships that can support your future career growth.
•Take advantage of City-sponsored training sessions and professional development modules to expand your expertise and competencies.
•Experience a diverse range of responsibilities and projects that contribute to making Seattle an exceptional place to live, work, and thrive.
•Gain experience working with a diverse ITS engineering and data analytics team.
•Work with SDOT engineers, planners, and managers through our data collection and reporting efforts.
•Use python/Power BI/Tableau as needed to create data flows and reports
•complete special projects as assigned.

Competitive Pay and Benefits:
•Paid sick leave after 90 days of employment.
•Enjoy commuting benefits including ORCA transit passes, bike programs and benefits, guaranteed ride home program, carpool matching, and more.
•Participate in the City's Flash Mentorship program, offering quick and impactful guidance from experienced professionals to support your growth.

Position Duties

10% Supports our data collection and reporting workflows
30% Reviews and crafts new data pipelines using Python or other methods
30% Reviews and crafts new data dashboards using Power BI or Tableau
10% Monitors current data pipelines and dashboards, assessing quality and reliability
10% Coordinates data collection efforts with multiple teams
10% Gathers input and builds requirements for updating reporting from multiple teams.

Minimum Qualifications

Education: 
Open to all undergraduate and graduate students enrolled in an accredited 2-year or 4-year educational program.

Preferred Areas of Study:
Geography, Engineering, Community Environment & Planning, Urban Planning, Computer Science, Information Science, Mathematics, or a related field.

Undergraduate majors must maintain a minimum of 2.0 GPA throughout the internship.

You will be successful in this internship if you have:
•Interest in transportation operations and program evaluation
•Some experience with Python, Power BI, or Tableau.
•High degree of accuracy and attention to detail, 

Desired Qualifications:
•Knowledge and experience with managing datasets in Python.
•Knowledge and experience with creating dashboards in Power BI or Tableau.
•Background in technical report creation and/or program evaluation.

Other Qualifications

Internship dates: 
Start/ End Dates: November 2025 – December 15th, 2026.

Schedule:
Intern will work up-to 20 hours/week while school is in session, up to 40 hours/week during school breaks. Work hours can be scheduled between 8am and 5pm Monday - Friday. May work weekends, may work evenings.

Salary:
Undergraduate students will be paid $21.78-$21.78 per hour.

Your application will not be reviewed if these items are missing or incomplete.

Hiring Process
Applications are reviewed after the posting closes. Your application will not be reviewed if any of these items are missing or incomplete.

1.Completed NEOGOV online application.
2.Cover letter.
3.Resume.
4.Unofficial transcript including current classes and GPA. (Official transcripts will be required at the time of hire.)

For students transitioning from an undergraduate to graduate program, submit admissions offer to the graduate program to confirm intention of fall enrollment

Job offers are contingent on the verification of credentials and other information required by the employment process including the completion of a background check which includes a criminal history review.  

Hybrid Work:
Interns are expected to report to work onsite in Seattle consistent with departmental in-office minimums and as operational needs require for the duration of their internships with the City of Seattle. Therefore, interns are expected to have a Washington State address and reside in Washington State at the start and for the duration of their internships with the City of Seattle.

Who May Apply:
This position is open to all candidates that meet the qualifications. The City of Seattle values diverse perspectives and life experiences. Applicants will be considered regardless of race, color, creed, national origin, ancestry, sex, marital status, disability, religious or political affiliation, age, sexual orientation, or gender identity. The Department encourages people of all backgrounds to apply, including people of color, immigrants, refugees, women, LGBTQ people, people with disabilities, veterans and those with diverse life experiences.

Accommodations for people with disabilities is provided on request.

The City is a Drug Free Workplace.