Job Description
Job Description
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
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 finger, handle, or feel objects, tools, or controls. The employee frequently is required to walk, talk, hear, see, and use a computer. Specific vision abilities required by this job include close vision, peripheral vision, depth perception, and the ability to adjust focus. The employee is occasionally required to stand, reach with hands and arms, and stoop, kneel, crouch, or crawl.
The employee must regularly lift and/or move up to 20 pounds. The noise level in the work environment is usually moderate. The employee may occasionally be required to travel commercially.
Equal Employment Opportunity
Rochester Genesee Regional Transportation Authority (RGRTA) is committed to providing equal employment opportunities to all applicants and employees without regard to race, color, religion, national origin, citizenship or immigration status, sex, sexual orientation, gender identity, pregnancy, age, veteran status, disability, genetic information, or any other protected characteristic protected by applicable federal, state, or local law. RGRTA will provide reasonable accommodations to qualified applicants and employees with known disabilities unless doing so would impose an undue hardship on the operation of the organization.