Operations Analyst

OhioX; Columbus, Northern (OH, KY); Hybrid; USD 70,000 - 83,000; Full time

Benefits offered by this job

Medical, Vision, Dental, Supplemental,

Life Insurance

Paid Parental Leave

Employee Discounts

COTA Bus Pass

Wellness Initiatives

On-Site Chair Massage

On-Site Health Coach

Tuition Reimbursement

Student Loan Repayment Program

OPERS/Public Pension

Ohio Deferred Compensation

Job summary

Ohio-based organization COTA seeks an Operations Analyst to provide comprehensive data analysis and reporting for the Transportation department. You will develop KPIs, dashboards, and executive summaries to inform decision-making and drive improvements.

Role emphasizes data governance, cross-functional collaboration, and strong attention to detail, with a focus on turning complex data into actionable insights for leadership. Equal opportunity employer.

Qualifications

• Bachelor's degree in business administration, data analytics, statistics, mathematics, or related field.
• Minimum of three (3) years' experience in data analytics and reporting.
• Relevant data analytics or project management certification preferred.

Responsibilities

• Collect, extract, validate, and analyze Transportation operational data from multiple systems to ensure accuracy and timeliness.
• Develop, maintain, and improve reports, dashboards, scorecards, KPIs, and executive summaries.
• Analyze service-reliability measures and related causes to inform improvements.
• Identify trends, root causes, performance gaps, and opportunities; provide insights and recommendations.
• Prepare recurring and ad hoc reports, presentations, audits, and analyses for Transportation leadership.
• Coordinate with multiple departments to validate data and standardize KPI definitions.

Skills

Data analytics

Reporting

KPI development

Critical thinking

Attention to detail

Communication skills

Problem solving

Excel

Data visualization

Independent work

Education

Bachelor's degree in business administration

Bachelor's degree in data analytics

Bachelor's degree in statistics

Bachelor's degree in mathematics

Related field

Certificaton in data analytics or project management

Tools

Tableau

Power BI

Infor

WFM

Job description

SALARY: $70,304.00 - $82,721.60

LOCATION: 1600 McKinley Ave Columbus, OH 43222

BENEFITS:

• Medical, Vision, Dental, Supplemental and Life Insurance
• Paid Parental Leave
• Employee Discounts
• COTA Bus Pass
• Wellness Initiatives
• On-Site Chair Massage
• On-Site Health Coach
• Tuition Reimbursement
• Student Loan Repayment Program
• Public Pension through OPERS & Ohio Deferred Compensation

POSITION SUMMARY:

COTA's Operations Analyst performs professional work providing comprehensive data analysis and reporting for the Transportation department. This position is responsible for developing and presenting performance metrics, KPIs, and other operational data used to inform process improvement initiatives.

Performs duties that advance COTA's Strategic Plan and reflect the organization's core values of safety, empowerment, accountability, teamwork, and service, and support the mission of Moving Every Life Forward.

ESSENTIAL JOB FUNCTIONS:

• Collect, extract, validate, and analyze Transportation operational data from multiple systems and sources to ensure accuracy, consistency, and timely reporting;
• Develop, maintain, and improve reports, dashboards, scorecards, KPIs, trend analyses, and executive-level summaries to monitor Transportation performance and support leadership decision-making;
• Analyze service-reliability measures, including but not limited to on-time performance, scheduled and impacted blocks, missed trips, lost service hours, late pull-outs, excessive service gaps, cut service, and related causes;
• Identify trends, root causes, performance gaps, and areas of opportunity; develop insights and recommendations to support process improvements and evaluate potential solutions;
• Prepare recurring and ad hoc reports, presentations, briefing materials, audits, and special analyses for Transportation leadership;
• Coordinate with Transportation, Planning, Scheduling, Innovation & Technology, and other departments to validate data, reconcile reporting differences, standardize KPI definitions, and improve reporting processes;
• Establish and maintain data governance practices, including data dictionaries, calculation methodologies, reporting schedules, and quality-control procedures; and
• Support improvements to Transportation workflows, reporting tools, information storage, and operating practices by using data to measure outcomes, monitor progress, and inform adjustments.
• Organize and maintain Transportation SOPs, policies, and related records, including document ownership, approval status, revision history, effective dates, required review dates, and archived versions;
• Track assigned Transportation projects, initiatives, deliverables, decisions, and action items, and provide analytical or project support for other Transportation initiatives as assigned;
• Regular, predictable and punctual attendance required; and,
• Performs other duties as assigned.
• Knowledge of Trapeze, Vontas, or similar platforms used for transportation operations management.
• Experience using Tableau, Power BI, or similar data visualization tools.
• Knowledge of Infor, WFM, or other HRIS and time management tools/platforms.
• Exceptional attention to detail and the ability to validate data, identify inconsistencies, and maintain accurate records.
• Strong analytical, critical-thinking, research, and problem-solving skills, including the ability to interpret operational information and present meaningful conclusions.
• Proficiency with Microsoft Excel, including formulas, pivot tables, charts, data validation, and analysis; proficiency with the Microsoft Office suite required.
• Ability to learn and use business-intelligence, dashboard, database, document-management, and transit-operating systems.
• Knowledge of KPI development, percentage calculations, trend analysis, data visualization, report preparation, and quality-control practices.
• Knowledge of SOP development, document control, version management, records organization, and continuous-improvement practices.
• Strong organizational, project-coordination, and time-management skills, with the ability to manage competing priorities and meet recurring deadlines.
• Excellent written and verbal communication skills and the ability to translate complex data into clear reports, presentations, and recommendations for varied audiences.
• Ability to work independently, exercise sound judgment, collaborate across departments, and handle operational information with appropriate discretion.

MINIMUM EDUCATION & EXPERIENCE REQUIRED:

• Requires a bachelor's degree in business administration, data analytics, statistics, mathematics, or related field and minimum of three (3) years' experience in data analytics and reporting. Experience analyzing transportation data and reporting on operational performance preferred.
• A relevant data analytics or project management certification preferred.

COTA is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. All employment decisions are based on job needs, job requirements and individual qualifications, without regard to race, color, religion or belief, sex, sexual orientation, age, genetic information, gender identity, national origin, veteran or disability status