Business Data Analyst

Regional Transit Service•Rochester, NY

5d•Onsite

About The Position

The Business Data Analyst transforms complex transit data into actionable insights that improve operational performance, service reliability, and strategic decision-making across RTS. Responsible for collecting, compiling, analyzing, interpreting, and maintaining data that supports transit performance. This position analyzes historical service data, evaluates proposed service changes, develops reports, dashboards, and predictive insights using statistical and business intelligence tools. RTS does not provide visa sponsorship or relocation assistance.

Requirements

Bachelor's degree in Applied Mathematics, Statistics, Data Science, or related field.
Minimum three (3) years of progressively responsible business analysis experience, or an equivalent combination of education and experience.
Strong customer service and communication skills.
Statistical analysis
SQL proficiency
Advanced Microsoft Excel
Data modeling and business intelligence
Analytical and critical thinking
Communication and presentation skills
Customer service
Organization and time management
Mathematical and computer skills

Nice To Haves

Experience with business intelligence and data visualization platforms.
Experience with Python and/or R.
Knowledge of public transit operations or transportation analytics.

Responsibilities

Provide actionable business intelligence and analytics.
Gather, summarize, and prepare data for geospatial and statistical analysis.
Develop and maintain data models.
Train end users on reporting tools.
Build dashboards, reports, and visualizations.
Perform advanced statistical analysis.
Query data using SQL.
Prepare presentations and communicate findings.
Apply trend analysis, regression, hypothesis testing, root cause analysis, control charts, and statistical modeling.
Document data flows, quality controls, and validation methods.
Perform other duties as assigned.