Business Data Analyst

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. Reports To: Director of Business and Data Insights 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. Excellent customer service skills, including but not limited to the ability to clearly and effectively communicate with customers, are a must. 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 talk, hear, see, and use a computer. Specific vision abilities required by this job include close vision, color vision, 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 move up to 10 pounds and occasionally 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. Rochester Genesee Regional Transportation Authority (RGRTA) is committed to equal opportunity for all, without regard to race, religion, color, national origin, citizenship and/or immigration status, sex, sexual orientation, gender identity, pregnancy, age, veteran status, disability, genetic information, or any other protected characteristic under applicable federal or state law. RGRTA will make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodation would impose an undue hardship on the operation of our business. #J-18808-Ljbffr RTS - Regional Transit Service