Data Reporting and Analytics Intern at Utah Transit Authority – Salt Lake City, Utah

Utah Transit Authority

Description

Job Summary

Responsibilities will include developing and supporting reports and dashboards built in SSRS Reporting, PowerBI, Information Builder. Will also include writing TSQL scripts, Views, and Stored Procedures. Creating ETL process using Microsoft SSIS, TSQL and Stored Procedures.

This will be a part-time internship located in Salt Lake City, Utah working in office. Hours are flexible and will not exceed 29 hours per week.

Minimum Qualifications

EDUCATION/TRAINING

• 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

• 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.
• Soft skills in writing, technical writing, and customer service are desirable.
• Must have good communication skills.
• Must submit a transcript of grades and two letters of recommendation.

This job requires regular and predictable attendance

- OR - An equivalent combination or relevant education and experience.

UTA’s benefits package for interns and temp employees includes:

• 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

For more information on UTA’s Total Rewards benefits package, please visit: https://jobs.jobvite.com/rideuta/#benefits

Pay Rate: $22.86 Per Hour

Closed date: Open until filled

PM21

Utah Transit Authority is an Equal Opportunity Employer of all persons regardless of race, color, religion, sex, national origin, age, disability, covered veterans, sexual orientation, and gender identity. Women, minorities, and people with disabilities are encouraged to apply. Applicants needing an accommodation under the Americans with Disabilities Act for any part of the application process should contact UTA Human Resources at 801-287-2324. A minimum of two work days' notice prior to the need for the accommodation is required.

Utah Transit Authority is a drug-free workplace, subject to federal drug and alcohol testing regulations under 49 CFR Part 40, 655, and 219. All offers for employment are contingent upon a successful pre-employment drug test. If a pre-employment test returns a non-negative result, an application for employment may be rejected. All employees are subject to reasonable suspicion and post-accident testing for drug and alcohol use. All safety sensitive employees are subject to random testing for drug and alcohol use.