Data Analyst

Regional Transportation Commission of Southern Nevada; Las Vegas (NV); On-site; USD 65,000 - 90,000; Full time

Job summary

Regional Transportation Commission of Southern Nevada seeks a data analyst to collect and analyze agency statistics and evaluate plans and projects for how well they align with agency objectives.

The role requires a bachelor’s degree plus 1 year of professional data analysis experience, and proficiency with SQL, Crystal Reports/SSRS, Tableau/Power BI, and Python, along with strong analytical skills.

Qualifications

• Bachelor’s degree in Business Administration or related field with 1 year of data analysis experience.

Responsibilities

• Analyze agency statistics and evaluate plans, programs and projects for their ability to meet agency objectives.
• Prepare reports and presentations; analyze data and ensure data integrity.
• Discuss BI needs with internal and external customers and provide data-driven insights.

Skills

T-SQL

Crystal Reports

SSRS

Tableau

Power BI

Python

Critical thinking

Education

Bachelor's degree in Business Administration or related field

Tools

Tableau

Power BI

Job description

**Although there is a salary range for this position, salary will be negotiated depending on experience.**

Relocation expenses will not be covered by the RTC for this position.

Collects and analyzes agency statistics and information; prepares and/or analyzes and evaluates existing and proposed plans, programs and projects for their ability to meet agency objectives.

FLSA STATUS: Exempt

Working Conditions: May work shifts on days, evenings, weekends, and holidays.

Education and Experience: Equivalent to Bachelor's degree in Business Administration or a closely related field and one (1) year of full-time professional data analysis experience.

Licensing and Certification: Must possess and maintain a valid Class C Driver's License at time of application.

Background Investigation: Employment with the Regional Transportation Commission in this position is contingent upon the results of a comprehensive education/experience background investigation, a criminal history record, and driving history check.

• 1. Ability to compose and modify Microsoft T-SQL Queries
• 2. Ability to use Crystal Reports and/or SSRS report writing software
• 3. Ability to create and modify dashboards using Tableau and/or Power BI software
• 4. Ability to perform statistical analyses using Python
• 5. Ability to use critical analysis skills to solve problems accurately

Physical ability to perform field, office and related work, including operating computers and office machinery; stamina to sit for extended periods of time; strength to lift and maneuver materials weighing up to 25 pounds; vision to read printed materials; and hearing and speech to communicate in person or over the telephone. Accommodations may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodations.

Performs analysis and evaluation of existing or proposed agency services to include: plans, programs, projects and policies. Utilizes databases of information to create agency reports; assures integrity of data; utilizes software programs for retrieval of historical data, requests for information, summary reports and ad hoc analyses. Composes reports and presentations as required for evaluation of agency operational functions. Discusses Business Intelligence needs or information with external and internal customers. Identifies and documents agency data problems, needs, and issues. Research and respond to customer service complaints. Operates a variety of office equipment, to include computers and associated software. Provides information and assistance to internal and external customers as required. Performs other similar and related duties as assigned.