Business Data Analyst

Job Summary

The Business Data Analyst is responsible for collecting, compiling, analyzing, interpreting, and maintaining data essential to supporting various departments in enhancing transit performance. This role involves analyzing historical service performance data and evaluating the potential impacts of proposed service changes. The position requires proficiency in handling large datasets, applying advanced technical skills, conducting in-depth analysis and research, and generating comprehensive reports to support informed decision‑making.

NOTE: RTS does not provide sponsorship for employment visas at this time; candidates must be authorized to work in the United States without sponsorship.

NOTE: RTS does not cover any moving or relocating expenses.

Director of Business and Data Insights

• Use business intelligence and data analytics best practices to provide timely, relevant, and actionable insights that support monitoring transit performance and guide decision-making across Operations departments.
• Gather, summarize, and prepare data for geospatial and statistical analysis.
• Proficient in data modeling.
• Provide end‑user education and training on data tools and modeling.
• Develop and enhance reporting, analysis, and visualization of performance data, metrics, and measures to enable staff to align with and monitor progress toward overall business strategies, goals, and objectives.
• Create fact sheets, graphs, and written reports on research results.
• Perform advanced data analysis and manipulation of extensive amounts of data using statistical software.
• Query data from a variety of systems to produce data sets for analysis.
• Assist in the preparation of presentations and the communication of results to groups of people.
• Use and apply different statistical tools including trend analysis, root cause analysis, regression analysis, experimental design, statistical modeling, hypothesis testing, and control charting.
• Develop and document the data flow, quality control, and validation methods used for data inputs.

• Other duties as assigned.

• Bachelor's degree in applied mathematics, statistics, data science, or a related field is preferred.
• Minimum of 3 years of full‑time progressively responsible experience in business analysis or a related discipline.
• An equivalent combination of education and experience sufficient to successfully perform the essential duties of the job.

• Strong knowledge of mathematical and statistical tools and accepted procedures and practices.
• Proficiency in SQL for querying and analyzing data.
• Strong Excel skills, including advanced functions, pivot tables, and data manipulation.
• Experience with programming languages (Python, R) or scripting for data analysis (preferred).
• Strong analytical skills.
• Ability to provide solutions and recommendations applicable to transit operations.
• Ability to perform a wide variety of duties requiring considerable judgment to work independently, devising new methods, adapting, or changing standard procedures to meet new conditions.
• Excellent written and verbal communication skills.
• Strong interpersonal and customer service skills.
• Ability to establish effective working relationships and to work across all levels of the organization.
• Strong time‑management skills: ability to coordinate multiple projects simultaneously and set priorities.
• Ability to think critically and strategically.
• Tact, diplomacy, and dependability.
• Detail‑oriented.
• Exceptional computer and math skills.

Required to sit while using hands to finger, handle, or feel objects, tools, or controls; walk, talk, hear, see, and use a computer. Vision abilities include close vision, peripheral vision, depth perception, and the ability to adjust focus. Occasionally required to stand, reach with hands and arms, and stoop, kneel, crouch, or crawl. Must regularly lift and/or move up to 20 pounds.

Noise level is usually moderate. Commercial travel may be required occasionally.

This position is eligible to participate in a hybrid work model. Hybrid work is a flexible working model where employees work partly in the office and partly remote from an approved location. All employees must adhere to the Company Telecommuting Policy & Agreement if they choose to participate in the hybrid work model.