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.

Please note that RTS does not provide sponsorship for employment visas at this time; candidates must be authorized to work in the United States without sponsorship. Also, RTS does not cover any moving or relocating expenses.

Director of Business and Data Insights

• Utilize 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.
• Proficiency in data modeling.
• End user education and training of data tools and modeling.
• Develop and enhance reporting, analysis, and visualization of performance data, metrics, and measures to enable staff to effectively align with and monitor progress toward overall business strategies, goals, and objectives.
• Develop 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, but not limited to, trend analysis, root cause analysis, regression analysis, experimental design, statistical modeling, hypothesis testing, control charting, etc.
• Develop and document the data flow, quality control and validation methods used for data inputs.

• Other duties as assigned.

• Preferred:
  Bachelor's degree in applied mathematics, Statistics, Data Science or a related field.
• Minimum of 3 years of full-time progressively responsible experience in business analysis or a related discipline.
• Equivalent combination of education and experience sufficient to successfully perform the essential duties of the job, such as those listed above.
• Excellent customer service skills, including but not limited to the ability to clearly and effectively communicate with customers, are a must.

• 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/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 and diplomacy; dependability.
• Detail‑oriented.
• Exceptional computer and math skills.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to sit while using hands to…