Business Data Analyst

JOB SUMMARY:

The Business Data Analyst is responsible for collecting, compiling, analyzing,interpreting, and maintaining data essential to supporting various departmentsin enhancing transit performance. This role involves analyzing historicalservice performance data and evaluating the potential impacts of proposedservice 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 RTS does not provide sponsorship for employment visas at thistime; candidates must be authorized to work in the United States withoutsponsorship.

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 providetimely, relevant, and actionable insights that support monitoring transitperformance 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 performancedata, metrics, and measures to enable staff to effectively align with andmonitor progress toward overall business strategies, goals, and objectives.Develop fact sheets, graphs, and written reports on research resultsPerform advanced data analysis and manipulation of extensive amounts of datausing 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 resultsto 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 methodsused for data inputs

ADDITIONAL RESPONSIBILITIES:

Other duties as assigned.

EDUCATION & EXPERIENCE:

Bachelor's degree in applied mathematics, Statistics, Data Science or arelated field is preferred.Minimum of 3 years of full-time progressively responsible experience inbusiness analysis or a related disciplineAn equivalent combination of education and experience sufficient tosuccessfully perform the essential duties of the job, such as those listed aboveExcellent Customer Service skills, including but not limited to the abilityto clearly and effectively communicate with customers, are a must.

KNOWLEDGE, SKILLS & ABILITIES:

Strong knowledge of mathematical and statistical tools and acceptedprocedures and practicesProficiency in SQL for querying and analyzing dataStrong Excel skills, including advanced functions, pivot tables, and datamanipulationExperience with programming languages (Python, R) or scripting for dataanalysis (preferred)Strong Analytical skillsAbility to provide solutions/recommendations applicable to transitoperationsAbility to perform a wide variety of duties requiring considerable judgmentto work independently, devising new methods, adapting, or changing standardprocedures to meet new conditionsExcellent written and verbal communication skillsStrong interpersonal and customer service skillsAbility to establish effective working relationships and to work across alllevels of the organizationStrong time management skills: ability to coordinate multiple projectssimultaneously and set prioritiesAbility to think critically and strategicallyTact and diplomacy; dependabilityDetail-orientedExceptional computer and math skills

PHYSICAL DEMANDS & WORK ENVIRONMENT:

The physical demands described here are representative of those that must be metby an employee to successfully perform the essential functions of this job.Reasonable accommodations may be made to enable individuals with disabilities toperform the essential functions.

While performing the duties of this job, the employee is regularly required tosit while using hands to finger, handle, or feel objects, tools, or controls.The employee frequently is required to talk, hear, see, and use a computer.Specific vision abilities required by this job include close vision, colorvision, peripheral vision, depth perception, and the ability to adjust focus.The employee is occasionally required to stand, walk, reach with hands and arms,and stoop, kneel, crouch, or crawl. The employee must regularly lift and/or moveup to 10 pounds and occasionally lift and/or move up to 20 pounds. The noiselevel in the work environment is usually moderate. The employee may occasionallybe required to travel commercially.

ADDITIONAL INFORMATION:

Rochester Genesee Regional Transportation Authority (RGRTA) is committed toequal opportunity for all, without regard to race, religion, color, nationalorigin, citizenship and/or immigration status, sex, sexual orientation, genderidentity, pregnancy, age, veteran status, disability, genetic information, orany other protected characteristic under applicable federal or state law.RGRTA will make reasonable accommodations for known physical or mentallimitations of otherwise qualified employees and applicants with disabilitiesunless the accommodation would impose an undue hardship on the operation of ourbusiness.