Business Data Analyst

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

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.