Business Data Analyst II

JOB SUMMARY:

The Business Data Analyst II is responsible for collecting, compiling, analyzing, interpreting, and maintaining data essential to supporting various departments in enhancing transit service 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

 

COMPENSATION: $30.29-$32.21 per hour (depending on experience)

 

BENEFITS INCLUDE:

• Staying Healthy: Medical, Dental, and Vision (Dental & Vision currently free), Flexible Spending Account (FSA)
• Feeling Secure: Disability Insurance, Pension Plan, NY State Deferred Compensation Plan, Life & Accidental Death & Dismemberment (AD&D) Insurance, Accident Insurance, Group Specified Disease Insurance and Hospital Insurance
• Work-Life Balance: Paid Time Off (PTO: 17 days upon hire; accrue additional time after 1 year), Employee Assistance Program, Paid Holidays, Verizon Wireless Discount, On-site Fitness Center open 24/7, Employee Wellness Program, Culture & Inclusion Council, BJ's Wholesale Club Discount, and more!

Click here to view current medical plan rates!

 

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.
• 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 and the 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.

Please note: RTS does not cover any moving or relocating expenses.

 

ADDITIONAL INFORMATION:

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.