This job has closed.

Utah Transit Authority · 1 day ago

Data Reporting and Analytics Intern

Salt Lake City, UT

Internship

Onsite

Intern

$22.86/hr - $22.86/hr

Utah Transit Authority is seeking a Data Reporting and Analytics Intern to assist in developing and supporting reports and dashboards. The role involves writing TSQL scripts, creating ETL processes, and working with various reporting tools.

Association

H1B Sponsor Likely

Responsibilities

Developing and supporting reports and dashboards built in SSRS Reporting, PowerBI, Information Builder

Writing TSQL scripts, Views, and Stored Procedures

Creating ETL process using Microsoft SSIS, TSQL and Stored Procedures

Qualification

SSRSPowerBITSQLETL processesMicrosoft SQL ServerData visualizationAzureCustomer serviceTeamworkCommunication skillsTechnical writing

Required

Junior or senior level student currently enrolled in an accredited college or university, seeking an undergraduate degree in Computer Science, Information Systems or a related field

Must have at least a 3.0 GPA

Experience creating and maintaining SSRS, PowerBI or Tableau reports and dashboard

Experience telling a story using visualization tools

Experience with Data Lake, Azure, Azure SQL etc

Experience with Microsoft SQL Server and TSQL

Experience creating ETL processes using SSIS or other ETL tools

Individuals should work well in a team setting and work well with business users

Must have good communication skills

Must submit a transcript of grades and two letters of recommendation

This job requires regular and predictable attendance

Preferred

Soft skills in writing, technical writing, and customer service are desirable

Benefits

Training, development, and career advancement

Employee assistance program – includes counseling, legal services, financial planning

457 Contribution Plan, available for immediate contributions and company

Free Transit Pass

UTA Well – a comprehensive wellness program designed to support employees and dependents in their health and wellness

Free on-site fitness facilities and discounted membership to VASA

Company

Utah Transit Authority

Provide an integrated system of innovative, accessible and efficient public transportation services that benefit the community

Founded in 1970

Salt Lake City, Utah, USA

1001-5000 employees

http://www.rideuta.com/

H1B Sponsorship

Utah Transit Authority has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (6)

2024 (1)

2023 (1)

2022 (4)