Business Data Analyst
Department: Business and Data Insights
Reports To: Director of Business and Data Insights
Compensation: $27.90–$29.80 per hour (based on experience)
____________________________________________________________
Make an Impact at RTS
At RTS, we connect our community to the people, places, and opportunities that matter most.
____________________________________________________________
Why Join RTS?
Staying Healthy
• Medical, Dental & Vision Insurance
• Flexible Spending Account (FSA)
Feeling Secure
• Pension Plan
• NYS Deferred Compensation Plan
• Life, Disability & Supplemental Insurance
• Paid Time Off
• Paid Holidays
• Employee Assistance Program
• Wellness Programs
• Employee Discounts
• Public Service Loan Forgiveness (PSLF)
____________________________________________________________
About the Role
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.
____________________________________________________________
What You'll Do
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.
____________________________________________________________
What We're Looking For
Required Qualifications
• 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.
Preferred Qualifications
• Experience with business intelligence and data visualization platforms.
• Experience with Python and/or R.
• Knowledge of public transit operations or transportation analytics.
_________________________________________________________
Knowledge, Skills & Abilities
• Statistical analysis
• SQL proficiency
• Advanced Microsoft Excel
• Python and/or R (preferred)
• Data modeling and business intelligence
• Analytical and critical thinking
• Communication and presentation skills
• Customer service
• Organization and time management
• Mathematical and computer skills
____________________________________________________________
Working Conditions & Physical Requirements
Primarily office environment requiring prolonged sitting and computer use. Regular talking, hearing, and close vision. Occasional standing, walking, bending, lifting up to 20 pounds, and commercial travel. Reasonable accommodations may be made.
____________________________________________________________
Additional Information
RGRTA maintains a zero-tolerance drug and alcohol policy in accordance with Department of Transportation (DOT) and Federal Transit Administration (FTA) regulations. All applicants for this safety-sensitive position must successfully complete a pre-employment drug screening and will be subject to ongoing drug and alcohol testing throughout employment as required by law.
Equal Employment Opportunity
RGRTA is committed to providing equal employment opportunities to all applicants and employees without regard to race, religion, color, national origin, citizenship or immigration status, sex, sexual orientation, gender identity, pregnancy, age, veteran status, disability, genetic information, or any other protected characteristic under applicable law.
Reasonable accommodations will be provided for qualified individuals with disabilities unless doing so would create an undue hardship.