Business Data Analyst
Company: Regional Transit Service
Location: Rochester
Posted on: February 17, 2026
|
|
|
Job Description:
Job Description Job Description JOB SUMMARY: The Business Data
Analyst is responsible for collecting, compiling, analyzing,
interpreting, and maintaining data essential to supporting various
departments in enhancing transit performance. This role involves
analyzing historical service performance data and evaluating the
potential impacts of proposed service changes. The position
requires proficiency in handling large datasets, applying advanced
technical skills, conducting in-depth analysis and research, and
generating comprehensive reports to support informed
decision-making. Please note that RTSdoes not provide sponsorship
for employment visas at this time; candidates must be authorized to
work in the United States without sponsorship. Also, RTS does not
cover any moving or relocating expenses. REPORTS TO: Director of
Business and Data Insights SUPERVISES: N/A ESSENTIAL FUNCTIONS:
Utilize business intelligence and data analytics best practices to
provide timely, relevant, and actionable insights that support
monitoring transit performance and guide decision-making across
Operations departments. Gather, summarize, and prepare data for
geospatial and statistical analysis. Proficiency in Data modeling.
End user education and training of data tools and modeling. Develop
and enhance reporting, analysis, and visualization of performance
data, metrics, and measures to enable staff to effectively align
with and monitor progress toward overall business strategies,
goals, and objectives. Develop fact sheets, graphs, and written
reports on research results Perform advanced data analysis and
manipulation of extensive amounts of data using statistical
software. Query data from a variety of systems to produce data sets
for analysis. Assist in the preparation of presentations and the
communication of results to groups of people. Use and apply
different statistical tools including, but not limited to, trend
analysis, root cause analysis, regression analysis, experimental
design, statistical modeling, hypothesis testing, control charting,
etc. Develop and document the data flow, quality control and
validation methods used for data inputs ADDITIONAL
RESPONSIBILITIES: Other duties as assigned. EDUCATION & EXPERIENCE:
Bachelor's degree in applied mathematics, Statistics, Data Science
or a related field is preferred. Minimum of 3 years of full-time
progressively responsible experience in business analysis or a
related discipline An equivalent combination of education and
experience sufficient to successfully perform the essential duties
of the job, such as those listed above KNOWLEDGE, SKILLS &
ABILITIES: Strong knowledge of mathematical and statistical tools
and accepted procedures and practices Proficiency in SQL for
querying and analyzing data Strong Excel skills, including advanced
functions, pivot tables, and data manipulation Experience with
programming languages (Python, R) or scripting for data analysis
(preferred) Strong Analytical skills Ability to provide
solutions/recommendations applicable to transit operations Ability
to perform a wide variety of duties requiring considerable judgment
to work independently, devising new methods, adapting, or changing
standard procedures to meet new conditions Excellent written and
verbal communication skills Strong interpersonal and customer
service skills Ability to establish effective working relationships
and to work across all levels of the organization Strong time
management skills: ability to coordinate multiple projects
simultaneously and set priorities Ability to think critically and
strategically Tact and diplomacy; dependability Detail-oriented
Exceptional computer and math skills PHYSICAL DEMANDS & WORK
ENVIRONMENT: 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. This position is
eligible to participate in a hybrid work model. Hybrid work is a
flexible working model where employees work partly in the office
and partly remote from an approved location. All employees must
adhere to the Company Telecommuting Policy & Agreement if they
choose to participate in the hybrid work model.
Keywords: Regional Transit Service, Buffalo , Business Data Analyst, IT / Software / Systems , Rochester, New York