Trainee Data Analyst Sql Excel Jobs in Rochester, NY

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.